require_once ("smarty/libs/Smarty.class.php");
require_once("adodb/adodb.inc.php"); $staID = "54511";
$days = 0;
$dsn = 'oci8://****:*******@192.168.39.113:1521/portaldb?charset=UTF8';
$db = ADONewConnection($dsn);
//
for($i = 0; $i < 100 ; $i++)
{
$sql = "select * from observe.ele_surf
where v01000 = '$staID'
and c_bjtime like to_char((sysdate-'$i'),'yyyymmdd')||'080000'
and V13023 = 0";
$rs = $db -> Execute($sql);
$Rcount = $rs->RecordCount();
if($Rcount == 1)
{
$days = $days + 1;
echo "0";
}
else
{
echo "1";
}
} $rs = $db -> Execute($sql); 这块出错了:call a member function Execute() on a non object.
require_once("adodb/adodb.inc.php"); $staID = "54511";
$days = 0;
$dsn = 'oci8://****:*******@192.168.39.113:1521/portaldb?charset=UTF8';
$db = ADONewConnection($dsn);
//
for($i = 0; $i < 100 ; $i++)
{
$sql = "select * from observe.ele_surf
where v01000 = '$staID'
and c_bjtime like to_char((sysdate-'$i'),'yyyymmdd')||'080000'
and V13023 = 0";
$rs = $db -> Execute($sql);
$Rcount = $rs->RecordCount();
if($Rcount == 1)
{
$days = $days + 1;
echo "0";
}
else
{
echo "1";
}
} $rs = $db -> Execute($sql); 这块出错了:call a member function Execute() on a non object.
这个怎么改啊? SQL语句是没有问题的
$db = ADONewConnection($dsn); 我有写这句的
这里的$db是函数ADONewConnection的返回值,
对象的话应该是new什么
$db=new ADONewConnection($dsn);
不知道你引用的配置文件中是否是对象函数
ADONewConnection($dsn);
adodb/adodb.inc.php里的一个函数。好象是属于smarty模板的
$dsn = 'oci8://user:pwd@tnsname/?persist';