1. 數(shù)據(jù)庫查詢
使用 SQL 語句對商品數(shù)據(jù)進(jìn)行排序：
sql
-- 按銷量降序
SELECT * FROM products ORDER BY sales DESC;
-- 按銷量升序
SELECT * FROM products ORDER BY sales ASC;
-- 按價(jià)格降序
SELECT * FROM products ORDER BY price DESC;
-- 按價(jià)格升序
SELECT * FROM products ORDER BY price ASC;
2. PHP 代碼
在 PHP 中執(zhí)行 SQL 查詢，并返回 JSON 數(shù)據(jù)：
php
<?php
$pdo = new PDO("mysql:host=localhost;dbname=shop", "root", "password");
$sort_by = $_GET['sort_by'] ?? 'sales'; // 默認(rèn)按銷量排序
$sort_order = $_GET['sort_order'] ?? 'DESC'; // 默認(rèn)降序
$sql = "SELECT * FROM products ORDER BY $sort_by $sort_order";
$result = $pdo->query($sql);
$products = $result->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($products);
?>
