Use OCI to input data to the data table 'email _ info'
Same as above, but it is written using OCI.
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 = 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>
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.