php 分页

<?php
date_default_timezone_set("PRC");//设置时区
header("content-type:text/html;charset=utf-8");
$page=$page2=isset($_GET['page'])?$_GET['page']:1;
// $page=$page=0?$page:1;


$num=5;
$offset=($page-1)*$num;
$conn=mysqli_connect("localhost","root","root","blog");
$sql="select * from blog_article limit {$offset},{$num}";
$result=mysqli_query($conn,$sql);


//记录总条数方法
//1:通过mysqli_num_rows
$total=mysqli_num_rows(mysqli_query($conn,"select * from blog_article"));
//2:通过select count(*)
$temp=mysqli_query($conn,"select count(*) as count from blog_article");
$row=mysqli_fetch_assoc($temp);
$total=$row['count'];

$total_page=ceil($total/$num);
echo "$total_page";
// echo $_SERVER['PHP_SELF'];
echo "$page";
//当翻到第一页还要往前翻的时候
if($page<=1){
$pri_page=1;
}else{
  $pri_page=$page-1;
}
if($page==$total_page){
  $next_page=$total_page;
}else{
  $next_page=$page+1;
}


if($result!=false){
  echo "<h2 align='center'>博客列表</h2>";
  echo "<table border ='1' cellspace='0' cellpadding='5' align='center' width='50%'>";
  echo "<tr bgcolor='#26e2e2' ><th>ID</th><th>title</th><th>time</th></tr>";


  while($row=mysqli_fetch_assoc($result))
  {
    echo "<tr>";
    echo "<td>".$row['id']."</td>";
    echo "<td>".$row['title']."</td>";
    echo "<td>".date('Y年m月d日',$row['create_time'])."</td>";
    echo "</tr>";
  }

  echo "</table>";
}else{
  echo "暂时没有留言";
}

echo "<p align='center'>";
echo "<a href='1.php?page=$pri_page'>上一页</a>";
echo "&nbsp&nbsp";
for($i=1;$i<=$total_page;$i++){
            if($i==$page){//当前页为显示页时加背景颜色
              echo "<a style='padding:5px 5px;background:#369fd9;color:#FFF'href='$_SERVER[PHP_SELF]?page=$i'>$i</a>";

            }else{
              echo "<a href='$_SERVER[PHP_SELF]?page=$i' style='padding 5px 5px;'>$i</a>";
            }
            echo "&nbsp";
          }
echo "<a href='1.php?page=$next_page'>下一页</a>";
echo "<p>"

 ?>