<?php
	include "include/conn.php";
    $pagesize = 4;  
	$sql = "select * from tb_shop";
	$result = MySQL_query($sql);
	
	$count = MySQL_num_rows($result);  
	
	if($count % $pagesize ==! 0)
	{
		$pagecount = (int)($count / $pagesize);  
	}else
	{
		$pagecount = (int)($count / $pagesize + 1);
	}
	
	if(@ $_GET["page"])
	{
		$pageid = $_GET["page"];
		$start = ($pageid - 1)*$pagesize;
	}else
	{
		$pageid = 1;
		$start = 0;
	}
	 
	$sql2 = "select * from tb_shop limit $start,$pagesize";
	
	$result = MySQL_query($sql2);
	
	while($info = MySQL_fetch_array($result))
	{
		echo "<img src=admin/".$info['photo'].">";
		echo "商品名称：".$info['shopname'];echo"<br>";
		echo "商品价格：".$info['shopprice'];echo"<br>";
		echo "商品简介：".$info['introduction'];
		echo "<hr>";
	}
	?>
    
	<?php
	
	echo "共".$pagecount."页-当前第".$pageid."页"."<form>
		<input type='text' size='5' name='currentpage'/>
		<input type='submit' value='跳转' onClick='check()'/>
	</form>
	";
	?>
	<?php
	function check()
	{
		$mypage = (int)$_GET['currentpage'];
		echo "<a href=?page=".$mypage."></a>";
	}
	
	if($pageid >= 1&& $pagecount >1)
	{
		echo "<a href=?page=1>第一页</a>";
	}
	
	if($pageid > 1&& $pagecount >1)
	
	{
		echo "<a href=?page=".($pageid-1).">上一页</a>";
	}
	
	if($pageid >= 1&& $pagecount > $pageid)
	{
		echo "<a href=?page=".($pageid+1).">下一页</a>";
	}
	
	if($pageid >=1 && $pagecount >1)
	{
		echo "<a href=?page=".$pagecount.">尾页</a>";
	}
	echo "</div>";
	
?>