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 vote278 views1 answer
Copy row from db to db mysql
SQL
0 vote276 views1 answer
Mysql range of dates overlap
SQL
9 votes251 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
7 votes266 views1 answer
Sql server convert string to date
SQL
0 vote264 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote273 views1 answer
Sql delete from with relation
SQL
1 vote273 views1 answer
Sql server list locks
SQL
7 votes271 views2 answers
Oracle sql drop index
SQL
0 vote313 views3 answers
Postgres trim string
SQL
0 vote264 views1 answer
Oracle list subpartitions
SQL