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

0 vote161 views1 answer
Postgresql subquery
SQL
1 vote180 views1 answer
Ilike for date postgres
SQL
2 votes195 views2 answers
Spring where to put the data sql
SQL
0 vote194 views1 answer
Tsql delete all rows
SQL
3 votes165 views1 answer
Select nextval from sequence sql
SQL
0 vote171 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
9 votes177 views3 answers
Show table columns mysql command line
SQL
0 vote187 views1 answer
Postgresql not in alternative
SQL
2 votes184 views1 answer
How to get non distinct values in sql
SQL
2 votes174 views1 answer
Oracle log files
SQL