php - 转到我在表中的排名

Question

我在数据库中有包含玩家点数的表。我有页面index.php 显示该表:

if (isset($_GET['page'])){
  $pageload=intval($_GET['page']);
  if ($pageload==1 || $pageload==""){
      $Lpage=0;
      }
  else {
      $Lpage=($pageload*10)-10;
      }}
else{$Lpage=0;}


  $expects="
SELECT id
     , user_id
     , sum(points) AS points 
  FROM expectation 
 GROUP 
    BY user_id 
 ORDER 
    BY points DESC 
 Limit $Lpage,10
";
  $result_ex=mysqli_query($berikane,$expects);
  $row_ex=mysqli_fetch_assoc($result_ex);
  do{ 
  $xx=$xx+1;  
  ?>
        <tr>
          <td width="40" height="35" align="center"><?php echo $xx?></td>
          <td width="170" height="35"><?php  
       echo $row_puid['username'];
       ?></td>
          <td height="35" align="center"><a href="Details.php?<?php echo "uid=".$puid ?>"><?php echo $row_ex['points']?></a></td>
        </tr>

        <?php }while ($row_ex = mysqli_fetch_assoc($result_ex));
        $expects2="SELECT id,user_id,sum(points) AS points FROM expectation GROUP BY user_id ORDER BY points DESC ";
  $result_ex2=mysqli_query($berikane,$expects2);
  $row_ex2=mysqli_fetch_assoc($result_ex2);
  $pcount=mysqli_num_rows($result_ex2); 
  $pcount=$pcount/10;
  $pcount=ceil($pcount);
             ?>
                    <tr>
          <td height="35" colspan="3" align="center"><?php
        for ($pg=1;$pg<=$pcount;$pg++){
            ?> <a href="index.php?page=<?php echo $pg ?>" style="text-decoration:none; font-size:18px"><?php echo $pg ?>&nbsp;&nbsp; </a><?php 
            }     
   ?>

现在index.php显示表中的10行，我必须单击页数才能转到该页面(1,2,3,..等)我想帮助用户单击一个按钮然后就会去到表中包含他的排名的页面。我怎样才能做到这一点？

Answer 1

获取页码

1. 获取当前用户积分

2. 统计所有积分超过当前用户积分的记录

3. 除以每页显示的记录数

现在您应该获得页码