Advertisement
Rpgdudester

Untitled

Dec 12th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.23 KB | None | 0 0
  1. function confirm_friendship($initiator, $friend_requested) {
  2.         $pdo = Database::connect();
  3.         try {
  4.             $delete_request = $pdo->prepare("DELETE from friend_requests WHERE user_id1 = :userID AND user_id2 = :friend_requested");
  5.             $delete_request->bindParam(':userID', $initiator);
  6.             $delete_request->bindParam(':friend_requested', $friend_requested);
  7.             $delete_request->execute();
  8.  
  9.             $confirm_friend = $pdo->prepare("INSERT INTO friends_list(user_id1, user_id2, friendship_date) VALUES(:userID, :friend_requested, NOW())");
  10.             $confirm_friend->bindParam(':userID', $initiator);
  11.             $confirm_friend->bindParam(':friend_requested', $friend_requested);
  12.             $confirm_friend->execute();
  13.  
  14.             $confirm_friend2 = $pdo->prepare("INSERT INTO friends_list(user_id1, user_id2, friendship_date) VALUES(:userID, :friend_requested, NOW())");
  15.             $confirm_friend2->bindParam(':userID', $friend_requested);
  16.             $confirm_friend2->bindParam(':friend_requested', $initiator);
  17.             $confirm_friend2->execute();
  18.  
  19.         } catch (PDOException $e) {
  20.             echo $confirm_friend . "<br>" . $e->getMessage();
  21.         }
  22.         $pdo = null;
  23.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement