//链接数据库'查询 mysql_connect('localhost','username','userpwd')or die("数据库链接失败".mysql_error()); mysql_select_db('库名'); mysql_query('set names utf8'); $sql1="select * from user "; $query1=mysql_query($sql1); $count=array(); while($row=mysql_fetch_assoc($query1)){     $count[]=$row; } $totalnews=count($count); //判断page if($_GET['page']){     $page=$_GET['page']; }else{     $page=1; } $start=($page-1)*$newnum;    $sql="select * from user limit $start,$newnum";    $query=mysql_query($sql);    $ret=array();    while($row=mysql_fetch_assoc($query)){        $ret[]=$row;        } ?> //表格样式 <div id="wrap" style="width:100%;height:100%; ">    <table border="1px"; style="border-collapse:collapse; border:1px solid #000; width:100%;height:100%">      <?php foreach ($ret as $key=>$value){ ?>        <tr>            <td><?php echo $value['id'] ?></td>            <td><?php echo $value['username'] ?></td>            <td><?php echo $value['pwd'] ?></td>            <td>删除|修改</td>        </tr>      <?php } ?>      <tr > //页面跳转            <td colspan="4" align="center"><a href="upload.php?page=1">首页</a> <a href="upload.php?page=<?php echo $lastpage ?>">上一页</a> <?php echo $page; ?>/<?php echo $pagenum; ?> <a href="upload.php?page=<?php echo $nextpage; ?>">下一页</a> <a href="upload.php?page=<?php echo $pagenum ?>">尾页</a><input type="text" name="text" /><input type="button" value="跳转" onclick="check(this)"/>            </td>      </tr>    </table> </div>