<div id="Kalender" class="overlay-col col-12">
  <div class="container">
    <!-- load from database -->
    <h1>Kalender</h1>
<?php
    include ("../inc/db.php");
    $get_agenda = mysqli_query($db, "SELECT * FROM agenda WHERE actief = TRUE && datum > CURDATE()  ORDER BY datum DESC");
    if (mysqli_num_rows($get_agenda) > 0) {
        while ($agenda = mysqli_fetch_assoc($get_agenda)) {
echo '  <div class="jumbotron">';
echo '<div class="container">';
echo '<div class="row">';
echo '<div class="col-md-4">';
echo '<h2>' .  date_format(date_create($agenda['datum']), 'd/m/Y') . '</h2>';
if ($agenda['start_tijd'] <> '') echo '<h4>Start: ' .  $agenda['start_tijd']  . '</h4>';
if ($agenda['stop_tijd'] <> '') echo '<h4>Einde: ' .  $agenda['stop_tijd']  . '</h4>';
if ($agenda['afstand'] <> '') echo '<h4>Afstand: ' .  $agenda['afstand']  . '</h4>';

echo '</div>';
echo '       <div class="col-md-8">';
echo '<h2>' .  $agenda['titel'] . '</h2>';

echo '<h4>' .  $agenda['locatie'] . '</h4>';
echo '  <hr class="my-4">';
echo '<p>' .  $agenda['info'] . '</p>';

if ($agenda['link'] <> '' ) echo '<a class="btn btn-primary" href="'. $agenda['link'] . '" role="button">'. $agenda['link'] . '<img src="resources/open-iconic/svg/ellipses.svg"></a>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';


    }
    }
?>
  </div>
</div>


<div id="Kalender" class="overlay-col col-12">
  <div class="container">
    <!-- load from database -->
    <h1>Afgelopen events</h1>
<?php
    include ("../inc/db.php");
    $get_agenda = mysqli_query($db, "SELECT * FROM agenda WHERE actief = TRUE && datum < CURDATE()  ORDER BY datum DESC LIMIT 10");
    if (mysqli_num_rows($get_agenda) > 0) {
        while ($agenda = mysqli_fetch_assoc($get_agenda)) {
echo '  <div class="jumbotron">';
echo '<div class="container">';
echo '<div class="row">';
echo '<div class="col-md-4">';
echo '<h2>' .  date_format(date_create($agenda['datum']), 'd/m/Y') . '</h2>';
if ($agenda['start_tijd'] <> '') echo '<h4>Start: ' .  $agenda['start_tijd']  . '</h4>';
if ($agenda['stop_tijd'] <> '') echo '<h4>Einde: ' .  $agenda['stop_tijd']  . '</h4>';
if ($agenda['afstand'] <> '') echo '<h4>Afstand: ' .  $agenda['afstand']  . '</h4>';

echo '</div>';
echo '       <div class="col-md-8">';
echo '<h2>' .  $agenda['titel'] . '</h2>';

echo '<h4>' .  $agenda['locatie'] . '</h4>';
echo '  <hr class="my-4">';
echo '<p>' .  $agenda['info'] . '</p>';

if ($agenda['link'] <> '' ) echo '<a class="btn btn-primary" href="'. $agenda['link'] . '" role="button">'. $agenda['link'] . '<img src="resources/open-iconic/svg/ellipses.svg"></a>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';


    }
    }
?>
  </div>
</div>