$query=“从我的\u数据中选择*，其中id介于（$id+1）和（$id+4）之间，order by id desc”；
在处理查询时要小心sql注入！

试着用这个。

<?php 
$connection = mysqli_connect("localhost","my_user","my_password","my_db");
$id = $_GET["id"];
$query ="";
$query.= "Select * from my_data where id between ($id+1) and ($id+4)";
$query.= " order by id DESC"; //concat query as per requirement. 
$result = mysqli_query($connection,$query);
while ($row = mysqli_fetch_assoc($result)) {

    $array[] = $row;    
}
header('Content-Type:Application/json');
echo json_encode($array);
?>

还可以通过在变量上设置按字段名和按类型（asc/desc）动态传递order。请随时询问任何关于它的问题。

让我们试试这个：
我加了一个额外的 order 参数如果未设置，则将按降序排列，否则将设置为 &order=asc 用于加入订单结果。订购是在 id 在野外。
更新数据库连接设置

<?php 

   //kindly change connection parameter as per you need
    $connection = mysqli_connect("localhost","root","","test");
   $id = $_GET["id"];

   isset( $_GET['order']) ? $order =$_GET['order'] : $order= 'desc';

   if($order === 'asc'){
       $query = "Select * from person where id between ($id+1) and ($id+4) order by id asc";
   }else{
       $query = "Select * from person where id between ($id+1) and ($id+4) order by id desc";
   }

  $result = mysqli_query($connection,$query);
 while ($row = mysqli_fetch_assoc($result)) {
    $array[] = $row;    
 }
 header('Content-Type:Application/json');

    echo json_encode($array);
?>

请注意url

输出asc

输出描述

所以你想先找到id最高的条目？那么应该是这样的：

Select * from my_data where id between ($id+1) and ($id+4) ORDER BY id DESC