您的位置:首页技术文章
文章详情页

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

浏览:45日期:2024-01-22 18:16:23
利用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;;... ...;;;;
标签: PHP