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