/** * Application bootstrap configuration */ protected static function _setAppConfig() { /* paths */ static::option('paths', Module::merge(ptc_path('root') . '/app/config/paths.php')); ptc_add_path(ptc_array_get(static::$_config, 'paths')); /* application */ static::option('app', Module::merge(ptc_path('root') . '/app/config/app.php')); HandyMan::addAlias(ptc_array_get(static::$_config, 'app.aliases')); if ($locale = ptc_array_get(static::$_config, 'app.locale')) { setlocale(LC_ALL, $locale . 'UTF-8'); } if ($timezone = ptc_array_get(static::$_config, 'app.timezone')) { date_default_timezone_set($timezone); } ptc_add_file(ptc_array_get(static::$_config, 'app.files')); ptc_add_dir(ptc_array_get(static::$_config, 'app.directories')); ptc_add_dir(ptc_array_get(static::$_config, 'app.namespaces')); if ($sep = ptc_array_get(static::$_config, 'app.separators')) { HandyMan::addSeparators($sep); } if ($conv = ptc_array_get(static::$_config, 'app.conventions')) { HandyMan::addConventions($conv); } /* database */ static::option('db', Module::merge(ptc_path('root') . '/app/config/db.php')); if ($db = ptc_array_get(static::$_config, 'db')) { $loop = static::option('app.test_env') ? $db['develop'] : $db['prod']; foreach ($loop as $k => $v) { if (ptc_array_get($v, 'user')) { DB::add($v, $k); } } } /* auth */ static::option('auth', Module::merge(ptc_path('root') . '/app/config/auth.php')); }
$db['database'] = 'database name'; // mysql database name /*************************************************************/ require_once '../PtcDb.php'; // including the PtcDb class /* ADDING A CONNECTION, THIS WILL BE THE DEFAULT CONNECTION */ PtcDb::add(array('user' => $db['user'], 'pass' => $db['pass'], 'db' => $db['database'])); /* GETTING THE CONNECTION DETAILS */ $conn_details = PtcDb::getConnection('default'); // gets all connections if name param is not specified var_dump($conn_details); /* GETTING THE PDO OBJECT */ $pdo_object = PtcDb::getPdo('default'); /* USING PDO TO EXECUTE QUERIES WITH THE DEFAULT CONNECTION */ $query = PtcDb::prepare('SELECT * FROM some table'); // same as $pdo_object->prepare( ); //$query->execute( ); //var_dump( $query->fetchAll( ) ); /* * THE FOLLOWING LINES REQUIRE THE PTCQUERYBUILDER.PHP FILE * COMMENT LINE 45 TO EXECUTE THE REST OF THE CODE */ die; /* ADDING ANOTHER DATABASE CONNECTION WITH THE QUERY BUILDER CLASS SUPPORT */ require_once '../PtcQueryBuilder.php'; // including the Query Builder class PtcDb::add(array('user' => $db['user'], 'pass' => $db['pass'], 'db' => $db['database'], 'query_builder' => true, 'pdo_attributes' => array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC)), 'new connection'); /* GETTING THE QUERY BUILDER OBJECT */ $qb = PtcDb::getQB('new connection'); /* RUNNING THE QUERY BUILDER , REFER TO THE QUERY BUILDER EXAMPLE FILES FOR USAGE */ echo '<b>prepare select statement:</b> ' . $qb->table('test_table')->select('some_column as test')->prepare();
* */ /*** DB DETAILS NEEDED FOR THE EXAMPLE TO WORK ***/ $db['user'] = '******'; // mysql user $db['pass'] = '******'; // mysql pass $db['database'] = 'database'; // mysql database name /*************************************************************/ require_once '../PtcDb.php'; // including the PtcDb class /* ADDING DATABASE CONNECTION WITH THE QUERY BUILDER CLASS SUPPORT */ require_once '../PtcQueryBuilder.php'; // including the Query Builder class PtcDb::add(array('user' => $db['user'], 'pass' => $db['pass'], 'db' => $db['database'], 'query_builder' => true)); /* CREATE THE EXAMPLE TABLE */ PtcDb::run("DROP TABLE IF EXISTS `test_table`"); PtcDb::run("CREATE TABLE `test_table` \n\t(\n\t\t`id` int NOT NULL AUTO_INCREMENT, \n\t\tPRIMARY KEY(`id`),\n\t\t`field1` varchar(255),\n\t\t`field2` varchar(255)\n\t)"); require_once '../PtcMapper.php'; // including the ORM class /* EXTENDING THE CLASS WITH THE TABLE NAME */ class Test_Table extends PtcMapper { /* USING THE CLASS NAME AS TABLE */ //protected static $_table = ''; /* MAP FIELD NAMES IF "AS" IS USED IN A SELECT QUERY */ //protected static $_map = array( 'field1' => 'test' ); /* USE THIS PROPERTY IF THE TABLE USES ANOTHER * COLUMN NAME FOR THE PRIMARY KEY */ //protected static $_uniqueKey = 'id';