How to use Oracle Database in PHP (5) _php Basics

Use Ora to list data in all datasheet ' Email_info '


Below, we will read out the contents of the database, and display the data in the ' Email_info ' datasheet as an HTML form

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 springflower@163.com
Autumn Moon autumnmoon@163.com
... ...