Re: Problem extending mysqli - "No database connected"

Actually, the post by hans at lintoo dot dk (22-Mar-2005 11:33) @ http://theserverpages.com/php/manual/en/ref.mysqli.php show why. Weird. On 6/29/07, Lee PHP <leephp@gmail.com> wrote:

Hi, I have a class that extends msyqli that AFAIK can connect to the database, but gives me an error when I try and query it. Here's my class: -- BEGIN DATABASE CLASS -- require_once('Configuration.php'); require_once('RSFSException.php'); class Database extends mysqli {

        private $strUrl = "DEV";
        private $strUser;
        private $strPass;
        private $strHost;
        private $intPort;
        private $strName;

        private static $INSTANCE;
        private static $CONFIG;

        private function __construct() {
                $this->CONFIG = Configuration::getInstance();
                $this->establishConnectionSettings();
                $this->connect($this->getHost(), $this->getUser(),
                        $this->getPass(), $this->getName);

                if (mysqli_connect_errno()) {
                        throw new RSFSException("Connect exception:\n ".
                        mysqli_connect_error(), -1);
                }
        }

        public static function getInstance($url = null) {
                // Set the URL if one is provided.
                if (isset($url)) {
                        $this->setUrl($url);
                }

                // Instantiate the Singleton if not already instantiated.
                if(empty(self::$INSTANCE)) {
                        self::$INSTANCE = new Database();
                }

                return self::$INSTANCE;
        }

        public function establishConnectionSettings() {
                // DEVELOPMENT (default) database settings.
                if ($this->getUrl() == "DEV") {
                        $this->setUser($this->CONFIG->getProperty("rsfsTestDbUser"));
                        $this->setPass($this->CONFIG->getProperty("rsfsTestDbPass"));
                        $this->setHost($this->CONFIG->getProperty("rsfsTestDbHost"));
                        $this->setPort($this->CONFIG->getProperty("rsfsTestDbPort"));
                        $this->setName($this->CONFIG->getProperty("rsfsTestDbName"));
                }

                // PRODUCTION database settings.
                else if ($this->getUrl() == "PROD") {
                        $this->setUser($this->CONFIG->getProperty("rsfsDbUser"));
                        $this->setPass($this->CONFIG->getProperty("rsfsDbPass"));
                        $this->setHost($this->CONFIG->getProperty("rsfsDbHost"));
                        $this->setPort($this->CONFIG->getProperty("rsfsDbPort"));
                        $this->setName($this->CONFIG->getProperty("rsfsDbName"));
                }

                else {
                        // Throw an exception.
                }
        }

        public function query($sql) {
                $result = parent::query($sql);

                if(mysqli_error($this)){
                throw new RSFSException(mysqli_error($this), mysqli_errno($this));
                }

        return $result;
        }

        public function valueExists($table, $column, $value,
                $caseInsensitive = false) {
                if (!$caseInsensitive) {
                        $sql = "SELECT * FROM $table WHERE $column = $value";
                }

                else {
                        $sql = "SELECT * FROM $table " .
                                "WHERE upper($column) = ($value)";
                }

                $result = $this->query($sql);
                echo "Result: $result\n";
                $count = $result->num_rows;

                if ($count > 0) {
                        return true;
                }

                else {
                        return false;
                }
        }

        public function valuesExist($table, $columns, $values) {
                // Placeholder.
        }

        public function procedureQuery($name, $params) {
                return $this->query("call $name($params)");
        }

        /** Return the URL. */
        public function getUrl() {
                return $this->strUrl;
        }

        .
        .
        .

        /** Set the database URL. */
        public function setName($url) {
                $this->strUrl = $$url;
        }

} -- END DATABASE CLASS -- To test it, I'm doing the following: -- BEGIN -- echo "Attempting to establish connection.\n"; $CONN = Database::getInstance(); if ($CONN->ping()) {

    printf ("Our connection is ok!\n");

} else {

    printf ("Danger, Will Robinson!!!\n");

} echo "Attempting to test query() method.\n"; if ($result = $CONN->query("SELECT * FROM country")) {

        echo "In result set\n";
        while( $row = mysqli_fetch_assoc($result) ){
                printf("%s (%s)\n", $row['cnt_code'], $row['cnt_name']);
        }

} -- END -- Which outputs the following: Attempting to establish connection. localhost:rsfs:rsfs:rsfs Our connection is ok! Attempting to test query() method. Fatal error: Uncaught RSFSException: [1046]: No database selected thrown in /home/lee/Development/rsfs/php/classes/core/Database.php on line 84 I've tried removing the query method from my class, but even Mysqli's query() isn't working. Can anyone help me identify the problem? Thanks! Lee PS: I posted a similar question a few weeks ago - I though I had it working when I saw that it was connecting. Now that I'm ready to actually use it, I see that it just can't query...