oef 4

<?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 = :country");
    $statement->bindValue(':country','Belgium');
    $statement->execute();


?>
<h1>Clients from Belgium</h1>

<ul id="result_clients">
    <?php while($b = $statement->fetch(PDO::FETCH_ASSOC)): ?>
    <li><?php echo $b['firstName'];?><?php echo ' ';?><?php echo $b['lastName'];?></li>
    <?php endwhile; ?>
</ul>