/** * Displays complete result set as HTML table for debug purposes. * @return void */ public static function dumpResult(Statement $statement) { echo "\n<table class=\"dump\">\n<caption>" . htmlSpecialChars($statement->queryString) . "</caption>\n"; if (!$statement->columnCount()) { echo "\t<tr>\n\t\t<th>Affected rows:</th>\n\t\t<td>", $statement->rowCount(), "</td>\n\t</tr>\n</table>\n"; return; } $i = 0; foreach ($statement as $row) { if ($i === 0) { echo "<thead>\n\t<tr>\n\t\t<th>#row</th>\n"; foreach ($row as $col => $foo) { echo "\t\t<th>" . htmlSpecialChars($col) . "</th>\n"; } echo "\t</tr>\n</thead>\n<tbody>\n"; } echo "\t<tr>\n\t\t<th>", $i, "</th>\n"; foreach ($row as $col) { //if (is_object($col)) $col = $col->__toString(); echo "\t\t<td>", htmlSpecialChars($col), "</td>\n"; } echo "\t</tr>\n"; $i++; } if ($i === 0) { echo "\t<tr>\n\t\t<td><em>empty result set</em></td>\n\t</tr>\n</table>\n"; } else { echo "</tbody>\n</table>\n"; } }
public function __construct(Statement $statement) { $this->statement = $statement; $this->timeCreated = $statement->timeCreated(); $this->canSeek = $statement->canSeek(); $this->numOfRows = $statement->rowCount(); $this->numOfFields = $statement->columnCount(); $this->currentRow = -1; $this->moveNext(); }