如何在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  ... ...