Try the oci8 extension in php, try the phpoci8 extension_PHP tutorial

Try the oci8 extension in php, try the phpoci8 extension

I will share with you an operation class for php to operate Oracle

Oracle_db.class.php

<&#63;php
class Oracle_db{
  public $link;
  public function __construct(){
    $this->link=$this->connect();
    if(!$this->link){
      echo "连接失败";
      exit;
    }
  }
  public function connect(){
    return oci_connect('demo','demo','localhost/xe','AL32UTF8');
  }
  public function execute($sql){
    $result=false;
    $stid=oci_parse($this->link,$sql);
    if($stid){
      $result=oci_execute($stid);
    }
    return array($stid,$result);
  }
  public function fetch_assoc($stid){
    return oci_fetch_assoc($stid);
  }
  
  public function fetch_one($stid){
    $arr=$this->fetch_assoc($stid);
    $this->free($stid);
    return $arr;
  }
  public function fetch_all($stid){
    $arr=array();
    while($row=$this->fetch_assoc($stid)){
      $arr[]=$row;
    }
    $this->free($stid);
    return $arr;
  }
  public function num_rows($stmt){
    return oci_num_rows($stmt);
  }
  public function error(){
    return oci_error($this->link);
  }
  public function free($stid){
    return oci_free_statement($stid); 
  }
  public function server_version(){
    return oci_server_version($this->link);
  }
  public function client_version(){
    return oci_client_version();
  }
  public function __destruct(){
    return oci_close($this->link);
  }
  //
}

The above is the entire content of this article, I hope you all like it

http://www.bkjia.com/PHPjc/1019076.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1019076.htmlTechArticleTry out the oci8 extension in php, try out the phpoci8 extension and share with you a php operation class for Oracle_db.class.php phpclass Oracle_db{ public $link; public function __construct(){ $thi...