php - 在 MySQL PDO 查询中限制 FOREACH

Question

我正在使用下面的代码尝试回显 MySQL 表上的最新 5 个条目，我不能，但是似乎能够弄清楚如何限制结果的数量，任何人都可以通过允许我限制结果来帮助我吗5 行的结果数？

<table>
<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/resources/pdo.php"); 
$q = "SELECT * FROM `content` ORDER BY `id`";
$query = $pdo->query($q);
$data = array_reverse($query->fetchAll());
foreach ($data as $row) {
echo "<tr><td>{$row['title']}</td><td>{$row['id']}</td></tr>";
}
?>
</table>

谢谢!

请注意，我是 PHP 的新手，我需要帮助，所以如果这个问题没有用，请帮助我，因为我才刚刚开始。

Answer 1

在 SQL 查询中使用 LIMIT 子句:

SELECT * FROM `content` ORDER BY `id` DESC LIMIT 5

来自 the manual :

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants (except when using prepared statements).

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):