[PHP]帮忙看看这个页面报错，网上很多类似却找不到解决办法

Fatal error: Call to a member function RowCount() on a non-object 已经说的很清楚了啊，你的 $rs 不是一个 object，原因：$rs = $conn->Execute($sql); 未能返回正确的 object，你在这行后面 print_r $rs 看看？

你用的什么数据库类啊？用zend studio好好调试下看$conn->Execute($sql);到底是怎么返回的照你现在的写法应该是个数据集对象但现在返回的肯定不是个数据集

错误提示是很清楚但不知道怎么解决啊由于这行就报错了在后面也没办法print_r($rs)啊
RowCount()函数是某对象的成员函数，我觉得程序应该是正确的因为在一台机器中运行正常，我怀疑是本机的服务器环境配置问题，网上说在php.ini文件里要把全局变量设置register_globals = On 但我这样设置并重启后问题依然没变化，烦啊！谢谢楼上！还有办法吗？？

先把这行注释掉
再print_r($rs)

前面的代码是这样的，不知道有没有帮助：include_once("./lib/public.php");$action = getValue("action");
$user_name = getValue("user_name");
$user_nick =getValue("user_nick");
$pass_word = getValue("pass_word");
$pass_word_c = getValue("pass_word_c");
$pass_word_pay = getValue("pass_word_pay");
$pass_word_pay_c = getValue("pass_word_pay_c");
$user_email = getValue("user_email");
$user_truename = getValue("user_truename");
$user_idcard = getValue("user_idcard");
$user_idcard_c = getValue("user_idcard_c");
$user_bank = getValue("user_bank");
$user_bank_num = getValue("user_bank_num");
$user_sex = getValue("user_sex");
$user_birthday_y = getValue("user_birthday_y");
$user_birthday_m = getValue("user_birthday_m");
$user_birthday_d = getValue("user_birthday_d");
$user_tel = getValue("user_tel");
$user_from = getValue("user_from");
$user_activation = "1";
$user_grade = "A";switch($action){ case "reg" : // 注册 checkRandPic();
$user_name = checkLength($user_name,1,15);
$pass_word_pay = checkLength($pass_word_pay,6,10);
$user_idcard = checkLength($user_idcard,15,18,"身份证");
$user_email = checkEmail($user_email);
$user_truename = isNotNull($user_truename);
isSame($pass_word_pay,$pass_word_pay_c,"交易密码");
isSame($user_idcard,$user_idcard_c,"身份证号");
$pass_word_pay = md5($pass_word_pay);
$user_birthday =  $user_birthday_y."-".$user_birthday_m;
$sql = "SELECT `user_id` FROM `user` WHERE `user_name`='".$user_name."' ORDER BY `user_id` DESC";
$rs    = $conn->Execute($sql);
$total = $rs->RowCount();
if($total!=0){
errorGo("已经存在这个用户!");
} $table = "user";
$sql_f = array("user_name","user_nick","pass_word","pass_word_pay","user_email","user_truename","user_idcard","user_bank","user_bank_num","user_sex","user_birthday","user_tel","user_from");
$sql_v =
array($user_name, $user_nick, $pass_word, $pass_word_pay, $user_email, $user_truename, $user_idcard, $user_bank, $user_bank_num, $user_sex, $user_birthday, $user_tel, $user_from);
$sql = insertSQL($table,$sql_f,$sql_v);
$rs    = $conn->Execute($sql); $sql = "SELECT `user_id` FROM `user` WHERE `user_name`='".$user_name."' ORDER BY `user_id` DESC";
$rs    = $conn->Execute($sql); $ar = $rs->FetchRow(); $user_action = "1000001"; // 注册代码
logUserAct($user_action,"",$ar['user_id']); $logonInfo= md5($USER_V.md5($pass_word_pay)).($user_name);
setcookie("logonInfo",$logonInfo);

$conn = changeDBConn($PGSQL_III["database"],$PGSQL_III["hostname"], $PGSQL_III["username"], $PGSQL_III["password"]);
$table = "cdb_members";
$sql_f = array("username","password","email","groupid","regdate","lastvisit","lastactivity");
$sql_v =
array($user_name, $pass_word_pay, $user_email,"10",time(),time(),time());
$sql = insertSQL($table,$sql_f,$sql_v);
$rs    = $conn->Execute($sql);
errorGo($ERROR_MESSAGE["useradd_OK"],"index.php"); break; //case "reg" case "checkUsername":
$sql = "SELECT `user_id` FROM `user` WHERE user_name='".$user_name."' ORDER BY `user_id` DESC";
//echo $sql;
$rs    = $conn->Execute($sql);
$total = $rs->RowCount();// ！！！报错行！！！！！！！！！！！！！
if($total!=0){
errorGo("已经存在这个用户!");
}else{
errorGo("用户不存在,请放心注册!");
}
break; default : $t->set_file("main","userReg.htm");

$t->set_file("Heads","Head.htm");
$t->parse("Head","Heads");
$t->set_file("LOGINs","LOGIN.htm");
$t->parse("LOGIN","LOGINs");
$t->set_file("ADs","AD.htm");
$t->parse("AD","ADs");
$t->set_file("LotteryHeads","LotteryHead.htm");
$t->parse("LotteryHead","LotteryHeads");
$t->set_file("LotteryTitles","LotteryTitle.htm");
$t->parse("LotteryTitle","LotteryTitles");
$t->set_file("Foots","Foot.htm");
$t->parse("Foot","Foots");
}
$t->pparse("OUT","main");
@$rs->Close();
@$conn->Close();---------------------------------------------------------------------------------
此页的代码就是这样的
进入此页面时是选择的case "checkUsername":下的部分该函数所在的类是这样的（里面函数很多，没有全贴）：
class ADOConnection {                //省略部分……             function RowCount() {
                return $this->_numOfRows;
             }

                //省略部分……
           }

162： $sql = "SELECT `user_id` FROM `user` WHERE user_name='".$user_name."' ORDER BY `user_id` DESC";163： $rs = $conn->Execute($sql);echo 'Debug:<pre>';
print_r($conn);
print_r($rs);
echo '</pre>';164： total = $rs->RowCount();输出什么？贴出来看看

或者你改成这样得了！$result = $conn->Execute("SELECT count(user_id) AS count FROM user WHERE user_name=".$user_name."ORDER BY user_id DESC");
$temp = mysql_fetch_array($result);
$total = $temp[count];

楼上：改成那样是对的但是使用对象不对啊
楼上的楼上：
debug输出是这样的：
Debug:
ADODB_mysql Object
(
    [databaseType] => mysql
    [dataProvider] => mysql
    [hasInsertID] => 1
    [hasAffectedRows] => 1
    [metaTablesSQL] => SHOW TABLES
    [metaColumnsSQL] => SHOW COLUMNS FROM `%s`
    [fmtTimeStamp] => 'Y-m-d H:i:s'
    [hasLimit] => 1
    [hasMoveFirst] => 1
    [hasGenID] => 1
    [isoDates] => 1
    [sysDate] => CURDATE()
    [sysTimeStamp] => NOW()
    [hasTransactions] =>
    [forceNewConnect] =>
    [poorAffectedRows] => 1
    [clientFlags] => 0
    [substr] => substring
    [nameQuote] => `
    [compat323] =>
    [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
    [_genSeqSQL] => create table %s (id int not null)
    [_genSeqCountSQL] => select count(*) from %s
    [_genSeq2SQL] => insert into %s values (%s)
    [_dropSeqSQL] => drop table %s
    [database] => fb
    [host] => localhost
    [user] => root
    [password] =>
    [debug] =>
    [maxblobsize] => 262144
    [concat_operator] => +
    [length] => length
    [random] => rand()
    [upperCase] => upper
    [fmtDate] => 'Y-m-d'
    [true] => 1
    [false] => 0
    [replaceQuote] => \'
    [charSet] =>
    [metaDatabasesSQL] =>
    [uniqueOrderBy] =>
    [emptyDate] =>
    [emptyTimeStamp] =>
    [lastInsID] =>
    [hasTop] =>
    [readOnly] =>
    [genID] => 0
    [raiseErrorFn] =>
    [cacheSecs] => 3600
    [memCache] =>
    [memCacheHost] =>
    [memCachePort] => 11211
    [memCacheCompress] =>
    [arrayClass] => ADORecordSet_array
    [noNullStrings] =>
    [numCacheHits] => 0
    [numCacheMisses] => 0
    [pageExecuteCountRows] => 1
    [uniqueSort] =>
    [leftOuter] =>
    [rightOuter] =>
    [ansiOuter] =>
    [autoRollback] =>
    [fnExecute] =>
    [fnCacheExecute] =>
    [blobEncodeType] =>
    [rsPrefix] => ADORecordSet_
    [autoCommit] => 1
    [transOff] => 0
    [transCnt] => 0
    [fetchMode] =>
    [null2null] => null
    [_oldRaiseFn] =>
    [_transOK] =>
    [_connectionID] => Resource id #9
    [_errorMsg] =>
    [_errorCode] =>
    [_queryID] =>
    [_isPersistentConnection] =>
    [_bindInputArray] =>
    [_evalAll] =>
    [_affected] =>
    [_logsql] =>
    [_transmode] =>
    [databaseName] => fb
)
很多不相关的你能看出哪里的问题么？

print_r($rs)无显示,说明$rs是空的咯?
将sql语句放到mysql里运行看看是否正确。

由于将网站在另一台服务器运行是正常的但移植到本机后就出现很多页面有类似的问题所以怀疑是PHP配置不对，或者版本？不知道，各位朋友有过这样问题的吗？配置上有什么地方可能导致这样的问题？？

print_r($rs)看一下，应该是空的

如果在另一台服务器运行正常，那就是配置或者版本的问题了！你分别在两个服务器上运行<? phpinfo();?>，看看有何不同？

LZ用的这个类是ADODBexecute方法的实现如下 function &Execute($sql,$inputarr=false)
{
if ($this->fnExecute) {
$fn = $this->fnExecute;
$ret =& $fn($this,$sql,$inputarr);
if (isset($ret)) return $ret;
}
if ($inputarr) {
if (!is_array($inputarr)) $inputarr = array($inputarr);

$element0 = reset($inputarr);
# is_object check because oci8 descriptors can be passed in
$array_2d = is_array($element0) && !is_object(reset($element0));
//remove extra memory copy of input -mikefedyk
unset($element0);

if (!is_array($sql) && !$this->_bindInputArray) {
$sqlarr = explode('?',$sql);

if (!$array_2d) $inputarr = array($inputarr);
foreach($inputarr as $arr) {
$sql = ''; $i = 0;
//Use each() instead of foreach to reduce memory usage -mikefedyk
while(list(, $v) = each($arr)) {
$sql .= $sqlarr[$i];
// from Ron Baldwin <ron.baldwin#sourceprose.com>
// Only quote string types
$typ = gettype($v);
if ($typ == 'string')
//New memory copy of input created here -mikefedyk
$sql .= $this->qstr($v);
else if ($typ == 'double')
$sql .= str_replace(',','.',$v); // locales fix so 1.1 does not get converted to 1,1
else if ($typ == 'boolean')
$sql .= $v ? $this->true : $this->false;
else if ($typ == 'object') {
if (method_exists($v, '__toString')) $sql .= $this->qstr($v->__toString());
else $sql .= $this->qstr((string) $v);
} else if ($v === null)
$sql .= 'NULL';
else
$sql .= $v;
$i += 1;
}
if (isset($sqlarr[$i])) {
$sql .= $sqlarr[$i];
if ($i+1 != sizeof($sqlarr)) ADOConnection::outp( "Input Array does not match ?: ".htmlspecialchars($sql));
} else if ($i != sizeof($sqlarr))
ADOConnection::outp( "Input array does not match ?: ".htmlspecialchars($sql));

$ret =& $this->_Execute($sql);
if (!$ret) return $ret;
}
} else {
if ($array_2d) {
if (is_string($sql))
$stmt = $this->Prepare($sql);
else
$stmt = $sql;

foreach($inputarr as $arr) {
$ret =& $this->_Execute($stmt,$arr);
if (!$ret) return $ret;
}
} else {
$ret =& $this->_Execute($sql,$inputarr);
}
}
} else {
$ret =& $this->_Execute($sql,false);
} return $ret;
}

function &_Execute($sql,$inputarr=false)
{
if ($this->debug) {
global $ADODB_INCLUDED_LIB;
if (empty($ADODB_INCLUDED_LIB)) include(ADODB_DIR.'/adodb-lib.inc.php');
$this->_queryID = _adodb_debug_execute($this, $sql,$inputarr);
} else {
$this->_queryID = @$this->_query($sql,$inputarr);
}

/************************
// OK, query executed
*************************/ if ($this->_queryID === false) { // error handling if query fails
if ($this->debug == 99) adodb_backtrace(true,5);
$fn = $this->raiseErrorFn;
if ($fn) {
$fn($this->databaseType,'EXECUTE',$this->ErrorNo(),$this->ErrorMsg(),$sql,$inputarr,$this);
}
$false = false;
return $false;
}

if ($this->_queryID === true) { // return simplified recordset for inserts/updates/deletes with lower overhead
$rs = new ADORecordSet_empty();
return $rs;
}

// return real recordset from select statement
$rsclass = $this->rsPrefix.$this->databaseType;
$rs = new $rsclass($this->_queryID,$this->fetchMode);
$rs->connection = &$this; // Pablo suggestion
$rs->Init();
if (is_array($sql)) $rs->sql = $sql[0];
else $rs->sql = $sql;
if ($rs->_numOfRows <= 0) {
global $ADODB_COUNTRECS;
if ($ADODB_COUNTRECS) {
if (!$rs->EOF) {
$rs = &$this->_rs2rs($rs,-1,-1,!is_array($sql));
$rs->_queryID = $this->_queryID;
} else
$rs->_numOfRows = 0;
}
}
return $rs;
}

wowh(NETwalker)：的确用的那个类，请问哪里可能导致问题？

我也不好说我就用过PEAR DB和自己写的类解决这种问题最好的办法就是调试了一步步找到错误的地方

错误行代码：
162： $sql = "SELECT `user_id` FROM `user` WHERE user_name='".$user_name."' ORDER BY `user_id` DESC";
****你先在后面加一个
echo $sql;
我看是sql语句有问题

on a non-object
total = $rs->RowCount();这行里$rs吧是对象。或者为NULL

和我遇到的问题一样
在本机测试是好的。。传到服务器上就不行了
Fatal error: Call to a member function query() on a non-object in ....
至今没找到解决的办法

楼上的一定告诉你郁闷还没解决网上查到唯一明确说的一个解决办法是在配置里设置regester_globals = On ，但是我这样设置后问题依旧！请问各位还有什么办法？关于设置regester_globals = On 应该只有php.ini里的一处吧！？

对比一下你的本地和网上的 php、mysql 版本，感觉应该是版本的差异了，另外，网上和本地的操作系统也有可能存在一些影响，当前我们正在做的一个项目就是这样，win下ok，linux 服务器上面同一个php版本就不行，

楼上我也感觉是这些因素，服务器是Unix的运行正常，将程序移植到Win或Linux后都是一样的问题，那么怎么解决这种问题呢？难道程序代码不够标准？怎样使PHP程序能兼容不同的平台和版本？

唉，我也不知道该怎样才能做到跨平台和版本，我现在版本完全一样都没能够跨平台的，我也在郁闷中，不过对于不同的平台，应该可以找到一些变通的方法解决问题，这个，就只有你自己跟踪代码，一步一步的找到出问题的地方，然后再想法 fix 了，别人没有对应的环境，也没法帮你了，不过这个过程是很郁闷和无奈的过程，急不得的，我也该郁闷去了，

谢谢楼上，难道在不同的平台或版本下一些函数或类的运行机制不同吧，看来只有自己一行行去测去改了，my god...想着都要疯了，朋友们还有高招吗

164： total = $rs->RowCount();164： $total = $conn->RowCount($rs);

ADODB中获取记录集总数：$rs->RecordCount()如果还不行，下个最新版ADODB吧

检查下编码是否一致。
如果网页用的是gbk，就$conn->exec("set character set gbk");

最好是写成这样：$temp = mysql_fetch_object($sql);
然后可以执行对象操作了
楼主应该用他的查询语句，你写的SQL语句不太规范。

调试易

[PHP]帮忙看看这个页面报错，网上很多类似却找不到解决办法

解决方案 »