<?php
/**
* Include the Pdofy class so that you can create its objects
* Recommended to use `require` over `require_once` for its performance gain
* Recommended to use `require` over `include` as former shall exit on failure
*/
require './pdofy.php';
/**
* Include the information to connect to the Database
* $host - Hostname, normally 'localhost'
* $dbName - Name of the Database
* $user - Database username
* $pass - Database password
*/
$host = 'localhost';
$dbName = 'pdofy';
$user = 'pdofyUser';
$pass = 'pdofyPass';
/**
* Create the Pdofy object to connect to the database
*/
$db = new Pdofy($host, $dbName, $user, $pass);
/**
* A simple database statement to insert data into the table
* Rather than using string concatenation to construct the statement,
* use parameterized queries as shown below
* This simple database statement shall insert an `email` into the table
*/
$query = 'INSERT INTO tableName(email) VALUES(:email)';
$array = array(
'email' => '[email protected]'
);
$db->queryDb($query, $array);
/**
* A simple database statement to delete data from the table
* Rather than using string concatenation to construct the statement,
* use parameterized queries as shown below
* This simple database statement shall delete a row from the table,
* that matches the email
*/
$query = 'DELETE FROM tableName WHERE email = :email';
$array = array(
'email' => '[email protected]'
);
$db->queryDb($query, $array);
/**
* A simple database statement to delete the table
* This method does not require any extra parameters
*/
$query = 'DROP TABLE tableName';
$db->queryDb($query);
/**
* A simple database statement to query the table
* Rather than using string concatenation to construct the statement,
* use parameterized queries as shown below
* This simple database statement shall retrieve an email
* that matches the id and display it
*/
$query = 'SELECT email FROM tableName WHERE id = :id';
$array = array(
'id' => 1
);
print_r($db->fetchRow($query, $array));
/**
* A simple database statement to query the table
* Rather than using string concatenation to construct the statement,
* use parameterized queries as shown below
* This simple database statement shall retrieve all emails
* from the table and display
*/
$query = 'SELECT email FROM tableName';
print_r($db->fetchRow($query));
/**
* A simple database statement to query the table
* Rather than using string concatenation to construct the statement,
* use parameterized queries as shown below
* This simple database statement shall retrieve all emails
* from the table that matches the condition and display it in column form
*/
$query = 'SELECT email FROM tableName WHERE id >= :id';
$array = array(
'id' => 1
);
print_r($db->fetchColumn($query, $array));
/**
* A simple database statement to query the table
* Rather than using string concatenation to construct the statement,
* use parameterized queries as shown below
* This simple database statement shall retrieve all emails
* from the table that matches the condition and display it in column form
*/
$query = 'SELECT name, email FROM tableName WHERE id >= :id';
$array = array(
'id' => 1
);
print_r($db->fetchColumn($query, $array, $arg = 1));
|
Download
