使用PDO的Traversable接口遍历时，能否指定不同的fetch_style？

Great question! Let's break down how this works clearly:

First, you're totally right that PDOStatement implements the Traversable interface, so you can loop directly over the statement object with foreach—no need for upfront fetch() or fetchAll() calls. The key detail here is that this iteration uses the current fetch mode configured on the statement object (or your global PDO default, if you haven't adjusted it for that specific statement).

How to specify a different fetch style for foreach iteration #

You don't have to rely on explicit fetch() calls. Instead, just set your desired fetch mode on the statement before starting the foreach loop using setFetchMode():

// Your existing setup with default FETCH_OBJ
$stmt = $pdo->query('SELECT * FROM example');

// Override the fetch mode for this specific statement
$stmt->setFetchMode(PDO::FETCH_ASSOC);

// Now foreach will return associative arrays instead of objects
foreach ($stmt as $row) {
    // $row is an associative array here
}

This works because the Traversable iteration under the hood uses the statement's active fetch mode. Changing it with setFetchMode() updates that default for all subsequent operations on that statement (including the foreach loop).

Why you can't specify the mode directly in foreach #

The foreach construct itself doesn't accept parameters to override the fetch mode—its behavior is entirely tied to how the Traversable object (in this case, PDOStatement) is configured. So you have to adjust the statement's fetch mode first, rather than passing it into the loop itself.

Bonus: Temporary vs global mode changes #

Setting the fetch mode via $stmt->setFetchMode() only affects that specific statement object. It won't alter your global PDO default (the one you set when initializing the PDO instance with PDO::ATTR_DEFAULT_FETCH_MODE), so other statements will still use your original default unless you modify them too.

内容的提问来源于stack exchange，提问作者user1032531