prepare("SELECT * FROM Jetty");
$stmt->execute();
$res = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($res as $row) {
$rows .= "| {$row['jettyPosition']} | {$row['boatType']} | {$row['boatEngine']} | {$row['boatLength']} | {$row['boatWidth']} | {$row['ownerName']} |
";
}
echo "| jettyPostion | boatType | boatEngine | boatLength | boatWidth | ownerName |
|---|
$rows
";
} catch (PDOException $e) {
echo "ERR: Failed to connect to database: $dsn
";
echo $e;
}
} else {
echo "ERR: PDO driver sqlite is NOT enabled
";
}