include_once '../class/class.pdowrapper.php';
// database connection setings
$dbConfig = array("host" => "localhost", "dbname" => 'sampledb', "username" => 'root', "password" => '');
// get instance of PDO Wrapper object
$db = new PdoWrapper($dbConfig);
// get instance of PDO Helper object
$helper = new PDOHelper();
// set error log mode true to show error on screen or false to log in log file
$db->setErrorLog(true);
/**
* run simple mysql query
*
* showQuery = display executed query
* results = get array results
*/
$q = $db->pdoQuery('select * from customers limit 5;')->showQuery()->results();
// print array result
$helper->PA($q);
/**
* run simple mysql query with where clause
* pass where value as an parametrised array
*
* ? presenting place holder here for where clause values
*/
$q = $db->pdoQuery('select * from customers where (customernumber = ? OR customernumber = ?) ;', array(103, 119))->showQuery()->results();
// print array result
$helper->PA($q);
/**
* run simple mysql query and get third row of array results
*
* result(2) = will return 3rd row of array data
<?php
/**
* Function to print array with pre tag
*
* @param array $array
*/
function PA($array)
{
echo '<pre>', print_r($array, true), '</pre>';
}
// include pdo class wrapper
include_once 'class.pdowrapper.php';
// create new object of class wrapper
$p = new PdoWrapper();
// select query with limit
$q = $p->pdoQuery('select * from customers;')->results();
// print array result
// PA($q); die;
// select query with limit
$q = $p->pdoQuery('select * from customers;')->results('xml');
// print xml result
// echo $q; die;
// select query with limit
$q = $p->pdoQuery('select * from customers;')->results('json');
// print json result
// echo $q; die;
<?php
/**
* Function to print array with pre tag
*
* @param array $array
*/
function PA($array)
{
echo '<pre>', print_r($array, true), '</pre>';
}
// include pdo class wrapper
include_once 'class.pdowrapper.php';
// create new object of class wrapper
$p = new PdoWrapper();
// select query #1
$q = $p->pdoQuery('select * from customers limit 5;')->traceEnable()->results();
PA($q);
// select query with where condition and bind param #2
$q = $p->pdoQuery('select * from customers where customernumber = ?;', array(103))->traceEnable()->results();
// print array result
PA($q);
// select query and get 2nd row of result array #3
$q = $p->pdoQuery('select * from customers;')->traceEnable()->result(2);
// print array result
PA($q);
// select query with multiple condition and bind param #4
$q = $p->pdoQuery('select * from customers where (customernumber = ? or contactLastName = ?) ;', array(112, 'Schmitt'))->traceEnable()->results();
// print array result
PA($q);
