如何在PHP中使用Oracle数据库(6)
author:一佰互联 2019-05-01 click:144
利用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 ... ...