连接oracle的类,作为include文件func.inc.php:
<?
class oracle_func
{
 var $db_conn;
 var $db_cursor;
 var $db_record_set;

 function post_ora_error($ora_handle)
 {
if(ora_errorcode($ora_handle))
{
echo "Oracle Error : ".ora_error($ora_handle);
return -1;
}
return 1;
 }  function connect($orauser,$tns,$password)
 {
$conn_str = $orauser.'@'.$tns;
$conn = ora_logon($conn_str,$password);
if(!$conn)
{
$this->post_ora_error($conn);
$this->db_conn = "NULL";
}
else
{
$this->db_conn = $conn;
$this->db_cursor = ora_open($this->db_conn);
}
return;
 }  function disconnect()
 {
ora_close($this->db_cursor);
ora_logoff($this->db_conn);
return;
 }
   function execute_query($query)
 {
if($this->post_ora_error($this->db_cursor)>0)
{
ora_parse($this->db_cursor,$query,0);
if($this->post_ora_error($this->db_cursor)>0)
{
ora_exec($this->db_cursor);
if($this->post_ora_error($this->db_cursor)>0)
{ return 1; }
else
{ return -1; }
}
else
{ return -2; }
  }
else{ return -3; }
}
}$DB_USER="×××××";
$TNS="××××";
$DB_PASS="××××";
$oracle = new oracle_func();
$oracle->connect($DB_USER,$TNS,$DB_PASS);
?>
使用:
<?
include("func.inc.php");
$query = "select HOUSENAME,HOUSEID from TFI_HOUSE";
if($oracle->execute_query($query)>0)
{
      $oracle->db_record_set = array();
      while(ora_fetch_into($oracle->db_cursor,$oracle->db_record_set,ORA_FETCHINTO_NULLS | ORA_FETCHINTO_ASSOC))
 {
 $t[0] = $oracle->db_record_set["HOUSENAME"];
 $t[1] = $oracle->db_record_set["HOUSEID"];
 }
 }$query = "select count(*) as count_num from TFI_NODE ";
if($oracle->execute_query($query)>0)
{
      $oracle->db_record_set = array();
      while(ora_fetch_into($oracle->db_cursor,$oracle->db_record_set,ORA_FETCHINTO_NULLS | ORA_FETCHINTO_ASSOC))
 {
 $t0 = $oracle->db_record_set["count_num"];
 if($t0=="")
 {
        echo "<input type=text name=nodenum size=6 value='0' style='border: 1px solid #666666;' disabled></td>";
 }else{
        echo "<input type=text name=nodenum size=6 value='$t0' style='border: 1px solid #666666;' disabled></td>";
 }
         }
}后面这个出现的错误如题所示