File: /home/nmel17aacb/domains/rabc1882.be/public_html/php/renners.php
<div id="renners" class="overlay-col col-12">
<div class="container-fluid">
<div class="section row no-gutters">
<div class="align-self-center col-12 col-lg-6 col-xl-7">
<img src="resources/renners.jpg" class="img-fluid" alt="Onze renners">
</div>
<div class="renners-right-col col-12 col-lg-6 col-xl-5 text-center align-self-center">
<h1>Onze renners</h1>
<?php
include ("../inc/db.php");
$get_renners_categorie = mysqli_query($db, "SELECT * FROM renners_categorie WHERE actief = TRUE");
if (mysqli_num_rows($get_renners_categorie) > 0) {
while ($renners_cat = mysqli_fetch_assoc($get_renners_categorie)) {
echo '<h2><a href="#gotoonpage' . $renners_cat['id'] .'"> ' . $renners_cat['renners_cat'] . '</a></h2>';
}
}
?>
</div>
</div>
<?php
include ("../inc/db.php");
$get_renners_categorie = mysqli_query($db, "SELECT * FROM renners_categorie WHERE actief = TRUE");
if (mysqli_num_rows($get_renners_categorie) > 0) {
while ($renners_cat = mysqli_fetch_assoc($get_renners_categorie)) {
echo '<br><br><div id="#gotoonpage'.$renners_cat['id'].'"></div>"';
echo '<div class="col-12"><div class="container"><div class="row"><h2>' . $renners_cat['renners_cat'] . '</h2></div><div class="row align-items-center justify-content-center">';
$renners_cat_tmp = $renners_cat['id'];
$get_renners = mysqli_query($db, "SELECT * FROM renners WHERE actief = TRUE && categorie_id = $renners_cat_tmp");
if (mysqli_num_rows($get_renners) > 0) {
while ($renners = mysqli_fetch_assoc($get_renners)) {
echo '<div class="col-12 col-md-6 col-lg-4"><div class="img-container"><img src="files/renners/'. $renners['image'] .'" class="img-fluid rounded" alt="">';
echo '<div class="img-overlay">'. $renners['naam'] .'<br />';
echo '<small>'. $renners['lidnr'] .'</small></div></div></div>';
}
}
echo '</div></div></div>';
}
}
?>
<br>
</div>
</div>