Paparan produk tutorial laman web korporat pembangunan PHP (2)
Dalam kursus sebelumnya, kami telah menyelesaikan kesan paging berita
Jadi kami boleh menyalin kod paging di bahagian sebelumnya dan kemudian menukar nama jadual
Kod tersebut adalah seperti berikut :
<?php
require_once('conn.php'); //連接數(shù)據(jù)庫
$page=isset($_GET['page']) ?$_GET['page'] :1 ;//接收頁碼
$page=!empty($page) ? $page :1;
$table_name="product";//查取表名設(shè)置
$perpage=4;//每頁顯示的數(shù)據(jù)個數(shù)
//最大頁數(shù)和總記錄數(shù)
$total_sql="SELECT count(*) from $table_name";
$total_result =mysql_query($total_sql);
$total_row=mysql_fetch_row($total_result);
$total = $total_row[0];//獲取最大頁碼數(shù)
$total_page = ceil($total/$perpage);//向上整數(shù)
//臨界點(diǎn)
$page=$page>$total_page ? $total_page:$page;//當(dāng)下一頁數(shù)大于最大頁數(shù)時的情況
//分頁設(shè)置初始化
$start=($page-1)*$perpage;
$sql = "SELECT * from product order by id desc limit $start,$perpage";
$info = mysql_query($sql);
//$sql = "select * from product order by id desc"; //查詢user表中的數(shù)據(jù)
//$info = mysql_query($sql);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>展示用戶列表</title>
<style type="text/css">
.top{height:30px;line-height:30px;float:right;margin-right:15px;}
.top a{color:red;text-decoration:none;}
.cont{width:100%;height:300px;float:left;}
.cont_ct{float:left;}
table{width:100%;border:1px solid #eee;text-align:center;}
th{background:#eee;height:30px;}
td{width:200px;height:70px;}
</style>
</head>
<body>
<div class="top"><a href="addpro.php">添加產(chǎn)品</a></div>
<div class="cont">
<table cellspacing="0" cellpadding="0" border="1">
<tr>
<th>ID</th>
<th>名稱</th>
<th>圖片</th>
<th>價格</th>
<th>操作</th>
</tr>
<?php
while($row = mysql_fetch_array($info)){
?>
<tr>
<td><?php echo $row['id'];?></td>
<td><?php echo $row['title'];?></td>
<td><img src="../uploads/<?php echo $row['imgname'];?>" width="50" height="50"></td>
<td><?php echo $row['price'];?></td>
<td>
<a href="modifypro.php?id=<?php echo $row['id'];?>">修改</a>
<a href="delproduct.php?id=<?php echo $row['id'];?>">刪除</a>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="5">
<a href="<?php echo "$_SERVER[PHP_SELF]?page=1"?>">首頁</a>
<a href="<?php echo "$_SERVER[PHP_SELF]?page=".($page-1)?>">上一頁</a><a href="<?php echo "$_SERVER[PHP_SELF]?page=".($page+1)?>">下一頁</a>
<a href="<?php echo "$_SERVER[PHP_SELF]?page={$total_page}"?>">末頁</a>
</td>
</tr>
</table>
</div>
</body>
</html>Dengan cara ini kami telah melengkapkan kesan paging
