public static function insert(User $user)
{
$query = "INSERT INTO users (mail, password, firstname, lastname, address, cp, city, phone, role)\n\t\t\tVALUES ('" . $user->getMail() . "','" . $user->getPassword() . "','" . $user->getFirstname() . "','" . $user->getLastname() . "','" . $user->getAddress() . "','" . $user->getCp() . "','" . $user->getCity() . "','" . $user->getPhone() . "','" . $user->getRole() . "')";
if (DBOperation::exec($query)) {
header('Location: index.php?controller=Front&method=home&success');
} else {
header('Location: index.php?controller=Front&method=signin&error');
}
}
public static function subscribe(User $oUser)
{
$sQuery = "insert into user(email, password,address,name,firstname,cp,city) ";
$sQuery .= "values('{$oUser->getEmail()}','{$oUser->getCryptedPassword()}','{$oUser->getAddress()}','{$oUser->getName()}','{$oUser->getFirstName()}','{$oUser->getCp()}','{$oUser->getCity()}')";
return DBOperation::exec($sQuery);
}
