File: /home/nmel17aacb/domains/argentaclassic.be/public_html/php/rabc/pers.php
<div id="pers" class="overlay-col col-12">
<div class="container">
<!-- load from database -->
<h1>Pers</h1>
<link rel="stylesheet" href="lib/fancybox-3.5.7/jquery.fancybox.min.css" />
<script src="lib/fancybox-3.5.7/jquery.fancybox.min.js"></script>
<?php
include ("../inc/db.php");
$get_pers = mysqli_query($db, "SELECT * FROM pers WHERE actief = TRUE ORDER BY datum DESC LIMIT 100");
if (mysqli_num_rows($get_pers) > 0) {
while ($pers_item = mysqli_fetch_assoc($get_pers)) {
echo ' <div class="jumbotron">';
echo '<div class="container">';
echo '<div class="row">';
echo '<div class="col-md-12">';
echo '<h2>' . $pers_item['titel'] . '</h2>';
echo '</div>';
echo '</div>';
echo '<div class="row">';
echo '<div class="col-md-6">';
echo '<div class="nieuws-img">';
echo '<a class="d-block mb-4" data-fancybox="images" href="files/pers/' . $pers_item['image'] . '">';
echo '<img src="files/pers/' . $pers_item['image'] . '">';
echo '</a>';
echo '</div>';
echo '</div>';
echo ' <div class="col-md-6">';
echo ' <p class="lead">' . date_format(date_create($pers_item['datum']), 'd/m/Y') . ' - ' . $pers_item['bron'] . '</p>';
echo ' <hr class="my-4">';
echo '<p>' . $pers_item['tekst'] . '</p>';
if ($pers_item['link'] <> '' ) echo '<a class="btn btn-primary" href="'. $pers_item['link'] . '" role="button">'. $pers_item['link'] . '<img src="resources/open-iconic/svg/ellipses.svg"></a>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
}
}
?>
</div>
</div>