PDOStatement::getIterator
(PHP 8)
PDOStatement::getIterator — Gets result set iterator
参数
此函数没有参数。
返回值
＋添加备注
用户贡献的备注 1 note
berxudar at gmail dot com ¶
1 year ago
This method converts a PDOStatement object into an Iterator object, making it convenient for iterating over the result set of the PDOStatement. The returned Iterator represents each row of the result set.
Return Value:
Returns an Iterator representing the PDOStatement object.
<?php
// Establish a database connection
$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');
// Prepare and execute an SQL query
$stmt = $pdo->query('SELECT * FROM mytable');
// Convert PDOStatement to an Iterator
$iterator = $stmt->getIterator();
// Process the result set using a loop
foreach ($iterator as $row) {
// $row represents a row of the result set
print_r($row);
}
// Close the PDOStatement and the connection
$stmt = null;
$pdo = null;
?>备份地址：http://www.lvesu.com/blog/php/pdostatement.getiterator.php