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

1 vote302 views1 answer
Psql datetime grather than
SQL
1 vote324 views2 answers
Oracle list service names
SQL
0 vote292 views1 answer
Mysql begin statement
SQL
0 vote287 views1 answer
How to count with except in psql
SQL
0 vote331 views1 answer
Hour and minute between two datatime sql
SQL
0 vote334 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote298 views1 answer
Except in sql alchemy
SQL
1 vote330 views2 answers
Foreign key set 0
SQL
3 votes299 views3 answers
How to set up an auto incrementing id db browser
SQL
3 votes314 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL