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

利用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 … …

利用ORA列出全部数据表email_info中的数据
下面,我们将逐条读出数据库的内容,并以html表格形式显示email_info数据表中的数据
相关PHP代码: PutEnv(“ORACLE_SID=ORASID”); $connection = Ora_澳门新葡亰3522平台游戏,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 … …