<?php
require_once 'connec.php';
$pdo = new \PDO(DSN, USER, PASS);

$query = "SELECT * FROM friend";
$statement = $pdo->query($query);
$friends = $statement->fetchAll(PDO::FETCH_ASSOC);

$firstnameError = '';
$lastnameError  = '';
$firstname      = '';
$lastname       = '';

function test_input($data) {
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $i = 0;
    if (empty($_POST['firstname'])) {
        $firstnameError = '* Firstame is required';
        $i++;
    } else {
        $firstname = test_input($_POST['firstname']);
        if (strlen($firstname) >= 45) {
            $firstnameError = 'Please enter a valid name (max 45 caracters)';
            $i++;
        }
    }
    if (empty($_POST['lastname'])) {
        $lastnameError = '* Lastname is required';
        $i++;
    } else {
        $lastname = test_input($_POST['lastname']);
        if (strlen($lastname) >= 45){
            $lastnameError = 'Please enter a valid name (max 45 caracters)';
            $i++;
        }
    }
    if ($i === 0 ) {
        $query = 'INSERT INTO friend (firstname, lastname) VALUES (:firstname, :lastname)';
        $statement = $pdo->prepare($query);
        $statement->bindValue(':firstname', $firstname, \PDO::PARAM_STR);
        $statement->bindValue(':lastname', $lastname, \PDO::PARAM_STR);
        $statement->execute();
        header ( 'Location:validation.html' );
    }
}
?>
<h2>Friend list :</h2>

<?php
echo '<ul>';
foreach ($friends as $friend) {
    echo '<li>' . $friend['id'] . ' ' .$friend['firstname'] . ' ' . $friend['lastname'] .'</li>';
}
echo '</ul>';
?>

<h2>Add a friend :</h2>
<form action="index.php" method="post">
        <div class="d-flex-column">
            <label for="firstname">Firstname :</label>
            <input type="text" id="firstname" name="firstname">
            <span class="error"><?php echo $firstnameError;?></span>
        </div>
        <br>
        <div class="d-flex-column">
            <label for="lastname">Lastname :</label>
            <input type="text" id="lastname" name="lastname">
            <span class="error"><?php echo $lastnameError;?></span>
        </div>
        <br>
        <div class="button">
            <button type="submit">Send message</button>
        </div>
</form>