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 vote236 views1 answer
Python get backup of sql
SQL
2 votes132 views1 answer
SQL column name Postgre
SQL
0 vote121 views1 answer
IIF
SQL
1 vote137 views1 answer
Add multiple row table pl sql
SQL
4 votes148 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote126 views1 answer
MySQL error code 2068
SQL
5 votes141 views4 answers
Traduction
SQL
0 vote129 views1 answer
Sql value exists in column
SQL
1 vote122 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote143 views1 answer
Sqlite version check
SQL