Exemplos de vam_db_error em PHP

Exemplo n.º 1

Arquivo: vam_db_query.inc.php Projeto: nomadcomanche/zdorov_shop

function vam_db_query($query, $link = 'db_link')
{
    global ${$link};
    global $query_counts;
    $query_counts++;
    //echo $query.'<br>';
    if (STORE_DB_TRANSACTIONS == 'true') {
        error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
    }
    //    $queryStartTime = array_sum(explode(" ",microtime()));
    $result = mysql_query($query, ${$link}) or vam_db_error($query, mysql_errno(), mysql_error());
    //	$queryEndTime = array_sum(explode(" ",microtime()));
    //	$processTime = $queryEndTime - $queryStartTime;
    //	echo 'time: '.$processTime.' Query: '.$query.'<br>';
    if (STORE_DB_TRANSACTIONS == 'true') {
        $result_error = mysql_error();
        error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
    }
    //Start VaM db-error processing
    if (!$result) {
        vam_db_error($query, mysql_errno(), mysql_error());
    }
    //End VaM db-error processing
    return $result;
}

Exemplo n.º 2

Arquivo: vam_db_connect.inc.php Projeto: nomadcomanche/zdorov_shop

function vam_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link', $use_pconnect = USE_PCONNECT, $new_link = false)
{
    global ${$link};
    if ($use_pconnect == 'true') {
        ${$link} = mysql_pconnect($server, $username, $password);
    } else {
        ${$link} = @mysql_connect($server, $username, $password, $new_link);
    }
    if (${$link}) {
        @mysql_select_db($database);
        @mysql_query("SET SQL_MODE= ''");
        @mysql_query("SET SQL_BIG_SELECTS=1");
        @mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
    }
    //Start VaM db-error processing
    if (!${$link}) {
        vam_db_error("connect", mysql_errno(), mysql_error());
    }
    //End VaM db-error processing
    return ${$link};
}

Exemplo n.º 3

Arquivo: vam_db_queryCached.inc.php Projeto: nomadcomanche/zdorov_shop

function vam_db_queryCached($query, $link = 'db_link')
{
    global ${$link};
    // get HASH ID for filename
    $id = md5($query);
    // cache File Name
    $file = SQL_CACHEDIR . $id . '.vam';
    // file life time
    $expire = DB_CACHE_EXPIRE;
    // 24 hours
    if (STORE_DB_TRANSACTIONS == 'true') {
        error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
    }
    if (file_exists($file) && filemtime($file) > time() - $expire) {
        // get cached resulst
        $result = unserialize(implode('', file($file)));
    } else {
        if (file_exists($file)) {
            @unlink($file);
        }
        // get result from DB and create new file
        $result = mysql_query($query, ${$link}) or vam_db_error($query, mysql_errno(), mysql_error());
        if (STORE_DB_TRANSACTIONS == 'true') {
            $result_error = mysql_error();
            error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
        }
        // fetch data into array
        while ($record = vam_db_fetch_array($result)) {
            $records[] = $record;
        }
        // safe result into file.
        $stream = serialize($records);
        $fp = fopen($file, "w");
        fwrite($fp, $stream);
        fclose($fp);
        $result = $records;
    }
    return $result;
}

Exemplo n.º 4

Arquivo: database.php Projeto: nomadcomanche/zdorov_shop

function service_vam_db_query($query, $link_service = 'db_link_service')
{
    global ${$link_service}, $logger_service;
    if (STORE_DB_TRANSACTIONS == 'true') {
        if (!is_object($logger_service)) {
            $logger_service = new logger_service();
        }
        $logger_service->write($query, 'QUERY');
    }
    $result = mysql_query($query, ${$link_service}) or vam_db_error($query, mysql_errno(), mysql_error());
    if (STORE_DB_TRANSACTIONS == 'true') {
        if (mysql_error()) {
            $logger_service->write(mysql_error(), 'ERROR');
        }
    }
    return $result;
}