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 vote122 views1 answer
Add computed column to table sql server
SQL
0 vote112 views1 answer
Java check if something is in mysql table
SQL
1 vote124 views1 answer
Postgresql transaction discard all
SQL
3 votes127 views1 answer
Postgres kill running query
SQL
0 vote126 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote112 views1 answer
Mysql xampp reset root password
SQL
0 vote127 views1 answer
Compare subqueries oracle
SQL
0 vote138 views1 answer
Oracle running queries
SQL
0 vote109 views1 answer
Mod function example
SQL
0 vote107 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL