db.inc.php

Go to the documentation of this file.

<?php
 
require_once("header.inc.php");
require_once(CH_DIRECTORY_PATH_INC . 'utils.inc.php');
require_once(CH_DIRECTORY_PATH_CLASSES . 'ChWsbDb.php');
 
$GLOBALS['MySQL'] = ChWsbDb::getInstance();
 
$GLOBALS['site']['title']        = getParam('site_title');
$GLOBALS['site']['email']        = getParam('site_email');
$GLOBALS['site']['email_notify'] = getParam('site_email_notify');
 
date_default_timezone_set(getParam('site_timezone'));
$GLOBALS['MySQL']->setTimezone(getParam('site_timezone'));
 
function db_list_tables()
{
    return $GLOBALS['MySQL']->listTables();
}
 
function db_res($query, $bindings = [])
{
    return $GLOBALS['MySQL']->res($query, $bindings);
}
 
function db_last_id()
{
    return $GLOBALS['MySQL']->lastId();
}
 
function db_affected_rows($oStmt = null)
{
    return $GLOBALS['MySQL']->getAffectedRows($oStmt);
}
 
function db_res_assoc_arr($query, $bindings = [])
{
    return $GLOBALS['MySQL']->getAll($query, $bindings);
}
 
function db_arr($query, $bindings = [])
{
    return $GLOBALS['MySQL']->getRow($query, $bindings, PDO::FETCH_BOTH);
}
 
function db_assoc_arr($query, $bindings = [])
{
    return $GLOBALS['MySQL']->getRow($query, $bindings);
}
 
function db_value($query, $bindings = [], $error_checking = true, $index = 0)
{
    return $GLOBALS['MySQL']->getOne($query, $bindings, $index);
}
 
function fill_array($res)
{
    return $GLOBALS['MySQL']->fillArray($res, PDO::FETCH_BOTH);
}
 
function fill_assoc_array($res)
{
    return $GLOBALS['MySQL']->fillArray($res, PDO::FETCH_ASSOC);
}
 
function getParam($sParamName, $bUseCache = true)
{
    return $GLOBALS['MySQL']->getParam($sParamName, $bUseCache);
}
 
function getParamDesc($sParamName)
{
    return $GLOBALS['MySQL']->getOne("SELECT `desc` FROM `sys_options` WHERE `Name` = ?", [$sParamName]);
}
 
function setParam($sParamName, $sParamValue)
{
    return $GLOBALS['MySQL']->setParam($sParamName, $sParamValue);
}