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


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


下面，我们将逐条读出数据库的内容，并以html表格形式显示email_info数据表中的数据  

相关php(做为现在的主流开发语言)代码: 


PutEnv("Oracle(大型网站数据库平台)_SID=ORASID"); 

$connection = Ora_Logon ("username","password"); 
if ($connection == false){ 
  echo Ora_ErrorCode($connection).": ".Ora_Error($connection)." 
"; 
  exit; 
} 

$cursor = Ora_Open ($connection); 
if ($cursor == false){ 
  echo Ora_ErrorCode($connection).": ".Ora_Error($connection)." 
"; 
  exit; 
}    

$query = "select * from email_info"; 
$result = Ora_Parse ($cursor, $query); 
if ($result == false){ 
  echo Ora_ErrorCode($cursor).": ".Ora_Error($cursor)." 
"; 
  exit;  
} 

$result = Ora_Exec ($cursor); 
if ($result == false){ 
  echo Ora_ErrorCode($cursor).": ".Ora_Error($cursor)." 
"; 
  exit; 
} 

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

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

  echo "  $name $email  
"; 
} 

echo " "; 

Ora_Close ($cursor); 
Ora_Logoff ($connection); 

?>  
  

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

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

补充：Web开发 , php ,