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

11 votes226 views2 answers
Import mysql dump command line windows
SQL
-1 vote53 views3 answers
Ubuntu install mssql
SQL
0 vote122 views1 answer
On delete set default
SQL
0 vote102 views1 answer
Groupby error in mysql
SQL
1 vote105 views1 answer
Add current timestamp in mysql
SQL
0 vote195 views1 answer
Sqlite woth cmake
SQL
2 votes106 views2 answers
Sql percentage
SQL
1 vote125 views1 answer
Concat first name and last name in mysql
SQL
3 votes108 views1 answer
Oracle apex call duration
SQL
0 vote110 views1 answer
Oracle select partition
SQL