Untitled

<?php


include "../src/functions.php";


$db = connectToDatabase($dsn);


$stmt = $db->prepare("SELECT * FROM jetty");
$stmt->execute();


$res = $stmt->fetchAll(PDO::FETCH_ASSOC);

$rows = "";

foreach ($res as $row) {
    $rows .="<tr><td>{$row["position"]}</td>";
    $rows .="<td>{$row["boatType"]}</td>";
    $rows .="<td>{$row["boatEngine"]}</td>";
    $rows .="<td>{$row["boatLength"]}</td>";
    $rows .="<td>{$row["boatWidth"]}</td>";
    $rows .="<td>{$row["ownerName"]}</td></tr>";
}

switch ($_GET['page']) {
    case 'intro':
        $page = $_GET['page'] . '.php';
        break;
    case 'connect':
        $page = $_GET['page'] . '.php';
        break;
    case 'view':
        $page = $_GET['page'] . '.php';
        break;
    case 'search':
        $page = $_GET['page'] . '.php';
        break;
};

 ?>


<!DOCTYPE html>
<html lang="sv">
    <head>
        <meta charset="utf-8">
        <link rel="stylesheet" href="style.css">
        <title></title>
    </head>
    <body>


        <div class="content">
            <div class="sub_page" style="margin-bottom: 30px;">
                <a href="?page=intro">intro</a>
                <a href="?page=connect">connect</a>
                <a href="?page=view">view</a>
                <a href="?page=search">search</a>
            </div>

            <?php if ($page): ?>
                <?php include $page; ?>
            <?php endif; ?>


        </div>

    </body>
</html>