Undefined variable: db

I am not sure what version of ezsql I am running. I inherited an application from someone else. I suspect that there is an incompatibility between earlier versions and PHP 5.2.0. After reading below, is there anything I can do to patch up the code I am using, which was modified extensively by the person who sent the application to me.

Dennis

Here is a snippet of the error message:

Notice: Undefined variable: db in D:DAdennismdb_search.php on line 32

Fatal error: Call to a member function get_results() on a non-object in D:DAdennismdb_search.php on line 32

At the beginning of the error page I get this:

dbh = @mysql_connect($dbhost,$dbuser,$dbpassword); if ( ! $this->dbh ) { $this->print_error("

Error establishing a database connection!
1. Are you sure you have the correct user/password?
2. Are you sure that you have typed the correct hostname?
3. Are you sure that the database server is running?

I am not an OO expert by any manys but I have a feeling that the variable "db" is not considered to be an object because of the way it is used in the get_results function. Here is the function directly from the class I am using.

        // Return the the query as a result set - see docs for more details
       
        function get_results($query=null, $output = OBJECT)
        {
           
            // Log how the function was called
            $this->func_call = "$db->get_results("$query", $output)";
           
            // If there is a query then perform it if not then use cached results..
            if ( $query )
            {
                $this->query($query);
            }       
   
            // Send back array of objects. Each row is an object       
            if ( $output == OBJECT )
            {
                return $this->last_result;
            }
            elseif ( $output == ARRAY_A || $output == ARRAY_N )
            {
                if ( $this->last_result )
                {
                    $i=0;
                    foreach( $this->last_result as $row )
                    {
                       
                        $new_array[$i] = get_object_vars($row);
                       
                        if ( $output == ARRAY_N )
                        {
                            $new_array[$i] = array_values($new_array[$i]);
                        }
   
                        $i++;
                    }
               
                    return $new_array;
                }
                else
                {
                    return null;   
                }
            }
        }
   

Great content, let me share it! »