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 vote382 views1 answer
Oracle convert int to date
SQL
1 vote308 views3 answers
Psql fatal database does not exist
SQL
0 vote308 views1 answer
Oracle character index
SQL
0 vote331 views1 answer
Laravel migration sql dump
SQL
0 vote335 views1 answer
Shortcut run sql pgadmin
SQL
1 vote334 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
1 vote265 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote301 views1 answer
Get created time of database psql 8
SQL
4 votes310 views1 answer
Oracle select first 10 rows
SQL
-1 vote328 views1 answer
Sql show custom constraints
SQL