按这个例子实现遇到问题,环境是wampserver 2.0
http://www.163pub.cn/a/PHP/2010/0626/109.html
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\zqlc\dao\userDao.php on line 20Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in D:\wamp\www\zqlc\dao\userDao.php on line 27Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\zqlc\dao\userDao.php on line 31错误的位置:
创建dao:userDao.php=====================================<?php
class userDao {
//列出数据(dao)
function getUserList($con,$pageNo,$pageSize,$selectText,$selectFields) {
$begin = ($pageNo-1)*$pageSize;
if($selectText != '') { //查找
$sql1 = "select count(*) from user where username like '%".$selectText."%'";
$sql2 = "select * from user where ".$selectFields." like '%".$selectText."%' order by id desc limit ".$begin.','.$pageSize;
}else { //列出所有数据
$sql1 = "select count(*) from user";
$sql2 = "select * from user order by id desc limit ".$begin.','.$pageSize;
}
$row = mysql_query($sql1);
$row = mysql_fetch_array($row); ///////////////////////////// 错误的地方
//print_r($row);
$row = $row[0];
$result = mysql_query($sql2,$con);
//获取字段
$fieldNum = mysql_num_fields($result);
//echo mysql_field_name($result,1);
$userList = '';
while($rs=mysql_fetch_array($result)) {
$userList[] = $rs;
}
//print_r($userList);
if($row%$pageSize) {
$pageObject['maxPage'] = intval($row/$pageSize)+1;
}else {
$pageObject['maxPage'] = $row/$pageSize;
}
$pageObject['list'] = $userList;
$pageObject['sum'] = $row;
$pageObject['result'] = $result;
$pageObject['fieldNum'] = $fieldNum;
$pageObject['selectText'] = $selectText;
return $pageObject;
}
http://www.163pub.cn/a/PHP/2010/0626/109.html
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\zqlc\dao\userDao.php on line 20Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in D:\wamp\www\zqlc\dao\userDao.php on line 27Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\zqlc\dao\userDao.php on line 31错误的位置:
创建dao:userDao.php=====================================<?php
class userDao {
//列出数据(dao)
function getUserList($con,$pageNo,$pageSize,$selectText,$selectFields) {
$begin = ($pageNo-1)*$pageSize;
if($selectText != '') { //查找
$sql1 = "select count(*) from user where username like '%".$selectText."%'";
$sql2 = "select * from user where ".$selectFields." like '%".$selectText."%' order by id desc limit ".$begin.','.$pageSize;
}else { //列出所有数据
$sql1 = "select count(*) from user";
$sql2 = "select * from user order by id desc limit ".$begin.','.$pageSize;
}
$row = mysql_query($sql1);
$row = mysql_fetch_array($row); ///////////////////////////// 错误的地方
//print_r($row);
$row = $row[0];
$result = mysql_query($sql2,$con);
//获取字段
$fieldNum = mysql_num_fields($result);
//echo mysql_field_name($result,1);
$userList = '';
while($rs=mysql_fetch_array($result)) {
$userList[] = $rs;
}
//print_r($userList);
if($row%$pageSize) {
$pageObject['maxPage'] = intval($row/$pageSize)+1;
}else {
$pageObject['maxPage'] = $row/$pageSize;
}
$pageObject['list'] = $userList;
$pageObject['sum'] = $row;
$pageObject['result'] = $result;
$pageObject['fieldNum'] = $fieldNum;
$pageObject['selectText'] = $selectText;
return $pageObject;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货