example of Zend DB call

zend_db_call.php

<?php

$config = new Zend_Config(
    array(
        'database' => array(
            'adapter' => 'Pdo_Mysql',
            //'adapter' => 'Mysqli',
            'params'  => array(
                'host'     => 'mysql',
                'dbname'   => 'database',
                'username' => 'dev',
                'password' => 'dev',
            )
        )
    )
);


$db = Zend_Db::factory($config->database);

try {
    $db->getConnection();
} catch (Zend_Db_Adapter_Exception $e) {
    // perhaps a failed login credential, or perhaps the RDBMS is not running
} catch (Zend_Exception $e) {
    // perhaps factory() failed to load the specified Adapter class
}

$sql = 'SELECT * FROM bugs WHERE bug_id = ?';


$result = $db->fetchAll($sql, 2);