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 vote134 views2 answers
Create new table plsql
SQL
16 votes135 views6 answers
Install sqlite3 python
SQL
12 votes190 views2 answers
Update column data type postgres
SQL
3 votes136 views1 answer
Sql double index
SQL
0 vote130 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote129 views1 answer
Change permission to database mysql
SQL
0 vote139 views1 answer
Procedures sql insert mysql
SQL
0 vote137 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote118 views3 answers
Sql count condition
SQL
12 votes132 views2 answers
Insert multiple rows from another table sql
SQL