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

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

同上，只不过用oci来写

相关php代码:

putenv(“oracle_sid=orasid”);

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

if ($connection == fal){

echo ocierror($connection汶川地震一周年).”

“;

exit;

}

$query = “lect * from email_info”;

$cursor = ocipar ($connection, $query);

if ($cursor == fa商标要注册多久l){

echo ocierror($cursor).”

“;

exit;

}

$result = ociexecute ($cursor);

if ($result == fal){

echo ocierror($cursor).”

“;

exit;

}

echo ” “;

echo ”full name email address

“;

while (ocifetchintriso ($书楼cursor, $values)){

$name = $values[0];

$email = $values[1];

echo ”$name $email

“;

}

echo ” “;

ocilogoff ($connection);

?>

程序运行的浏览效果如下所示宪法特征:

姓名 email 地址

春花 springflower@163.com

秋月 autumnmoon@163.com

… …