<?php

    class SQL {
        static private $instance = Array();

        private $sql_uri = "mysql://username:password@hostname/database";

        /* Placeholder for the existing MySQL connection */
        private $conn = FALSE;

        /**
         * This implements the 'singleton' design pattern
         *
         * @return SQL The one and only instance associated with $_conn
         */
        static function get_instance($_conn = 'kolab_wap')
        {
            if (!isset(self::$instance[$_conn])) {
                self::$instance[$_conn] = new SQL($_conn);
            }

            return self::$instance[$_conn];
        }

        public function __construct($_conn = 'kolab_wap') {
            $this->name = $_conn;
            $conf = Conf::get_instance();
            $this->sql_uri = $conf->get($_conn, 'sql_uri');
        }

        public function query($query) {
            if (!$this->conn) {
                $this->_connect();
            }

            $result = mysql_query($query);
            return $result;
        }

        private function _connect() {
            if (!$this->conn) {
                $_uri = parse_url($this->sql_uri);
                $this->_username = $_uri['user'];
                $this->_password = $_uri['pass'];
                $this->_hostname = $_uri['host'];
                $this->_database = str_replace('/','',$_uri['path']);

                $this->conn = mysql_connect($this->_hostname, $this->_username, $this->_password);
                mysql_select_db($this->_database, $this->conn);
            }
        }

    }

?>