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

How to use the Oracle database in PHP (5 ). Using ORA to list all the data in the data table email_info, we will read the database content one by one, the data related PHP code in the email_info data table is displayed in an html table. use ORA to list data in all the 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
......

Below, we will read the database content one by one, and display the data-related PHP code in the 'Email _ info' data table in html form...