PDO_MySQL does not support cursors

[1107012776]

Description

For example, I have a table with two fields: id and value. I inserted nearly 100k rows into this table.
I want to use the scrollable cursor. I wrote the following code:

$sql = 'SELECT id FROM cursor_ test;';
$stmt = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL));
$stmt ->Execute ();
$row = $stmt->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_ABS, 3);
var_ dump($row['id']); // 1, the expected value is 3

What did I do wrong?

PHP Version

PHP5.6.25

Operating System

window7

[cmb69]

PDO_MySQL does not support scrolling cursors (actually, it doesn't support cursors at all), and to my knowledge, MySQL does not support scrolling cursors, so this will not be implemented for PDO. However, we need to document this.

PHP5.6.25

Ugh. I suggest you upgrade to PHP 8 as soon as possible.

[kamil-tekiela]

I thought PDO_MySQL supports forward-only cursors. Anyway, cursors in MySQL are pretty useless as it doesn't support scrollable cursors. We should probably mention this somewhere, but I don't know where. Maybe here? https://www.php.net/manual/en/ref.pdo-mysql.php