Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2015
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. //Look for an existing record based on facebookID
  2. $select = $mysqli->prepare("SELECT facebookID, emailAddress FROM user WHERE facebookID = ?");
  3. $select->bind_param('i', $facebookID);
  4. $select->execute();
  5. $select->store_result();
  6.  
  7. //Logic for how to proceed based on what's found
  8. if ($select->num_rows == 1) {
  9. //User already exists
  10. echo "User exists. Set session variables, close window, and refresh origin page.";
  11. } else {
  12. //User doesn't exist
  13. echo "User does not exist. Create user.<br><br>";
  14. if (!$email) {
  15. //User needs to supply email address
  16. echo "User has not supplied an email address. Prompt for one before creating account.";
  17. } else {
  18. //All info present, proceed with record insertion
  19.  
  20. echo "INSERT INTO user VALUES (NULL, '$email', '', '', '$name', '0000-00-00', '', '', 0, 0, 0, now(), '0000-00-00 00:00:00', 0, '$facebookID', '', '', '', '')" . "<br><br>";
  21.  
  22. $insert = $mysqli->prepare("INSERT INTO user VALUES (NULL, ?, '', '', ?, '0000-00-00', '', '', 0, 0, 0, now(), '0000-00-00 00:00:00', 0, ?, '', '', '', '')");
  23.  
  24. var_dump($insert);
  25.  
  26. $insert->bind_param('ssi', $email, $name, $facebookID);
  27. $insert->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement