search
Homephp教程php手册如何在PHP中使用Oracle数据库(6)

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

Jun 13, 2016 pm 12:41 PM
emailinfooraclephpuselistusedatadatabasedata sheet

利用OCI列出全部数据表'email_info'中的数据


同上,只不过用OCI来写  

相关PHP代码:


PutEnv("ORACLE_SID=ORASID");

$connection = OCILogon ("username","password");
if ($connection == false){
  echo OCIError($connection)."
";
  exit;
}

$query = "select * from email_info";
$cursor = OCIParse ($connection, $query);
if ($cursor == false){
  echo OCIError($cursor)."
";
  exit;  
}

$result = OCIExecute ($cursor);
if ($result == false){
  echo OCIError($cursor)."
";
  exit;
}

echo " ";
echo "  Full Name Email Address  
";

while (OCIFetchInto ($cursor, $values)){
  $name = $values[0];
  $email = $values[1];

  echo "  $name $email  
";
}

echo " ";

OCILogoff ($connection);

?>  


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

    
姓名 Email 地址  
春花 springflower@163.com  
秋月 autumnmoon@163.com  
... ...  

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function