php-pdoLIMIT OFFSET query example with PHP PDO
$st = $pdo->prepare('SELECT * FROM test LIMIT :off, :lim');
$st->bindValue(':off', 2, PDO::PARAM_INT);
$st->bindValue(':lim', 2, PDO::PARAM_INT);
$st->execute();
foreach ( $st as $row ) {
print_r($row);
}ctrl + c$pdo->prepareprepare given query to execute | $st->execute(run query on the server |
LIMIT :off, :limuse placeholders for LIMIT with offset | bindValuebind value with specified type |
PDO::PARAM_INTbind specified limit and offset values with | foreach ( $st as $row )go through each row in result set |
print_r($row)print each row | |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$st = $pdo->prepare('SELECT * FROM test LIMIT :off, :lim');
$st->bindValue(':off', 2, PDO::PARAM_INT);
$st->bindValue(':lim', 2, PDO::PARAM_INT);
$st->execute();
foreach ( $st as $row ) {
print_r($row);
}output
Array
(
[id] => 3
[0] => 3
[age] => 52
[1] => 52
[name] => C
[2] => C
[data] =>
[3] =>
)
Array
(
[id] => 4
[0] => 4
[age] => 90
[1] => 90
[name] => Donald
[2] => Donald
[data] =>
[3] =>
)
More of Php Pdo
- Set charset in PHP PDO
- Fetch single column value with PHP PDO
- Commit transaction in PHP PDO
- How to get results after PHP PDO statement execute()
- Set execution timeout with PHP PDO
- Get last query error with PHP PDO
- Bind current datetime with PHP PDO
- Escape string with PHP PDO
- Get current database name with PHP PDO
- Insert JSON into table with PHP PDO
See more codes...