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'); }
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);