Guest User

Untitled

a guest
Mar 17th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. $email = $data['add_email'];
  2. $checkPrevEmail = "SELECT `emails_other` FROM `users` WHERE email='".$email."'";
  3. $checkQuery = $db->prepare($checkPrevEmail);
  4. if($checkQuery->execute()) {
  5. $checkAvailPrevEmail = $checkQuery->fetch(PDO::FETCH_ASSOC);
  6.  
  7. if (!empty($checkAvailPrevEmail["emails_other"])) {
  8. $prevEmail = unserialize($checkAvailPrevEmail["emails_other"]);
  9. $newEmail = array($email);
  10.  
  11. $emailArray = array_merge($prevEmail, $newEmail);
  12. $emailArray = serialize($emailArray);
  13. } else {
  14. $emailArray = array($email);
  15. $emailArray = serialize($emailArray);
  16. }
  17.  
  18. $sqlUpdate = "UPDATE users SET emails_other='".$emailArray."' WHERE email='".$email."'";
  19. $query = $db->prepare($sqlUpdate);
  20. if($query->execute()){
  21. $res = array(
  22. "code" => "1",
  23. "success" => "true",
  24. "userinfo" => $checkAvailPrevEmail,
  25. "message" => "Your Email info has been added."
  26. );
  27. } else {
  28. $res = array(
  29. "code" => "0",
  30. "success" => "false",
  31. "userinfo" => "",
  32. "message" => "Please try again later."
  33. );
  34. }
Add Comment
Please, Sign In to add comment