<!DOCTYPE html>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Simple Id Query #1</title>
</head>
<body>
<?php
function constructTable($data)
{
// We're going to construct an HTML table.
print " <table border='1'>\n";
// Construct the HTML table row by row.
$doHeader = true;
foreach ($data as $row) {
// The header row before the first data row.
if ($doHeader) {
print " <tr>\n";
foreach ($row as $name => $value) {
print " <th>$name</th>\n";
}
print " </tr>\n";
$doHeader = false;
}
// Data row.
print " <tr>\n";
foreach ($row as $name => $value) {
print " <td>$value</td>\n";
}
print " </tr>\n";
}
print " </table>\n";
}
$id = filter_input(INPUT_GET, "id");
try {
if (empty($id)) {
throw new Exception("Missing id.");
}
print "<h1>Teacher with id $id</h1>\n";
// Connect to the database.
$con = new PDO("mysql:host=localhost;dbname=school",
"root", "sesame");
$con->setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);
$query = "SELECT * FROM teacher WHERE id = $id";
// Fetch the matching row.
$data = $con->query($query);
$data->setFetchMode(PDO::FETCH_ASSOC);
// $data is a result set.
if ($data->rowCount() > 0) {
constructTable($data);
}
else {
print "<h3>(No match.)</h3>\n";
}
}
catch(PDOException $ex) {
echo 'ERROR: '.$ex->getMessage();
}
catch(Exception $ex) {
echo 'ERROR: '.$ex->getMessage();
}
?>
</body>
</html>