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

28 votes323 views4 answers
Mysql delete database
SQL
0 vote345 views1 answer
Postgres reorder columns
SQL
14 votes357 views3 answers
Alter foreign key
SQL
0 vote364 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote341 views1 answer
Mariadb number format
SQL
44 votes446 views4 answers
Mysql alter table add column first
SQL
2 votes324 views1 answer
Install sqlite npm
SQL
0 vote327 views1 answer
Parsing float to int in mysql
SQL
2 votes363 views1 answer
Can you use a where clause for a child query
SQL
0 vote348 views1 answer
Less than and between in sql query
SQL