query("SET NAMES utf8"); $cateid=$_GET['cateid']; $perNumber=5; $page=$_GET['page']; $result=$db->query("SELECT COUNT(*) c FROM product WHERE CategoryId = ".$cateid); $row=$result->fetch_assoc(); $totalNumber=$row["c"]; $totalPage=ceil($totalNumber/$perNumber); if(!isset($page)){ $page=1; } $startCount=($page-1)*$perNumber; $result=$db->query("SELECT productid,name,descn,image,listprice FROM product WHERE categoryid = $cateid LIMIT $startCount,$perNumber"); echo "
"; if($result->num_rows>=1){ echo "
"; while ($row = $result->fetch_assoc()){ echo "
".$row["name"]." | ".$row["descn"]." | ". " | ".$row["listprice"]. " | 加入购物车". " |
"; } echo ""; } if($page !=1){ ?>
上一页 "> 下一页