Use ORA to input data to the data table 'email _ info'
When a user browses this script, a form consisting of name and email input fields is displayed. When the user adds data and clicks submit, the script saves the name and email to the 'email _ info' data table.
Related PHP code:
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>
Enter name
<INPUT name = fullname> </INPUT>
Enter the Email address
<INPUT name = email> </INPUT>
<INPUT name = submit type = submit value = click> </INPUT>
</FORM>
';
}
?>
By the way, this script must be saved as insert. php, because insert. php is specified as the form processing program on the called page.