<?php
    // WIJZIG ENKEL CODE IN HET PHP BLOCK
    // SQL CONNECTION DETAILS:
    // server: localhost
    // user: faker
    // password: SG3wyi0SbGGz2&KLb
    // database: www.professormode.com

    $conn = new PDO('mysql:host=localhost; dbname=www.professormode.com', 'faker', 'SG3wyi0SbGGz2&KLb');
    $statement = $conn->prepare("select * from faker_users where country = :country");
    $statement->bindValue(':country', 'Belgium');
    $statement->execute();
    $res = $statement->execute();


    $arrayresult = $statement->fetchAll();




?>
<h1>Clients from Belgium</h1>
<ul id="result_clients">
    <!-- <li>Firstname Lastname</li> -->
    <?php foreach ($arrayresult as $result) : ?>
        <li><?php echo $result->firstName ?></li>
    <?php endforeach; ?>
</ul>