<?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= 'Belgium'");
        $statement->execute();
        $persons = $statement->fetchAll();

?>
<h1>Clients from Belgium</h1>
<ul id="result_clients">
    <?php foreach($persons as $p): ?>
    <li><?php echo $p['firstName']." ".$p['lastName']; ?></li>
    <?php endforeach ?>
</ul>