|
不多说，直接上代码
<div class="codetitle"><a style="CURSOR: pointer" data="83524" class="copybut" id="copybut83524" onclick="doCopy('code83524')"> 代码如下:<div class="codebody" id="code83524">
//链接数据库'查询
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 } ?>
//页面跳转
<td colspan="4" align="center"><a href="upload.php?page=1">首页 <a href="upload.php?page=<?php echo $lastpage ?>">上一页 <?php echo $page; ?>/<?php echo $pagenum; ?> <a href="upload.php?page=<?php echo $nextpage; ?>">下一页 <a href="upload.php?page=<?php echo $pagenum ?>">尾页<input type="button" value="跳转" onclick="check(this)"/>
</td>
</tr>
</table>
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
|
