|
|
復(fù)制代碼 代碼如下:
//鏈接數(shù)據(jù)庫'查詢
mysql_connect('localhost','username','userpwd')or die("數(shù)據(jù)庫鏈接失敗".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 >
//頁面跳轉(zhuǎn)
<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="跳轉(zhuǎn)" onclick="check(this)"/>
</td>
</tr>
</table>
</div>
php技術(shù)：php編寫的簡(jiǎn)單頁面跳轉(zhuǎn)功能實(shí)現(xiàn)代碼，轉(zhuǎn)載需保留來源！
鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。
