基于当前页面限制页面链接


limit page links based on the current page

我有这样的代码,它将mysql结果拆分为每页10个结果。但我想编辑它,使其根据当前页面限制链接。因此,在第1-10页上,它只显示页面链接1-10,在第11-20页上,仅显示页面链接11-20,依此类推。我如何实现这一点?谢谢

if (isset($_GET["page"])) 
  { 
    $page  = $_GET["page"];
  } 
    else 
  { 
    $page=1; 
  };
$start_from = ($page-1) * 10;
$message =  "SELECT * FROM document WHERE email='$_SESSION[email]' ORDER BY id DESC LIMIT $start_from , 10";
              // echo  results
             // make page links for results
  $sql = "SELECT id FROM document WHERE email = '$_SESSION[email]'";
  $rs_result = $db->query($sql);
  $total_records = $rs_result->num_rows;
  $total_pages = ceil($total_records / 10);
if($rs_result->num_rows >10) {
    $page = "<p class = 'page'>";
for ($i=1; $i<=$total_pages; $i++) 
  {
    $page .="<a href='results.html?page=".$i."'>".$i."</a> ";
  }
    $page .="</p>";
    echo $page;
}

执行此

"SELECT*FROM document WHERE email='$_SESSION[email]'ORDER BY id DESC LIMIT 10 OFFSET$start_FROM";

告诉我它是否有效。