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

How to use the Oracle database in PHP (6 ). Use OCI to list all the data in the data table email_info is the same as above, but use OCI to write the relevant PHP code: PutEnv (ORACLE_SIDORASID); $ connectionOCILogon (username, password ); if ($ co uses OCI to list data in all data tables 'email _ info'


Same as above, but it is written using OCI.

Related PHP code:


PutEnv ("ORACLE_SID = ORASID ");

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

$ Query = "select * from email_info ";
$ Cursor = OCIParse ($ connection, $ query );
If ($ cursor = false ){
Echo OCIError ($ cursor )."
";
Exit;
}

$ Result = OCIExecute ($ cursor );
If ($ result = false ){
Echo OCIError ($ cursor )."
";
Exit;
}

Echo "";
Echo "Full Name Email Address
";

While (OCIFetchInto ($ cursor, $ values )){
$ Name = $ values [0];
$ Email = $ values [1];

Echo "$ name $ email
";
}

Echo "";

OCILogoff ($ connection );

?>


The browsing effect of the program running is as follows:


Name Email address
Spring flower springflower@163.com
Autumn autumnmoon@163.com
......

Same as above, except that OCI is used to write the relevant PHP code: PutEnv (ORACLE_SID = ORASID); $ connection = OCILogon (username, password); if ($ co...