不多说，直接上代码
//链接数据库'查询<BR>mysql_connect('localhost','username','userpwd')or die("数据库链接失败".mysql_error());<BR>mysql_select_db('库名');<BR>mysql_query('set names utf8');<BR>$sql1="select * from user ";<BR>$query1=mysql_query($sql1);<BR>$count=array();<BR>while($row=mysql_fetch_assoc($query1)){<BR> $count[]=$row;<BR>}<BR>$totalnews=count($count);<BR>//判断page<BR>if($_GET['page']){<BR> $page=$_GET['page'];<BR>}else{<BR> $page=1;<BR>}<BR>$start=($page-1)*$newnum;<BR> $sql="select * from user limit $start,$newnum";<BR> $query=mysql_query($sql);<BR> $ret=array();<BR> while($row=mysql_fetch_assoc($query)){<BR> $ret[]=$row;<BR> }<BR>?><BR>//表格样式<BR><div id="wrap" style="width:100%;height:100%"><BR> <table style="border-collapse:collapse;border:1px solid #000;width:100%;height:100%"><BR> <?php foreach ($ret as $key=>$value){ ?><BR> <tr><BR> <td><?php echo $value['id'] ?></td><BR> <td><?php echo $value['username'] ?></td><BR> <td><?php echo $value['pwd'] ?></td><BR> <td>删除|修改</td><BR><b>%本文@来源gao@!dai!ma.com搞$$代^@码!网</b><strong>搞代gaodaima码</strong> </tr><BR> <?php } ?><BR> <tr><BR>//页面跳转<BR> <td colspan="4" align="center">首页 ">上一页 <?php echo $page; ?>/<?php echo $pagenum; ?> ">下一页 ">尾页<BR> </td><BR> </tr><BR> </table><BR>
