在PDO结果中重置数组指针

将结果保存到数组，然后将该数组循环两次。

$pdo = new PDO('mysql:host=' . $host . ';dbname='.$database, $username, $password);$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);$stmt = $pdo->prepare('SELECt * FROM mytable WHERe active = 1 ORDER BY name ASC');$stmt->setFetchMode(PDO::FETCH_ASSOC);$stmt->execute();$rows = $stmt->fetchAll();foreach ($rows as $r) {    // first run}foreach ($rows as $r) {    // seconds run}