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 vote206 views1 answer
Providername system.data. mysql
SQL
0 vote207 views1 answer
Sql server user permissions and roles
SQL
0 vote201 views1 answer
Sauvegarde complète my sql
SQL
-1 vote208 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote253 views1 answer
Table user postgres
SQL
1 vote223 views1 answer
Postgresql round double precision
SQL
2 votes246 views1 answer
Datetrunc
SQL
1 vote150 views1 answer
Postgres division by zero
SQL
5 votes215 views3 answers
Postgres show databases
SQL
1 vote2.7K views1 answer
Dropping a constraint in ms sql
SQL