我有一個(gè)在php中的網(wǎng)絡(luò)應(yīng)用程序。用戶可以在其中購買包，管理員可以查看每個(gè)包的銷售額。現(xiàn)在，我通過計(jì)算付款表中的行來獲得總銷售額。要獲得購買最多的包裹，我認(rèn)為我必須計(jì)算數(shù)據(jù)庫中付款表中的行數(shù)，并返回大多數(shù)購買包裹的ID。但我不去這個(gè)？從 Id 獲取包裹銷售的當(dāng)前語句：$sql = "SELECT COUNT(*) AS totalSales FROM ph_paypal_payments WHERE packageId = ?";$stmt = mysqli_stmt_init($connection);if (!mysqli_stmt_prepare($stmt, $sql)) die ("Prepare failed: " . mysqli_stmt_error($stmt));mysqli_stmt_bind_param($stmt, "i", $packageId);mysqli_stmt_execute($stmt);return mysqli_fetch_assoc(mysqli_stmt_get_result($stmt))['totalSales'];
1 回答
忽然笑
TA貢獻(xiàn)1806條經(jīng)驗(yàn) 獲得超5個(gè)贊
您可以使用它
SELECT
packageId
FROM
(SELECT packageId, COUNT(*) AS totalSales FROM ph_paypal_payments
GROUP BY packageId) t1
ORDER BY totalSales DESC
LIMIT 1;
Ir 為您提供一個(gè)總銷售額最高的包 ID。即使還有更多，它仍然只得到其中之一。
這是基于行數(shù)，而不是銷售數(shù)量。
$sql = "SELECT packageId FROM (SELECT packageId, COUNT(*) AS totalSales FROM ph_paypal_payments GROUP BY packageId) t1 ORDER BY totalSales DESC LIMIT 1;";
$stmt = mysqli_stmt_init($connection);
if (!mysqli_stmt_prepare($stmt, $sql)) die ("Prepare failed: " . mysqli_stmt_error($stmt));
mysqli_stmt_bind_param($stmt, "i", $packageId);
mysqli_stmt_execute($stmt);
return mysqli_fetch_assoc(mysqli_stmt_get_result($stmt))['packageId'];
- 1 回答
- 0 關(guān)注
- 99 瀏覽
添加回答
舉報(bào)
0/150
提交
取消