<?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 firstName, lastName FROM faker_users WHERE country = Belgium'");
        $statement->execute();

?>
<h1>Clients from Belgium</h1>
<ul id="result_clients">

    <?php while($c = $statement->fetch(PDO::FETCH_OBJ)) :   ?>

    <li> <?php echo $c->firstName; ?> <?php echo $c->lastName; ?>  </li>

    <?php endwhile; ?>
</ul>