如何在PHP中使用Oracle数据库(5)

利用ora列出全部数据表’email_info’中的数据

下面，我们将逐条读出数据库的内容，并以html表格形式显示’email_info’数据表中的数据

相关php代码:

putenv(“oracle_sid=orasid”);

$connection = ora_logon (“urname”,”password”);

if ($connection == fal){

echo or英文月份缩写a_errorcode($connection).”: “.ora_error($connection).”

“;

exit;

}

$cursor = ora_open ($connection);

if ($cursor == fal){

echo ora_errorcode($connection).”: “.ora_error($connection).”

“;

exit;

}

$query = “lect * from email_info”;

$result = ora_par ($cursor, $query);

if ($result == fal){

echo ora_errorcode($cursor).”宾语从句连接词;: “.ora_error($cursor矛子俊).”

“;

exit;

}

$result = ora_exec ($cursor);

if ($result == fal){

echo ora_errorcode($cursor).”: “.ora_error($cursor).”

“;

exit;

}

echo ” “;

echo ”full name email a英语学习方法ddress

“;

while (ora_fetch_into ($cursor, &$values)){

$name = $values[0];

$五月鲜花email = $values[1];

echo ”$name $email

“;

}

echo ” “;

ora_clo ($cursor);

ora_logoff ($connection);

?>

程序运行的浏览效果如下所示:

姓名 email 地址

春花 springflower@163.com

秋月 autumnmoon@163.com

… …