<?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>
3 回答
Tobey_滔
TA贡献242条经验 获得超128个赞
原因可能有多个哦！首先检查你是否打开了数据库，指定的数据库是否对应。。第二你检查一下SQL语句是否正确，字段名是否正确。。如果都正确就。。。不知道。。需要实测
- 3 回答
- 0 关注
- 2238 浏览
添加回答
举报
0/150
提交
取消