Heim >Backend-Entwicklung >PHP-Tutorial >PHP-OCI8-Testversion
Oracle_db.class.php
class Oracle_db{
public $link;
public function __construct(){
$this->link= $this->connect();
if(!$this->link){
echo "连接失败";
exit;
}
. } return oci_connect('demo','demo','localhost/xe','AL32UTF8');
}
public functionexecute($sql){
$result= false;
$ stid = oci_parse ($ this- & gt; 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;
}
öffentliche Funktion 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); > }
以上就介绍了php oci8 小试,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助.