can not connect oracle when use zend server ce
737466Nov 26 2009 — edited Dec 10 2009I face the problem I can not connect oracle database
my code as below
<?php
require_once 'Zend/Db.php';
$params = array ('host'=>'hostname','username'=>'usr','password'=>'pass','dbname'=>'servicename');
$db=Zend_Db::factory('oracle', $params);
$querysql = 'select first_name,last_name from employee ';
$result = $db->query($querysql);
$rowset = $result->fetchAll();
$n=max(count($rowset["FIRST_NAME"]),count($rowset["LAST_NAME"]));
print '<table border="1"><tr><td>Name</td><td>Salary</td></tr>';
for($i=0;$i<$n;$i++)
{
print "<tr><td>".htmlspecialchars($rowset["FIRST_NAME"][$i])."</td><td>".htmlspecialchars($rowset["LAST_NAME"][$i])."</td></tr>";
}
and error code is
Fatal error: Uncaught exception 'Zend_Db_Adapter_Oracle_Exception' with message 'The OCI8 extension is required for this adapter but the extension is not loaded' in C:\Program Files\Zend\ZendServer\share\ZendFramework\library\Zend\Db\Adapter\Oracle.php:119 Stack trace: #0 C:\Program Files\Zend\ZendServer\share\ZendFramework\library\Zend\Db\Adapter\Abstract.php(448): Zend_Db_Adapter_Oracle->connect() #1 C:\Program Files\Zend\Apache2\htdocs\fixasset\views\test.php(6): ZendDb_Adapter_Abstract->query('select first_na...') #2 {main} thrown in C:\Program Files\Zend\ZendServer\share\ZendFramework\library\Zend\Db\Adapter\Oracle.php on line 119
Anyone help me