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); }