PHP에서 RESTful API에 대한 데이터 필터링 및 정렬을 구현하는 방법

<?php
// 获取用户请求的过滤条件
$filters = $_GET['filters'];

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

// 构建SQL查询语句
$sql = "SELECT * FROM users WHERE 1=1";
foreach ($filters as $key => $value) {
  $sql .= " AND $key = '$value'";
}

// 执行查询
$result = $conn->query($sql);

// 处理查询结果
if ($result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    // 处理每一行数据
    echo "User ID: " . $row['id'] . "<br>";
    echo "Name: " . $row['name'] . "<br>";
    echo "Email: " . $row['email'] . "<br>";
  }
} else {
  echo "No results found.";
}

// 关闭数据库连接
$conn->close();
?>

<?php
// 获取用户请求的排序条件
$order = $_GET['order'];

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

// 构建SQL查询语句
$sql = "SELECT * FROM users ORDER BY $order ASC";

// 执行查询
$result = $conn->query($sql);

// 处理查询结果
if ($result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    // 处理每一行数据
    echo "User ID: " . $row['id'] . "<br>";
    echo "Name: " . $row['name'] . "<br>";
    echo "Email: " . $row['email'] . "<br>";
  }
} else {
  echo "No results found.";
}

// 关闭数据库连接
$conn->close();
?>