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 vote235 views1 answer
Sql server bool select
SQL
18 votes231 views3 answers
Mysql query add column with default string value
SQL
0 vote238 views1 answer
Sum values by month mariadb
SQL
0 vote246 views1 answer
Mysql remove last character
SQL
0 vote230 views1 answer
Import sql inside hide sql
SQL
0 vote237 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote232 views1 answer
Postgres enumerated type
SQL
0 vote248 views1 answer
Normalization in database
SQL
-2 votes250 views1 answer
Trunc in sql
SQL
1 vote240 views2 answers
Mysql show views
SQL