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 vote203 views1 answer
Mysql collation portugues brasil
SQL
2 votes139 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote144 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
12 votes153 views1 answer
Env var for setting password for root user mysql docker hub
SQL
1 vote138 views1 answer
Mysql check table exists
SQL
0 vote150 views1 answer
Create a sql server database programmatically
SQL
0 vote145 views2 answers
Python mysql create table if not exists
SQL
1 vote139 views1 answer
Mysql how to reset primary key
SQL
2 votes144 views5 answers
Tablespace ORACLE
SQL
1 vote130 views1 answer
How to ckeck that email is present in databse in mysqli
SQL