protected function _getDbConnect($sDsn)
 {
     if (Config::Get('db.params.lazy')) {
         // lazy connection
         //F::IncludeLib('DbSimple3/lib/DbSimple/Connect.php');
         $oDbSimple = new DbSimple_Connect($sDsn);
         foreach ($this->aInitSql as $sSql) {
             $oDbSimple->addInit($sSql);
         }
     } else {
         // immediate connection
         //F::IncludeLib('DbSimple3/lib/DbSimple/Generic.php');
         $oDbSimple = DbSimple_Generic::connect($sDsn);
         foreach ($this->aInitSql as $sSql) {
             $oDbSimple->query($sSql);
         }
     }
     return $oDbSimple;
 }
Beispiel #2
0
        if ($e == "." || $e == ".." || !is_dir($full) || $full == realpath(getcwd())) {
            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;
Beispiel #3
0
<?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;