Nothing to display, please enter a searchstring.");
}
// Create a DSN for the database using its filename
$fileName = __DIR__ . "/db/jetty.sqlite";
$dsn = "sqlite:$fileName";
// Open the database file and catch the exception it it fails.
try {
$db = new PDO($dsn);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Failed to connect to the database using DSN:
$dsn
";
throw $e;
}
// Prepare the SQL statement
$sql = "SELECT * FROM Jetty WHERE boatType LIKE ? OR boatEngine LIKE ?";
$stmt = $db->prepare($sql);
echo "Preparing the SQL-statement:
$sql
";
// Execute the SQL statement using parameters to replace the ?
$params = [$search, $search];
$stmt->execute($params);
echo "
Executing using parameters:
" . htmlentities(print_r($params, true)) . "
";
// 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
Clear search results.
EOD;