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

7 votes166 views3 answers
How to check table name in current database sql
SQL
1 vote178 views1 answer
Wherein mysql
SQL
1 vote173 views1 answer
Sql server list locks
SQL
4 votes175 views5 answers
Primary key
SQL
3 votes173 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
12 votes169 views4 answers
Mysql version
SQL
1 vote160 views1 answer
Oracle convert run duration to number
SQL
0 vote172 views1 answer
List MySQL Table and Index Size
SQL
0 vote186 views1 answer
Running mysql from bash sc
SQL
0 vote154 views1 answer
Hive batch drop table
SQL