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 vote163 views1 answer
Add sqlcmd to path linux
SQL
5 votes141 views2 answers
Mysqldump password
SQL
3 votes156 views1 answer
Insert into table from another table mysql
SQL
8 votes140 views3 answers
Postgresql connection string c#
SQL
0 vote178 views1 answer
Calculer pourcentage mysql
SQL
1 vote173 views1 answer
Oracle columns table
SQL
1 vote152 views1 answer
Calculate age in sql postgresql
SQL
0 vote204 views1 answer
Postgres list all stored procedures query
SQL
1 vote235 views1 answer
Alter constraint postgres
SQL
0 vote144 views1 answer
Pl/sql loop example
SQL