File: /home/nmel17aacb/domains/argentaclassic.be/public_html/php/rabc/nieuws.php
<div id="nieuws" class="overlay-col col-12">
<div class="container">
<!-- load from database -->
<h1>Nieuws</h1>
<?php
include ("../inc/db.php");
$get_news = mysqli_query($db, "SELECT * FROM nieuws WHERE actief = TRUE ORDER BY datum DESC LIMIT 4");
if (mysqli_num_rows($get_news) > 0) {
while ($news_item = mysqli_fetch_assoc($get_news)) {
echo ' <div class="jumbotron">';
echo '<div class="container">';
echo '<div class="row">';
echo '<div class="col-md-6">';
echo '<div class="nieuws-img">';
echo '<img src="files/nieuws/' . $news_item['image'] . '">';
echo '</div>';
echo '</div>';
echo ' <div class="col-md-6">';
echo '<h2>' . $news_item['titel'] . '</h2>';
echo ' <p class="lead">' . date_format(date_create($news_item['datum']), 'd/m/Y H:i') . '</p>';
echo ' <hr class="my-4">';
echo '<p>' . $news_item['nieuws'] . '</p>';
if ($news_item['link'] <> '' ) echo '<a class="btn btn-primary" href="'. $news_item['link'] . '" role="button">'. $news_item['link'] . '<img src="resources/open-iconic/svg/ellipses.svg"></a>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
}
}
?>
</div>
</div>