程式設計@筆記

例1 把結果集輸出綁定到 PHP 變量

<?php
function readData($dbh) {
$sql = 'SELECT name, colour, calories FROM fruit';
try {
$stmt = $dbh->prepare($sql);
$stmt->execute();

/* 通過列號綁定 */
$stmt->bindColumn(1, $name);
$stmt->bindColumn(2, $colour);

/* 通過列名綁定 */
$stmt->bindColumn('calories', $cals);

while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
$data = $name . "\t" . $colour . "\t" . $cals . "\n";
print $data;
}
}
catch (PDOException $e) {
print $e->getMessage();
}
}
readData($dbh);
?>
以上例程會輸出：

apple red 150
banana yellow 175
kiwi green 75
orange orange 150
mango red 200
strawberry red 25