php - What is PDO scrollable cursor?

Question

What is "Fetching rows with a scrollable cursor" all about?

Answer 1

It creates a cursor for the query, which allows you to iterate over the result set without fetching the whole result at once. A scrollable cursor, specifically, is one that allows iterating backwards.

Example use: You can scroll forward until you find the record you need and iterate back to fetch the previous records, if you need them, too.