试用php中oci8扩展

给大家分享个php操作Oracle的操作类

Oracle_db.class.php

<?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);
 }
 //
}

以上所述就是本文的全部内容了，希望大家能够喜欢