點擊藍字關注我們！每天獲取最新的編程小知識！
源 / php中文網 源 / www.php.cn
在MySQL中，LIMIT子句與SELECT語句一起使用，以限制結果集中的行數。LIMIT子句接受一個或兩個offset和count的參數。這兩個參數的值都可以是零或正整數。
offset:用於指定要返回的第一行的偏移量。
Count:用於指定要返回的最大行數。
Limit子句接受一個或兩個參數，當指定兩個參數時，第一個參數表示偏移量，第二個參數表示計數，而當只指定一個參數時，它表示從結果集開始返回的行數。
LIMIT語法：
SELECT column1, column2, ...
FROM table_name
LIMIT offset, count;
如下表「Data」，其中包含三列「Firstname」、「Lastname」和「Age」。SELECT * FROM Data LIMIT 3;
要從「Data」表中檢索第2-3行(包括)，我們將使用以下查詢:
SELECT * FROM Data LIMIT 1, 2;
下面是PHP mysql實現查詢的代碼示例:
示例1：Limit條件
< ? php
$link = mysqli_connect("localhost", "root", "", "Mydb");
if ($link == = false) {
die("ERROR: Could not connect. ".mysqli_connect_error());
}
$sql = "SELECT * FROM Data LIMIT 2";
if ($res = mysqli_query($link, $sql)) {
if (mysqli_num_rows($res) > 0) {
echo "<table>";
echo "<tr>";
echo "<th>Firstname</th>";
echo "<th>Lastname</th>";
echo "<th>Age</th>";
echo "</tr>";
while ($row = mysqli_fetch_array($res)) {
echo "<tr>";
echo "<td>".$row['Firstname']."</td>";
echo "<td>".$row['Lastname']."</td>";
echo "<td>".$row['Age']."</td>";
echo "</tr>";
}
echo "</table>";
mysqli_free_result($res);
}
else {
echo "No matching records are found.";
}
}
else {
echo "ERROR: Could not able to execute $sql. ".mysqli_error($link);
}
mysqli_close($link);
輸出：註：「res」變量存儲函數mysql_query()返回的數據。
每次調用mysqli_fetch_array()時，它都會從res()集中返回下一行。
while循環用於遍歷表「data」的所有行。
示例2：使用面向對象方法的Limit子句
< ? php
$mysqli = new mysqli("localhost", "root", "", "Mydb");
if ($mysqli == = false) {
die("ERROR: Could not connect. ".$mysqli->connect_error);
}
$sql = "SELECT * FROM Data LIMIT 2";
if ($res = $mysqli->query($sql)) {
if ($res->num_rows > 0) {
echo "<table>";
echo "<tr>";
echo "<th>Firstname</th>";
echo "<th>Lastname</th>";
echo "<th>Age</th>";
echo "</tr>";
while ($row = $res->fetch_array()) {
echo "<tr>";
echo "<td>".$row['Firstname']."</td>";
echo "<td>".$row['Lastname']."</td>";
echo "<td>".$row['Age']."</td>";
echo "</tr>";
}
echo "</table>";
$res->free();
}
else {
echo "No matching records are found.";
}
}
else {
echo "ERROR: Could not able to execute $sql. ".$mysqli->error;
}
$mysqli->close();
輸出：< ?php
try {
$pdo = new PDO("mysql:host=localhost;dbname=Mydb", "root", "");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("ERROR: Could not connect. ".$e->getMessage());
}
try {
$sql = "SELECT * FROM Data LIMIT 2";
$res = $pdo->query($sql);
if ($res->rowCount() > 0) {
echo "<table>";
echo "<tr>";
echo "<th>Firstname</th>";
echo "<th>Lastname</th>";
echo "<th>Age</th>";
echo "</tr>";
while ($row = $res->fetch()) {
echo "<tr>";
echo "<td>".$row['Firstname']."</td>";
echo "<td>".$row['Lastname']."</td>";
echo "<td>".$row['Age']."</td>";
echo "</tr>";
}
echo "</table>";
unset($res);
}
else {
echo "No matching records are found.";
}
}
catch (PDOException $e) {
die("ERROR: Could not able to execute $sql. ".$e->getMessage());
}
unset($pdo);
輸出：本篇文章就是關於mysql中limit用法詳解，希望對需要的朋友有所幫助！-END-
聲明：本文選自「 php中文網 」，搜索「 phpcnnew 」即可關注！
▼請點擊下方：「閱讀原文」，在線查看全部文章內容！