Query Results
setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
$query = "SELECT * FROM people";
// We're going to construct an HTML table.
print "
\n";
// Fetch the database field names.
$result = $con->query($query);
$row = $result->fetch(PDO::FETCH_ASSOC);
// Construct the header row of the HTML table.
print " \n";
foreach ($row as $field => $value) {
print " $field | \n";
}
print "
\n";
$query = "SELECT * FROM people ".
"WHERE id = $id";
// Fetch the matching database table rows.
$data = $con->query($query);
$data->setFetchMode(PDO::FETCH_ASSOC);
// Construct the HTML table row by row.
foreach ($data as $row) {
print " \n";
foreach ($row as $name => $value) {
print " $value | \n";
}
print "
\n";
}
print "
\n";
}
catch(PDOException $ex) {
echo 'ERROR: '.$ex->getMessage();
}
?>