<?php
$search = isset($_GET['search']) ? $_GET['search'] : null;
$dsn = JETTYDB;
$db = null;

try {
    $db = connect_database($dsn);
} catch (PDOException $e) {
    echo "<p style='color:red'>ERR: Failed to connect to database: $dsn</p>";
    echo $e;
}

$searchRes = null;
$searchResCount = 0;
$searchQuery = null;
if (is_null($search)) {
    $searchRes = "<p>Nothing to display, please enter a searchstring.</p>";
} else {
    $sql = "SELECT * FROM Jetty WHERE boatType LIKE ? OR boatEngine LIKE ?";
    $stmt = $db->prepare($sql);
    $params = [$search, $search];
    $stmt->execute($params);
    $searchQuery = htmlentities("SELECT * FROM Jetty WHERE boatType LIKE {$params[0]} OR boatEngine LIKE {$params[1]}");

    $res = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $searchResCount = count($res);
}
?>
<form>
    <input type="hidden" name="page" value="jetty">
    <input type="hidden" name="subpage" value="search">
    <input type="search" name="search" placeholder="Enter substring to search for, use % as wildcard.">
    <input type="submit" value="Search">
</form>
<div>
    <p>Executed query: <?= $searchQuery ?></p>
    <p>Result count: <?= $searchResCount ?></p>
    <?= isset($res) ? printJettyResultsetToHTMLTable($res) : "Inget att visa."; ?>
</div>
