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

1 vote144 views1 answer
Update mysql centos
SQL
0 vote142 views1 answer
Create function syntax sql server
SQL
0 vote143 views2 answers
Start mysql server using docker
SQL
0 vote158 views1 answer
Sql server list table sizes
SQL
0 vote300 views1 answer
Multiple row join
SQL
15 votes153 views2 answers
How to drop database name in postgresql
SQL
6 votes157 views2 answers
Drop foreign key
SQL
3 votes151 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote215 views1 answer
Oracle db get table sizes
SQL
0 vote144 views1 answer
Sql trim whitespace
SQL