require_once("inc/conn.php");
//--获取case列表
//分页程序 2014-08-28
$perpagenum = 12;//定义每页显示几条
$sql="select count(1) from zarticle where tid=3 ";
$total = mysqli_fetch_array(mysqli_query($db,$sql));//查询数据库中一共有多少条数据
$Total = $total[0]; //
$Totalpage = ceil($Total/$perpagenum);//上舍,取整
if(!isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage)//page可能的四种状态
{
$page=1;
}
else
{
$page=$_GET['page'];//如果不满足以上四种情况,则page的值为$_GET['page']
}
$startnum = ($page-1)*$perpagenum;//开始条数
$sql = "select * from zarticle where tid=3 order by id desc limit $startnum,$perpagenum";//查询出所需要的条数
//echo $sql;
$rs = mysqli_query($db,$sql);
//---------- end 分页程序
$per = $page - 1;//上一页
$next = $page + 1;//下一页
//echo "
共有".$Total."条记录,每页".$perpagenum."条,共".$Totalpage."页 ";
$lasturl="javascript:alert('已是第一页')";
$nexturl="javascript:alert('已是最后一页')";
if($page != 1)
{
$lasturl=$_SERVER['PHP_SELF'].'?page='.$per;
}
if($page != $Totalpage)
{
$nexturl=$_SERVER['PHP_SELF'].'?page='.$next;
}
//生成左右各最多两个页码
$zleft='';
$zright='';
if($page>1){
$l=$page-1;
$zleft .=''.$l .'';
}
if($page>2){
$l=$page-2;
$zleft =''.$l .''.$zleft;
}
if($page+1<=$Totalpage){
$r=$page+1;
$zright .=''.$r .'';
}
if($page+2<=$Totalpage){
$r=$page+2;
$zright .=''.$r .'';
}
?>
客户案例 -
Case Center
$i=($page-1)*$perpagenum;
while($data=mysqli_fetch_array($rs)){
$i++;
$zpic=$data['zpic'];
$spic=str_replace('files/','files/s/',$zpic);
$id=$data['id'];
echo '
';
}?>