setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Failed to connect to the database using DSN:
$dsn
";
throw $e;
}
// Prepare and execute the SQL statement
$sql = "SELECT * FROM Jetty";
$stmt = $db->prepare($sql);
echo "Execute the SQL-statement:
$sql
";
$stmt->execute();
// Get the results as an array with column names as array keys
$res = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo "
The result contains " . count($res) . " rows.
";
// Loop through the array and gather the data into table rows
$rows = null;
foreach ($res as $row) {
$rows .= "";
$rows .= "| {$row['jettyPosition']} | ";
$rows .= "{$row['boatType']} | ";
$rows .= "{$row['boatEngine']} | ";
$rows .= "{$row['boatLength']} | ";
$rows .= "{$row['boatWidth']} | ";
$rows .= "{$row['ownerName']} | ";
$rows .= "
\n";
}
// Print out the result as a HTML table using PHP heredoc
echo <<
| jettyPostion |
boatType |
boatEngine |
boatLength |
boatWidth |
ownerName |
$rows
EOD;