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 vote210 views2 answers
Sql select inside select
SQL
0 vote224 views1 answer
Import sql inside hide sql
SQL
12 votes231 views1 answer
Docker run mysql image
SQL
15 votes239 views5 answers
If null mysql
SQL
0 vote238 views1 answer
Sql server change schema of a table
SQL
0 vote239 views1 answer
Postgres set default schema
SQL
0 vote264 views1 answer
Postgresql alter table sequence
SQL
2 votes221 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote225 views1 answer
What is SQL data store?
SQL
0 vote237 views2 answers
What is the default password for sql server sa
SQL