跳转到主内容
趣航编程网 - 趣学编程,启航技术之路!

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

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

相关文章