How to use Oracle database 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
......