利用 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 为表单处理程序
来源: https://www.php1.cn/detail/php-7ca5fd49a6.html