| 冰心雨 |
 |
| 等级:精灵 |
| 权限:管理员 |
| 积分:797 |
| 金钱:18353 |
| 声望:644 |
| 经验:553 |
| 发帖数:5134 |
| 注册:2006年8月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 ... ...
|
|
|
|
|
|