Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function confirm_friendship($initiator, $friend_requested) {
- $pdo = Database::connect();
- try {
- $delete_request = $pdo->prepare("DELETE from friend_requests WHERE user_id1 = :userID AND user_id2 = :friend_requested");
- $delete_request->bindParam(':userID', $initiator);
- $delete_request->bindParam(':friend_requested', $friend_requested);
- $delete_request->execute();
- $confirm_friend = $pdo->prepare("INSERT INTO friends_list(user_id1, user_id2, friendship_date) VALUES(:userID, :friend_requested, NOW())");
- $confirm_friend->bindParam(':userID', $initiator);
- $confirm_friend->bindParam(':friend_requested', $friend_requested);
- $confirm_friend->execute();
- $confirm_friend2 = $pdo->prepare("INSERT INTO friends_list(user_id1, user_id2, friendship_date) VALUES(:userID, :friend_requested, NOW())");
- $confirm_friend2->bindParam(':userID', $friend_requested);
- $confirm_friend2->bindParam(':friend_requested', $initiator);
- $confirm_friend2->execute();
- } catch (PDOException $e) {
- echo $confirm_friend . "<br>" . $e->getMessage();
- }
- $pdo = null;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement