我在php中有一个Web应用程序。用户可以在其中购买软件包,而管理员可以查看每个软件包有多少销售。现在,我通过对付款表中的行进行计数来获得总销售额。要获得购买最多的软件包,我想我必须对数据库中付款表中的行进行计数,并返回购买最多的软件包的ID。但是我不喜欢这个吗?
当前从ID获取包装销售的声明:
$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'];
你可以用这个
SELECT
packageId
FROM
(SELECT packageId, COUNT(*) AS totalSales FROM ph_paypal_payments
GROUP BY packageId) t1
ORDER BY totalSales DESC
LIMIT 1;
Ir为您提供了一个具有totalSales最高的packageId。即使还有更多,它仍然只能使您成为其中之一。
这是基于行数而不是销售数量。
$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'];
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句