分页记录

分页信息 

       $pagesize=10;
       if (isset($_GET['page'])){
       $page=intval($_GET['page']);
       }else{
       $page=1;
       }
       $sqlstr=mysql_query("select * from tolook ",$connstr);
       $allrow=mysql_num_rows($sqlstr);
        if ($allrow){
         if ($allrow<$pagesize){$page_count=1;}  //如果总记录数小于分页数就分页数=1因为能在一页显示下
        if ($allrow % $pagesize) {
        $page_count=(int)($allrow / $pagesize)+1;
        }else{
        $page_count=$allrow / $pagesize;
        }
       }else{
       $pagesize=0;   //如果记录为空 那就分页数为空
       }
     
    $page_string = '';
if( $page == 1 ){
   $page_string .= '第一页|上一页|';
}
else{
   $page_string .= '第一页|上一页|';
}
if( ($page == $page_count) || ($page_count == 0) ){
   $page_string .= '下一页|尾页';
}
else{
   $page_string .= '下一页|尾页';
}
     if ($allrow){
   $sqls=" select * from tolook where userid='ehxee' limit ". ($page-1)*$pagesize .", $pagesize";
        $resut=mysql_query($sqls,$connstr);
       while ($rrows=mysql_fetch_array($resut)){
        $title=$rrows["titile"];
        $lookordown=$rrows["lookordown"];
        $looktime=$rrows["looktime"];
        $userip=$rrows["userip"];
       
              echo "";
              echo "  $title";
              echo "  $lookordown";
              echo "  $looktime";
              echo "  $userip";
              echo "";
           }
      
       if ($title==""){
             echo "对不起!您现在还没有任何消费记录";
   }
  }
        ?>