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 vote326 views1 answer
Postgress append string in select
SQL
0 vote319 views1 answer
Gcloud check sql
SQL
0 vote386 views1 answer
Mysql concatenate select results
SQL
13 votes353 views5 answers
Alter table query sql server change column
SQL
1 vote333 views1 answer
Psql client write to bash variable
SQL
0 vote317 views1 answer
Check for directory in bash
SQL
1 vote339 views1 answer
Sql not equal multiple columns
SQL
1 vote329 views1 answer
How to check the mysql version mac
SQL
0 vote335 views1 answer
Mysql terminal run sql file
SQL
0 vote337 views1 answer
Query params sql insert python f string
SQL