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

16 votes153 views1 answer
Mysql mediumint max value
SQL
2 votes224 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote167 views1 answer
Datatables server side filter where clause
SQL
2 votes142 views1 answer
Oracle sql drop table purge
SQL
2 votes209 views1 answer
Merge two columns in sql oracle
SQL
2 votes173 views1 answer
Mysql select true or false
SQL
0 vote147 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
3 votes146 views1 answer
How to remove characters from string in mysql
SQL
0 vote9.3K views1 answer
Postgresql delete type
SQL
1 vote154 views1 answer
Create procedure with encryption
SQL