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

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

利用 ORA 向数据表 email_info 输入数据
当用户浏览这段脚本时,显示一个由姓名、email输入域组成的表单;当用户添好数据点击提交时,脚本程序将把这姓名、email保存到email_info数据表中。
相关PHP代码: if ($submit == “click”){ // The submit button was clicked!
// Get the input for fullname and email then store it in the database.
PutEnv(“ORACLE_SID=ORASID”); $connection = Ora_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 = “insert into email_info values ($fullname, $email)”; $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; }
Ora_Commit ($connection); Ora_Close ($cursor); Ora_Logoff
($connection); } else{ echo <FORM action=insert.php method=post>
请输入姓名 <INPUT name=fullname></INPUT> 请输入Email地址 <INPUT
name=email></INPUT> <INPUT name=submit type=submit
value=click></INPUT> </FORM> ; } ?
对了,这段脚本必须存为insert.php,因为在调用的页面中指定insert.php为表单处理程序

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图