*/ 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(); echo "// select with fields and one where condition #1"; // set fields for table $selectFields = array('customerNumber', 'customerName', 'contactLastName', 'contactFirstName', 'phone'); // set where condition $whereConditions = array('customerNumber' => 103); // select with where and bind param use select method $q = $p->select('customers', $selectFields, $whereConditions)->traceEnable()->results(); // print array result PA($q); echo "// select with fields and two where condition #2"; // set fields for table $selectFields = array('customerNumber', 'customerName', 'contactLastName', 'contactFirstName', 'phone'); // set where condition $whereConditions = array('customerNumber' => 103, 'contactLastName' => 'Schmitt'); // select with where and bind param use select method $q = $p->select('customers', $selectFields, $whereConditions)->traceEnable()->results(); // print array result PA($q); echo "// select with fields and LIMIT clause condition #3"; // set fields for table $selectFields = array('customerNumber', 'customerName', 'contactLastName', 'contactFirstName', 'phone'); // set where condition
// include pdo class wrapper 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); // Example -1 $selectFields = array('customerNumber', 'customerName', 'contactLastName', 'contactFirstName', 'phone'); // set where condition $whereConditions = array('customerNumber' => 103); // select with where and bind param use select method $q = $db->select('customers', $selectFields, $whereConditions)->showQuery()->results(); // print array result PDOHelper::PA($q); // Example -2 $whereConditions = array('lastname =' => 'bow', 'or jobtitle =' => 'Sales Rep', 'and isactive =' => 1, 'and officecode =' => 1); $data = $db->select('employees', array('employeenumber', 'lastname', 'jobtitle'), $whereConditions)->showQuery()->results(); // print array result PDOHelper::PA($q); // Example -3 $whereConditions = array('lastname =' => 'bow', 'or jobtitle =' => 'Sales Rep', 'and isactive =' => 1, 'and officecode =' => 1); // select with where and bind param use select method $q = $db->select('employees', array('employeeNumber', 'lastName', 'firstName'), $whereConditions)->showQuery()->results(); // print array result PDOHelper::PA($q); // Example -4 $selectFields = array('customerNumber', 'customerName', 'contactLastName', 'contactFirstName', 'phone');
public function databaseTest() { $db = new PdoWrapper(); $result = $db->select("test")->results(); pad($result); }