Sql fetch next 10 rows pdo

// You could have your values in variables (or hardcoded)
$offset = 0;
$limit = 5;

$statement = $pdo->prepare('SELECT * FROM livro ORDER BY id OFFSET :offset ROWS FETCH NEXT :limit ROWS ONLY');

// Next you need to bind the values
$statement->bindValue(':offset', (int) $offset, PDO::PARAM_INT); 
$statement->bindValue(':limit', (int) $limit, PDO::PARAM_INT); 

// Now execute your statement
$statement->execute();

Source: stackoverflow.com

Similar codes

10 votes82 views2 answers
Mysql select timestamp group by day
SQL
3 votes143 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote110 views1 answer
Restart sql server command line linux
SQL
21 votes124 views4 answers
Add column mssql
SQL
1 vote103 views1 answer
Can not connect to mysql server
SQL
-1 vote125 views3 answers
MySQL shutdown unexpectedly
SQL
2 votes123 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote121 views1 answer
Oracle turn off constraint
SQL
15 votes195 views3 answers
Postgresql change column type
SQL
0 vote106 views1 answer
Dump only schema
SQL