如何在PHP中使用Oracle数据库(6)

利用OCI列出全部数据表'email_info'中的数据 


同上，只不过用OCI来写  

相关PHP代码: 


PutEnv("oracle_SID=ORASID"); 

$connection = OCILogon ("username","password"); 
if ($connection == false){ 
  echo OCIError($connection)." 
"; 
  exit; 
} 

$query = "select * from email_info"; 
$cursor = OCIParse ($connection, $query); 
if ($cursor == false){ 
  echo OCIError($cursor)." 
"; 
  exit;  
} 

$result = OCIExecute ($cursor); 
if ($result == false){ 
  echo OCIError($cursor)." 
"; 
  exit; 
} 

echo " "; 
echo "  Full Name Email Address  
"; 

while (OCIFetchInto ($cursor, $values)){ 
  $name = $values[0]; 
  $email = $values[1]; 

  echo "  $name $email  
"; 
} 

echo " "; 

OCILogoff ($connection); 

?>  


程序运行的浏览效果如下所示: 

    
姓名 Email 地址  
春花 springflower@163.com  
秋月 autumnmoon@163.com