<?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)
public static function create($config) { if (is_string($config)) { $config = parse_ini_file($config); } if (!is_array($config)) { throw new Exception('Invalid Open Power Driver configuration: no configuration array.'); } $opd = new OPD($config['dsn'], $config['user'], $config['password']); if (isset($config['cache'])) { $opd->setCacheDirectory($config['cache']); } if (isset($config['debugConsole'])) { $opd->debugConsole = $config['debugConsole']; } return $opd; }