<?php
class ora_sql{
function ora_sql($database){
$this->server="wp1998";
$this->user="news_admin";
$this->pwd="news_pwd";
$this->database=$database;
}
function db_connect(){
$conn = OCILogon($this->user,$this->pwd,$this->database);
return $conn;
}
function db_query($query){
$conn=$this->db_connect();
$query_id=OCIParse($conn,$query);
OCIExecute($query_id);
return $query_id;
}
function get_query_array($query){
$res=$this->db_query($query);
$count=0;
while(OCIFetchInto($res, &$rs)) {
$ary[$count]=$rs;
$count++;
}
return $ary;
}
function get_query_count($query){ //count(*) as count
$res=$this->db_query($query);
OCIFetch($res);
$count=OCIResult($res,1);
return $count;
}
}
?>
|