澳门新葡萄京官网首页如何在PHP中使用Oracle数据库(3)

利用OCI向数据表 email_info 输入数据 同上,只不过用OCI来写 相关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 = OCILogon
(“username”,”password”); if ($connection == false){ echo
OCIError($connection).” “; exit; } $query = “insert into email_info
values ($fullname, $email)”; $cursor = OCIParse ($connection, $query);
if ($cursor == false){ echo OCIError($cursor).” “; exit; } $result =
OCIExecute ($cursor); if ($result == false){ echo OCIError($cursor).” “;
exit; } OCICommit ($connection); OCILogoff ($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为表单处理程序

利用 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为表单处理程序

发表评论

电子邮件地址不会被公开。 必填项已用*标注