PHP Library Db::getInstance Examples

Example #1

File: index.php Project: dianadevargas/php-framework

 public function showRows()
 {
     // Connect to database
     $db = Db::getInstance();
     if (!$db->connect($this->_registry->config->dbserver, $this->_registry->config->dbuser, $this->_registry->config->dbpass, $this->_registry->config->dbname, true)) {
         $db->print_last_error(false);
         $db->printMe();
     }
     if (isset($this->_registry->request->args[0])) {
         $tables = array();
         $db = Db::getInstance();
         $tableName = $this->_registry->request->args[0];
         $where = isset($this->_registry->request->request['where']) ? " where " . $this->_registry->request->request['where'] : '';
         $tables[$tableName] = array('fields' => array(), 'rows' => 0);
         $bResults = $db->select("select * from  {$tableName} {$where} limit 200");
         while ($bRow = $db->get_row($bResults, 'MYSQL_ASSOC')) {
             $tables[$tableName]['fields'][] = $bRow;
         }
         $cResults = $db->select_one("select count(*) num from {$tableName}");
         $tables[$tableName]['rows'] = $cResults;
     }
     $this->_registry->title = 'Database Structure';
     $this->_registry->tables = $tables;
     $this->viewHTML('tables.php');
 }

Example #2

File: eventsCrunch.php Project: dianadevargas/php-framework

    error_reporting(E_ALL);
} else {
    // Production
    define('APPLICATION_ENVIRONMENT', 'PRODUCTION');
    error_reporting(E_STRICT);
}
// load configuration file
$config = \library\Config::getConfigArray($basePath . 'application/default/config/config.ini', APPLICATION_ENVIRONMENT);
$logDir = $config['logDir'];
if (!is_dir($logDir)) {
    mkdir($logDir);
}
$log = isset($log) && !empty($log) ? $log : $logDir . '/eventCrunch.' . date('Ymd', strtotime('now')) . '.log';
$awsAccessKey = $config['awsAccessKey'];
$awsSecretAccessKey = $config['awsSecretAccessKey'];
$kissmetricsBucket = $config['kissmetricsBucket'];
// ready to run
echo "using log: {$log}";
\library\traits\Loging::setLog($log);
\library\traits\Loging::printTime("Status: starting up eventsCrunch.php " . date('Y-m-d H:i:s', strtotime('now')));
// The gear - load database and run
$db = \library\Db::getInstance($config['dbserver'], $config['dbname']);
if (!$db->connect($config['dbserver'], $config['dbuser'], $config['dbpass'], $config['dbname'], true)) {
    \library\traits\Loging::printTime("Error connecting with database : " . $db->last_error);
    exit(1);
}
$eventCrunch = Cron_EventCrunch::getInstance();
$eventCrunch->crunchEvents();
// All methods
\library\traits\Loging::printTime("Status: finish eventsCrunch.php " . date('Y-m-d H:i:s', strtotime('now')));
exit(0);