<?php // include pdo helper class to use common methods include_once '../class/class.pdohelper.php'; // 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); // select query with limit $q = $db->pdoQuery('select * from customers;')->results(); // print array result $helper->PA($q); // select query with limit $q = $db->pdoQuery('select * from customers;')->results('xml'); // print xml result echo $q; // select query with limit $q = $db->pdoQuery('select * from customers;')->results('json'); // print json result echo $q;
<?php require_once 'database/SQLConstants.php'; // include pdo helper class to use common methods require_once 'PDO_Class_Wrapper/class/class.pdohelper.php'; // include pdo class wrapper require_once 'PDO_Class_Wrapper/class/class.pdowrapper.php'; if (!isset($_SESSION)) { session_start(); } ?> <?php // database connection setings $dbConfig = array("host" => $host, "dbname" => $db, "username" => $username, "password" => $password, "charset" => $charset); // 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(false);