session_start(); ob_start(); include("connect.php"); if(isset($_COOKIE['ab_user']) && !isset($_SESSION['logged'])) { $q_check ="SELECT * FROM ab_user WHERE u_id = '".$_COOKIE['ab_user']['id']."' "; $r_check = mysqli_query($con,$q_check) ; $check = mysqli_fetch_array($r_check); $_SESSION['logged']['naam'] = $check['u_naam']; $_SESSION['logged']['id'] = $check['u_id']; } elseif(!isset($_COOKIE['ab_user'])) { header("location:login.php"); } if(isset( $_SESSION['logged'])) { $teton = $_SESSION['logged']['id']; } elseif(!isset( $_SESSION['logged'])) { $teton = 1; } include("lg/".$_SESSION['lg'].".php"); $q_jaar = " SELECT DISTINCT YEAR(vh_in) AS jaar FROM ab_verhuring ORDER BY jaar DESC "; $result = mysqli_query($con, $q_jaar); // Voer de query uit if ($result) { // Loop door de resultaten en haal elk jaar op while ($r_jaar = mysqli_fetch_assoc($result)) { $jaren[$r_jaar['jaar']] = $r_jaar['jaar']; // Gebruik 'jaar' in plaats van 'vh_in' } } else { echo "Query fout: " . mysqli_error($con); // Foutmelding als de query mislukt } ?>