continue; } if ($dsnOwn != '*' && strtolower($e) != strtolower($dsnOwn)) { continue; } $dsn = trim(@join("", file("{$full}/{$dsnFile}"))); if ($dsn) { $DSN = array_merge($DSN, preg_split('/\\s+/s', $dsn)); } } } else { $DSN[] = $dsnOwn; } foreach ($DSN as $dsn) { $DB = new DbSimple_Connect($dsn); $DB->setLogger('queryLogger'); $DB->setErrorHandler('errorHandler'); main($DB); } function queryLogger(&$DB, $query) { if (preg_match('/^\\s*--\\s+(\\d|error)/', $query)) { return; } printr($query, "Query"); } function errorHandler($msg, $error) { if (!error_reporting()) { return; }
<?php defined('DEVELOPMODE') && define('DEVELOPMODE', !strpos(HOST, '.') ? 1 : 0); // Develop-mode, extended error logging require_once "DbSimple/Connect.php"; $dbcfg = array('type' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => 'ng_test', 'user' => 'root', 'password' => '', 'prefix' => '', 'logging' => DEVELOPMODE); $db = new DbSimple_Connect("{$dbcfg['type']}://{$dbcfg['user']}:{$dbcfg['password']}@{$dbcfg['host']}:{$dbcfg['port']}/{$dbcfg['database']}"); if ($dbcfg['prefix']) { $db->setIdentPrefix($dbcfg['prefix']); } $db->setErrorHandler('databaseErrorHandler'); if ($dbcfg['logging']) { $db->setLogger('db_var_logger'); } unset($dbcfg); function databaseErrorHandler($message, $info) { if (!error_reporting()) { return; } file_put_contents(FILEROOT . 'log/mysql.log', date("Y-m-d H:i:s") . " {$message}\n\n", FILE_APPEND); if (!DEVELOPMODE) { header("HTTP/1.1 404 Not Found"); die(file_get_contents(FILEROOT . '404.html')); } echo "<b>SQL Error</b>: {$message}<br>"; } function db_echo_logger($db, $sql, $caller) { if (!error_reporting()) { return;