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 vote336 views1 answer
Fetching data from mysqldb
SQL
0 vote330 views1 answer
PostgreSQL types and C# types
SQL
2 votes304 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote295 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote294 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
4 votes335 views3 answers
Sql find second highest salary employee
SQL
0 vote288 views1 answer
Joins vs includes
SQL
6 votes332 views2 answers
Foreign key sqlite3 python
SQL
2 votes343 views1 answer
Sql find not in list
SQL
1 vote306 views1 answer
Psql search table
SQL