How to use Oracle database in PHP (4)

How to use Oracle database in PHP (4) 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.