How to use Oracle database in PHP (2)

How to use Oracle database in PHP (2) Create A Table Using OCI

Next we will create an email personal information book. This time the OCI8 API command is used

Related PHP code:


PutEnv ("ORACLE_SID = ORASID ");

$ Connection = OCILogon ("username", "password ");
If ($ connection = false ){
Echo OCIError ($ connection )."
";
Exit;
}

$ Query = "create table email_info ".
"(Fullname varchar (255), email_address varchar (255 ))";

$ 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 );

?>


We can see that the two sections of code have almost the same syntax, with only different function names. Secondly, in OCI8, we do not need to specifically run the command to open the cursor, when the OCIParse system is called, a cursor ID is automatically returned.