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 vote277 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes276 views2 answers
Mysql get time from datetime
SQL
8 votes325 views1 answer
Mysql limit rows
SQL
0 vote270 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote291 views1 answer
Sql how to duplicate a table
SQL
13 votes301 views1 answer
Views in sql
SQL
10 votes300 views2 answers
Oracle alter sequence nextval
SQL
2 votes287 views1 answer
Change primary key sql
SQL
1 vote281 views1 answer
How to open closed port mysql in ubuntu
SQL
5 votes330 views1 answer
Mysql where one year ago
SQL