连接数据库了，并且表里有数据，一直提示为空，sorry,没有用户,请添加!
<?php
error_reporting(E_ALL & ~E_NOTICE);
require_once '../include.php';
$page=$_REQUEST['page']?(int)$_REQUEST['page']:1;
$sql="select * from allowance_user";
$totalRows=getResultNum($sql);
$pageSize=5;
$totalPage=ceil($totalRows/$pageSize);
if($page<1||$page==null||!is_numeric($page))$page=1;
if($page>=$totalPage)$page=$totalPage;
$offset=($page-1)*$pageSize;
$sql="select id,cusname,mail,Call,Sex from allowance_user order by id asc limit {$offset},{$pageSize}";
$rows=fetchAll($sql);
if(!$rows){
alertMes("sorry,没有用户,请添加!","addUser.php");
exit;
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>-.-</title>
<link rel="stylesheet" href="styles/backstage.css">
</head>
<body>
<div class="details">
<div class="details_operation clearfix">
<div class="bui_select">
<input type="button" value="添 加" class="add" onclick="addAUser()">
</div>
</div>
<!--表格-->
<table class="table" cellspacing="0" cellpadding="0">
<thead>
<tr>
<th width="15%">编号</th>
<th width="20%">用户名称</th>
<th width="20%">用户性别</th>
<th width="20%">用户邮箱</th>
<th width="20%">用户手机</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<?php foreach($rows as $row):?>
<tr>
<td><input type="checkbox" id="c1" class="check"><label for="c1" class="label"><?php echo $row['id'];?></label></td>
<td><?php echo $row['cusname'];?></td>
<td><?php echo $row['Sex'];?></td>
<td><?php echo $row['mail'];?></td>
<td><?php echo $row['Call'];?></td>
<td align="center"><input type="button" value="修改" class="btn" onclick="editUser(<?php echo $row['id'];?>)"><input type="button" value="删除" class="btn" onclick="delUser(<?php echo $row['id'];?>)"></td>
</tr>
<?php endforeach;?>
</tbody>
</table>
</div>
</body>
<script type="text/javascript">
function addUser(){
window.location="addUser.php";
}
function editUser(id){
window.location="editUser.php?id="+id;
}
function delUser(id){
if(window.confirm("您确定要删除吗？删除之后不可以恢复哦！！！")){
window.location="doAdminAction.php?act=delUser&id="+id;
}
}
</script>
</html>
慕先生00860813回答
-
hua01234567899
显示为空应该就是没有进行数据查询导致result为空 -
Tobey_滔
原因可能有多个哦！首先检查你是否打开了数据库，指定的数据库是否对应。。第二你检查一下SQL语句是否正确，字段名是否正确。。如果都正确就。。。不知道。。需要实测
随时随地看视频慕课网APP
PHP