<?php
session_start();
include('../includes/connection.php');

$connect = new connection();

//Controleer of het emailadres al bestaat
$control_query = $connect->connect()->prepare('SELECT * FROM people WHERE EmailAddress = :email AND PersonID != :personid');
$control_query->execute(array(
    ':email' => $_POST['email'],
    ':personid' => $_SESSION['user_id']
));
$email_exists = $control_query->fetchAll();
$email_check = $control_query->rowCount();

if ($email_check == 0) {
    $var = $connect->connect()->prepare('UPDATE people SET FullName = :fullname,EmailAddress = :email,PhoneNumber = :phonenumber WHERE PersonID = :personid');
    $execute_variabele = $var->execute(array(
        ':fullname' => $_POST['fullname'],
        ':email' => $_POST['email'],
        ':phonenumber' => $_POST['phonenumber'],
        ':personid' => $_SESSION['user_id']
    ));

    header('Location: ../views/Gegevens.php');
} else {
    header('Location: ../views/Gegevens.php');
}
?>