How to use Oracle databases in PHP (5)

: This article mainly introduces how to use the Oracle database in PHP (5). If you are interested in the PHP Tutorial, refer to it. How to use Oracle databases in PHP (5)

Use ORA to list all data in the data table '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
......

The above introduces how to use the Oracle database in PHP (5), including some content, and hope to help those who are interested in the PHP Tutorial.