Skudd

<?php    /**     * A MySQL interface class     *     * This class is to be used to interface with a MySQL database     * server. It depends on the $config['db'] global configuration     * array.     *     * @package DB_Class     * @version 3.0     * @author Tim Garrison <tim@skudd.com>     * @copyright Copyright &copy; 2005 - Tim Garrison     */        class db_class {        /**         * Constructor         */        function __construct($default_query = NULL) {            if($default_query != NULL) $this->Query($default_query);        }                /**         * Configuration Processor         * @param array $conf Alternate configuration         */        function Config($conf = NULL) {            if($conf == NULL) {                global $config;                $conf = $config['db'];            }                        if(is_array($conf)) {                $this->db_host = $conf['host'];                $this->db_user = $conf['user'];                $this->db_pass = $conf['pass'];                $this->db_name = $conf['name'];            } else {                $this->Log('Error: Configuration not valid', true);            }                    }                /**         * Connection Processor         */        function Connect() {            global $__dbconn;            if($__dbconn == false) {                $this->Config();                $this->db = mysql_connect($this->db_host, $this->db_user, $this->db_pass)                    or $this->Log('Error: Failed connecting to MySQL server. Server said: '.mysql_error(), true);                mysql_select_db($this->db_name, $this->db)                    or $this->Log('Error: Failed selecting database. Server said: '.mysql_error(), true);            }        }        /**         * Query Processor         * @param string $query SQL Query         */        function Query($query) {            $this->Connect();            $this->result = mysql_query($query, $this->db)                or $this->Log('Error: Query failed. Server said: '.mysql_error($this->db), false);            if(is_resource($this->result)) {                $this->num_rows = mysql_num_rows($this->result);            } else {                $this->num_rows = 0;            }        }                /**         * Multi-Row Result Processor         * @return array         */        function Result2Array() {            if(is_resource($this->result) && $this->num_rows > 0) {                while($row = mysql_fetch_assoc($this->result)) {                    $output[] = $row;                }            } else {                $output = false;            }                        return $output;        }                /**         * Single-Row Result Processor         * @return array         */        function SingleRow() {            $rows = $this->Result2Array();            if($rows != false) $output = $rows[0];            else $output = false;                        return $output;        }                /**         * Error Logging Processor         *         * @param string $error Error message         * @param boolean $fatal Fatal error message         */        function Log($error, $fatal) {            if($fatal == true) die($error);            else echo($error."<br />\n");        }                /**#@+         * Database Configuration Variable         * @access private         * @var string         */                /**         * Host         */        private $db_host;                /**         * Username         */        private $db_user;                /**         * Password         */        private $db_pass;                /**         * Database Name         */        private $db_name;                /**#@-*/                /**         * Connection Handle         * @access private         * @var resource         */        private $db;                /**         * Query Result         * @access public         * @var resource         */        public $result;                /**         * Number of Rows Returned         * @access public         * @var integer         */        public $num_rows;        }        /**     * Connection Handle     *     * In order to minimize the number of connections made to the     * database server, directly affecting the performance, this     * variable is used to maintain a connection for the execution     * of the script. It will be used by all instances of db_class.     *     * @global resource $__dbconn     */         global $__dbconn;     $__dbconn = false;?>