Call to undefined method jar_database::query()

cudeso · #1 (**permalink**) 09-28-2007, 11:47 AM

Hi,

This is probably more related to OOP than to databases but here it goes.

I've created a seperate class as a wrapper for my database connections.

Code:

class jar_database {
 public function __construct() {
    require_once 'Zend/Db.php';
    $params = array ( 'host'      => 'localhost',
                              'username' => 'user',
                              'password' => 'pw',
                              'dbname'    => 'db');
    $db = Zend_Db::factory('PDO_MYSQL', $params);
    return $db;
   }
}

Then in another method of another class I try to do this (the file that contains the code for jar_database is fully included):

Code:

    $db = new jar_database();
    $stmt = $db->query('SELECT * FROM events");

When I try to do this I get an error:
Fatal error: Call to undefined method jar_database::query()

I think the problem lies in the way I return the db but I got no real idea how to resolve it. How should I "return" the Zend_Db::factory('PDO_MYSQL', $params)"?

Thanks in advance!

Elemental · #2 (**permalink**) 10-05-2007, 01:05 AM

you need to extend the Zend_Db class vs. just including it.

Code:

require_once 'Zend/Db.php';

class jar_database extends Zend_Db {
    public function __construct() {
        parent::__construct(); //run the db's original constructor
       
        $params = array ( 'host'      => 'localhost',
                                   'username' => 'user',
                                   'password' => 'pw', 
                                   'dbname'    => 'db');
       $db = Zend_Db::factory('PDO_MYSQL', $params);
       return $db;
    }
}

however, this is still riddled with bad form and may not work...

Why are you trying to create a class for this at all?

Add this to your bootstrap file or init method:

Code:

$params = array ( 'host'      => 'localhost',
                            'username' => 'user',
                            'password' => 'pw', 
                            'dbname'    => 'db');
$db = Zend_Db::factory('PDO_MYSQL', $params);
Zend_Registry::set('db', $db);

then anytime you need the db you can do this:

Code:

$db = Zend_Registry::get('db');

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode