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 vote361 views3 answers
Insert or ignore postgres
SQL
2 votes377 views1 answer
Sql server current date minus 5 years
SQL
0 vote414 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote362 views1 answer
Power bi union columns
SQL
0 vote390 views2 answers
Postgres default user
SQL
1 vote362 views1 answer
Oracle duration between timestamps
SQL
-2 votes357 views1 answer
Use of where in left join in mysql
SQL
7 votes372 views2 answers
Create index mysql cli
SQL
1 vote384 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote352 views1 answer
Comma seperated join mssql
SQL