<?php
function check_libs()
{
    if (class_exists('PDO') && in_array("sqlite", pdo_drivers())) {
        return true;
    } else {
        return false;
    }
}

function connect_database($dsn)
{
    try {
        $db = new PDO($dsn);
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        return $db;
    } catch (PDOException $e) {
        throw $e;
    }
}

function printJettyResultsetToHTMLTable($res)
{
    $rows = null;
    foreach ($res as $row) {
        $rows .= "<tr><td>{$row['jettyPosition']}</td><td>{$row['boatType']}</td><td>{$row['boatEngine']}</td><td>{$row['boatLength']}</td><td>{$row['boatWidth']}</td><td>{$row['ownerName']}</td></tr>";
    }
    echo "<table><tr><th>jettyPostion</th><th>boatType</th><th>boatEngine</th><th>boatLength</th><th>boatWidth</th><th>ownerName</th></tr>$rows</table>";
}
