Untitled

<?php
/**
 * User: Ilias Harkati
 * Date: 11/2/2019
 * Time: 13:30 PM
 * File: template.php
 * Template voor alle opdrachten
 */
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <link type="text/css" rel="stylesheet" href="../../css/style.css">
    <meta charset="utf-8" />
    <title>Opdrachten PHP periode 3</title>
</head>
<body>
<header><h1>ICT academie AO</h1></header>
<div id="wrapper">
    <h2>Opdracht 7.2</h2>
    <?php

    // Query schrijven
    $query = "SELECT * FROM dbo.joke WHERE jokedate < GETDATE()";

    try
    {
        $pdo = new PDO("odbc:odbc2sqlserver");
    }
    catch(PDOException $e)
    {
        echo "<h1>Fout</h1>";
        echo "<p>" . $error->getMessage() . "</p>";
    }


    // Query gaan uitvoeren
    echo $query;
    try{
        $result = $pdo->query($query);
    }
    catch(Exception $error)
    {
        echo "<p>Error: " . $error->getMessage() . "</p>";
    }

    ?>
    <table>
        <tr>
            <th>ID</th>
            <th>Joketext</th>
            <th>Jokeclou</th>
            <th>Date</th>
        </tr>
        <?php

        while($row = $result->fetch(PDO::FETCH_ASSOC)) {
            echo "<tr><td>" . $row["id"] . "</td><td>" . $row["joketext"] . "</td><td>" . $row["jokeclou"] . "</td><td>" . $row["jokedate"] . "</td></tr>";
        }
        ?>
    </table>
</div>
</body>
</html>