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 vote242 views1 answer
Postgresql append array
SQL
0 vote200 views1 answer
Where date major today mysql
SQL
7 votes231 views3 answers
Sql server check if temp table exists
SQL
0 vote207 views3 answers
Duplicate row mysql
SQL
22 votes193 views4 answers
Mysql reset auto increment id
SQL
0 vote251 views1 answer
Mysqlimport
SQL
13 votes193 views5 answers
Oracle list tables
SQL
0 vote199 views1 answer
Mysql date only no time
SQL
32 votes195 views6 answers
Insert select
SQL
0 vote181 views1 answer
Mysql percentage of total
SQL