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

1 vote183 views1 answer
Pl sql ptint
SQL
0 vote224 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
6 votes194 views2 answers
Foreign key sqlite3 python
SQL
0 vote177 views1 answer
Sql server list user permissions
SQL
0 vote183 views2 answers
Sql query inner join 3 tables
SQL
1 vote176 views1 answer
SQLite order random
SQL
4 votes182 views1 answer
Wilayah indonesia sql
SQL
0 vote182 views1 answer
Sql change default collation to utf8
SQL
0 vote309 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote204 views1 answer
Consecutive numbers sql
SQL