How to use Oracle database in PHP (5)

How to use the Oracle database in PHP (5), read how to use the Oracle database in PHP (5 ), use ORA to list all data tables "> <LINKhref =" http://www.php100.com//statics/style/headfloor_950_081205.css "type = text/cssrel = styles use ORA to list data in all data tables 'email _ info'


Next, we will read the database content one by one and display the data in the 'Email _ info' data table in the form of an html table.

Related PHP code:


PutEnv ("ORACLE_SID = ORASID ");

$ Connection = Ora_Logon ("username", "password ");
If ($ connection = false ){
Echo Ora_ErrorCode ($ connection). ":". Ora_Error ($ connection )."
";
Exit;
}

$ Cursor = Ora_Open ($ connection );
If ($ cursor = false ){
Echo Ora_ErrorCode ($ connection). ":". Ora_Error ($ connection )."
";
Exit;
}

$ Query = "select * from email_info ";
$ Result = Ora_Parse ($ cursor, $ query );
If ($ result = false ){
Echo Ora_ErrorCode ($ cursor). ":". Ora_Error ($ cursor )."
";
Exit;
}

$ Result = Ora_Exec ($ cursor );
If ($ result = false ){
Echo Ora_ErrorCode ($ cursor). ":". Ora_Error ($ cursor )."
";
Exit;
}

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

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

Echo "$ name $ email
";
}

Echo "";

Ora_Close ($ cursor );
Ora_Logoff ($ connection );

?>


The browsing effect of the program running is as follows:


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