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

     $country = "?";
    if( !empty($_POST) ){
        $conn = new PDO('mysql:host=localhost;dbname=www.professormode.com', 'faker', 'SG3wyi0SbGGz2&KLb');
        $input = $_POST['emails'];

        echo $input;

        $statement = $conn->prepare("SELECT * FROM faker_users WHERE `email`= :email");
        $statement->bindParam(":email", $input);
        $result = $statement->execute();

        $user = $statement->fetch(PDO::FETCH_ASSOC);  //fetch assoc wilt zeggen uitlezen in array
                $country = $user['country'];

    }


?>
<!-- WIJZIG DE CODE HIERONDER NIET -->
<form method="post" action="">
    <label for="emails">Select a person</label>
    <select name="emails" id="emails">
        <option value="">Select a person</option>
        <option value="vandervort.lenore@crist.net">vandervort.lenore@crist.net</option>
    </select>
    <button type="submit">Search country</button>
</form>

<h3>This person lives in
    <span id="country"><?php echo $country; ?></span>
</h3>