Home > Backend Development > PHP Tutorial > How to use Oracle database in PHP (4)_PHP tutorial

How to use Oracle database in PHP (4)_PHP tutorial

WBOY
Release: 2016-07-21 16:05:43
Original
808 people have browsed it

利用OCI向数据表 'email_info' 输入数据

同上,只不过用OCI来写  

相关PHP代码:


if ($submit == "click"){
  // The submit button was clicked!
  // Get the input for fullname and email then store it in the database.
  PutEnv("ORACLE_SID=ORASID");

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

  $query = "insert into email_info values ('$fullname', '$email')";
  $cursor = OCIParse ($connection, $query);
  if ($cursor == false){
    echo OCIError($cursor)."
";
    exit;  
  }

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

  OCICommit ($connection);
  OCILogoff ($connection);
}
else{
  echo '


     <FORM action=insert.php method=post>

    请输入姓名
    <INPUT name=fullname></INPUT>

    请输入 Email 地址
    <INPUT name=email></INPUT>

    <INPUT name=submit type=submit value=click></INPUT>         

    </FORM>

     
  ';
}

?>  


对了,这段脚本必须存为insert.php,因为在调用的页面中指定insert.php为表单处理程序 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/315637.htmlTechArticle利用OCI向数据表 'email_info' 输入数据 同上,只不过用OCI来写 相关PHP代码: if ($submit == click){ // The submit button was clicked! // Get the input for fullnam...
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template