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 vote369 views1 answer
Product of a column in mysql
SQL
0 vote357 views1 answer
Linebreak sql
SQL
1 vote363 views1 answer
Size of all tables in a schema oracle
SQL
1 vote355 views1 answer
Import database from a file using mysql commandline
SQL
3 votes345 views1 answer
Postgres update column with value from another table
SQL
0 vote347 views1 answer
Mysql grant access to one database
SQL
51 votes458 views6 answers
Change column name sql
SQL
42 votes429 views6 answers
Sql query duplicate rows
SQL
13 votes370 views1 answer
Sql join 3 tables on id
SQL
0 vote373 views1 answer
Excel export from sql using python
SQL