How to use Oracle database in PHP (2) _ PHP Tutorial

How to use the Oracle database in PHP (2 ). Under CreateATableUsingOCI, we will create an email personal information book. PHP code related to the OCI8API command used this time: PutEnv (ORACLE_SIDORASID); $ connectionOCILogon (username, p 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.

Http://www.bkjia.com/PHPjc/315672.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/315672.htmlTechArticleCreate A Table Using OCI below we will create an email profile book. PHP code related to the OCI8 API instruction used this time: PutEnv (ORACLE_SID = ORASID); $ connection = OCILogon (username, p...