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 vote236 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote138 views1 answer
Start and stop mysql
SQL
0 vote105 views1 answer
Raven ql select count
SQL
1 vote191 views1 answer
Sqlite show columns in table
SQL
1 vote143 views1 answer
Sql current timestamp
SQL
10 votes142 views3 answers
Insert into auto increment mysql
SQL
0 vote126 views1 answer
Query on date sqlite flutter
SQL
16 votes133 views1 answer
Sqlserver add column to table
SQL
21 votes178 views6 answers
Update sql
SQL
0 vote149 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL