use zend adapter conncet exterme DB

$db = new Zend_Db_Adapter_Pdo_Mysql(array(
    'host' => '174.142.90.89', 'username' =>  'devleero_app',
                                            'password' => 'app123',
                                            'dbname' => 'devleero_vu_centerdata',
                                            'profiler' => true,
                                            ));
$profiler = $db->getProfiler();
$sql='select * from product_simple';
$data=$result = $db->fetchAssoc($sql);;
$i=0;
foreach($data as $d)
{
   var_dump($d['sku']);
    $i++;
}
echo 'total:'.$i;

Leave a Comment