示例#1
0
<?php

// KioCMS - Kiofol Content Managment System
// includes/mysql.php
defined('KioCMS') || exit;
$cfg->system['queries'] = 0;
if (DB_PDO) {
    try {
        define('OPD_DIR', ROOT . 'system/OPD/');
        require OPD_DIR . 'opd.class.php';
        $sql = new OPD('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . (DB_PORT ? ';port=' . DB_PORT : null), DB_USER, DB_PASS);
        $sql->setCacheDirectory(ROOT . CACHE_DIR);
        //		$sql->debugConsole = true;
        //$sql = new MyPDO('mysql:host='.DB_HOST.';dbname='.DB_NAME.(DB_PORT ? ';port='.DB_PORT : null), DB_USER, DB_PASS);
        $sql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $sql->exec('SET NAMES utf8');
    } catch (Exception $e) {
        exit('<div style="text-align: center;"><br /><h3>' . t('Error while connecting to SQL database!') . '</h3><code>' . $e->getMessage() . '</code></div>');
        //exit('<h3>Error while connecting to SQL database!</h3><code>'.$e->getMessage().'</code><p>For more information check log file.</p>');
    }
}
function query($content)
{
    global $sql;
    return $sql->query($content);
}
/*
mysql_connect(DB_HOST, DB_USER, DB_PASS) || die(mysql_error());
mysql_select_db(DB_NAME) || die(mysql_error());

function sql_query($query)
示例#2
0
 public function query($statement, $fetchMode = PDO::FETCH_ASSOC)
 {
     $this->beginDebugDefinition($statement);
     if ($this->cache) {
         $this->cache = false;
         if (!is_null($this->cachePeroid)) {
             if (@filemtime($this->cacheDir . $this->cacheId . '.php') + $this->cachePeroid > time()) {
                 $this->cachePeroid = NULL;
                 return new opdCachedStatement($this, true, $this->cacheId);
             }
             $this->cachePeroid = NULL;
         } else {
             if (file_exists($this->cacheDir . $this->cacheId . '.php')) {
                 return new opdCachedStatement($this, true, $this->cacheId);
             }
         }
         $this->makeConnection();
         $this->startTimer(true, false);
         $result = $this->pdo->query($statement);
         $this->endTimer();
         OPD::$lastQuery = $statement;
         $result->setFetchMode($fetchMode);
         return new opdCachedStatement($this, false, $result, $this->cacheId);
     } else {
         $this->cache = false;
         $this->makeConnection();
         $this->startTimer(false, false);
         $result = $this->pdo->query($statement);
         $this->endTimer();
         OPD::$lastQuery = $statement;
         $result->setFetchMode($fetchMode);
         return new OPDStatement($this, $result);
     }
 }