Bridge class to replicate the ease of Zend_Db in Zend Framework 2.
In zf2 there's no fetchPairs, fetchCol or fetchOne methods from Db, this class tried to fill that gap with an easy approach.
|
If you find my work valuable, please consider sponsoring |
The files in this archive are released under the New BSD license. You can find a copy of this license in LICENSE.txt.
require_once "ZFBridge/Db.php";
// first of all we need the zf2 autoloader
$autoloader = new Zend\Loader\StandardAutoloader(array('autoregister_zf' => true));
$autoloader->register();
// instancing db adapter
$adapter = new Zend\Db\Adapter\Adapter(array(
'driver' =>'Pdo_Mysql',
'hostname' => DB_READ_HOST,
'username' => DB_READ_USER,
'password' => DB_READ_PASS,
'database' => DB_READ_NAME,
'characterset' => 'UTF8'
));
// replacing adapter with ZFBridge
$adapter = new \ZFBridge\Db($adapter);
// now we can use the old style fetchPairs etc
$adapter->fetchPairs("SELECT id, name FROM sampletable");