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 vote230 views1 answer
Duplicate foreign key constraint name
SQL
5 votes268 views2 answers
Sql server port number
SQL
29 votes248 views6 answers
Delete all rows from table mysql
SQL
0 vote270 views1 answer
Postgres sequence name
SQL
0 vote245 views1 answer
Oracle flush Shared Pool
SQL
9 votes277 views3 answers
Find all tables with column name
SQL
0 vote270 views2 answers
How to get the date from datetime in mysql
SQL
0 vote217 views1 answer
Oracle list all stored procedures
SQL
0 vote279 views1 answer
Mysql dump with table query
SQL
0 vote268 views1 answer
Oracle running queries
SQL