Root/
<?php/* -*- tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- *//*# ***** BEGIN LICENSE BLOCK *****# This file is part of Plume Framework, a simple PHP Application Framework.# Copyright (C) 2001-2007 Loic d'Anterroches and contributors.## Plume Framework is free software; you can redistribute it and/or modify# it under the terms of the GNU Lesser General Public License as published by# the Free Software Foundation; either version 2.1 of the License, or# (at your option) any later version.## Plume Framework is distributed in the hope that it will be useful,# but WITHOUT ANY WARRANTY; without even the implied warranty of# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the# GNU Lesser General Public License for more details.## You should have received a copy of the GNU Lesser General Public License# along with this program; if not, write to the Free Software# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA## ***** END LICENSE BLOCK ***** *//** * MySQL connection class */class Pluf_DB_MySQL{ public $con_id; public $pfx = ''; private $debug = false; /** The last query, set with debug(). Used when an error is returned. */ public $lastquery = ''; public $engine = 'MySQL'; public $type_cast = array(); function __construct($user, $pwd, $server, $dbname, $pfx='', $debug=false) { Pluf::loadFunction('Pluf_DB_defaultTypecast'); $this->type_cast = Pluf_DB_defaultTypecast(); $this->debug('* MYSQL CONNECT'); $this->con_id = @mysql_connect($server, $user, $pwd); $this->debug = $debug; $this->pfx = $pfx; if (!$this->con_id) { throw new Exception($this->getError()); } $this->database($dbname); $this->execute('SET NAMES \'utf8\''); } function database($dbname) { $db = @mysql_select_db($dbname); $this->debug('* USE DATABASE '.$dbname); if (!$db) { throw new Exception($this->getError()); } return true; } /** * Get the version of the MySQL server. * * @return string Version string */ function getServerInfo() { return mysql_get_server_info($this->con_id); } /** * Log the queries. Keep track of the last query and if in debug mode * keep track of all the queries in * $GLOBALS['_PX_debug_data']['sql_queries'] * * @param string Query to keep track * @return bool true */ function debug($query) { $this->lastquery = $query; if (!$this->debug) return true; if (!isset($GLOBALS['_PX_debug_data']['sql_queries'])) $GLOBALS['_PX_debug_data']['sql_queries'] = array(); $GLOBALS['_PX_debug_data']['sql_queries'][] = $query; return true; } function close() { if ($this->con_id) { mysql_close($this->con_id); return true; } else { return false; } } function select($query) { $this->debug($query); $cur = mysql_query($query, $this->con_id); if ($cur) { $res = array(); while ($row = mysql_fetch_assoc($cur)) { $res[] = $row; } mysql_free_result($cur); return $res; } else { throw new Exception($this->getError()); } } function execute($query) { $this->debug($query); $cur = mysql_query($query, $this->con_id); if (!$cur) { throw new Exception($this->getError()); } else { return true; } } function getLastID() { $this->debug('* GET LAST ID'); return (int) mysql_insert_id($this->con_id); } /** * Returns a string ready to be used in the exception. * * @return string Error string */ function getError() { if ($this->con_id) { return mysql_errno($this->con_id).' - ' .mysql_error($this->con_id).' - '.$this->lastquery; } else { return mysql_errno().' - ' .mysql_error().' - '.$this->lastquery; } } function esc($str) { return '\''.mysql_real_escape_string($str, $this->con_id).'\''; } /** * Quote the column name. * * @param string Name of the column * @return string Escaped name */ function qn($col) { return '`'.$col.'`'; } function __toString() { return '<Pluf_DB_MySQL('.$this->con_id.')>'; }} |
