连接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>";
}
}
}后面这个出现的错误如题所示
<?
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>";
}
}
}后面这个出现的错误如题所示
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货