编辑“︁PHP结果集处理”︁（章节）

== 基本操作 ==

=== 获取结果集 ===
使用MySQLi或PDO执行查询后，会返回一个结果集对象。以下是两种扩展的示例：

==== MySQLi 示例 ====
<syntaxhighlight lang="php">
<?php
$conn = new mysqli("localhost", "username", "password", "database");
$result = $conn->query("SELECT id, name FROM users");
// $result 是结果集对象
?>
</syntaxhighlight>

==== PDO 示例 ====
<syntaxhighlight lang="php">
<?php
$conn = new PDO("mysql:host=localhost;dbname=database", "username", "password");
$stmt = $conn->query("SELECT id, name FROM users");
// $stmt 是PDOStatement对象，包含结果集
?>
</syntaxhighlight>

=== 遍历结果集 ===

==== MySQLi 遍历 ====
<syntaxhighlight lang="php">
while ($row = $result->fetch_assoc()) {
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . "\n";
}
</syntaxhighlight>

==== PDO 遍历 ====
<syntaxhighlight lang="php">
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . "\n";
}
</syntaxhighlight>

=== 结果集方法对比 ===
{| class="wikitable"
|-
! 操作 !! MySQLi !! PDO
|-
| 获取关联数组 || <code>fetch_assoc()</code> || <code>fetch(PDO::FETCH_ASSOC)</code>
|-
| 获取行数 || <code>num_rows</code> || <code>rowCount()</code>
|-
| 获取所有结果 || <code>fetch_all()</code> || <code>fetchAll()</code>
|}