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 votes174 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote175 views1 answer
Find invalid datetime field
SQL
0 vote161 views1 answer
Oracle list index on table
SQL
0 vote198 views1 answer
Order child below the parent in mysqli
SQL
4 votes167 views1 answer
Force drop all tables postgres
SQL
6 votes161 views4 answers
Delete table sqlite
SQL
0 vote213 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote158 views1 answer
Metada in sql
SQL
0 vote173 views1 answer
How to select only a certain date sql
SQL
2 votes161 views1 answer
Sql server find table name
SQL