setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Failed to connect to the database using DSN: $dsn ";
throw $e;
}
?>
prepare($sql);
$params = [$jettyPosition];
$stmt->execute($params);
// Get the results as an array with column names as array keys
$res = $stmt->fetchAll(PDO::FETCH_BOTH);
if (empty($res)) {
die("No such jettyPosition.");
}
// Move content of array to individual variables, for ease of use.
list($jettyPosition, $boatType, $boatEngine, $boatLength, $boatWidth, $ownerName) = $res[0];
}
?>
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) {
$jettyPosition = htmlentities($row['jettyPosition']);
$rows .= "