Guest User

Untitled

a guest
May 22nd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. $("#OK").click(function()
  2. {
  3. unsubscribeMember();
  4. window.location.href="signup-for-event.php?memId=" + <?php echo $_SESSION['memberId'] ?>;
  5. });
  6.  
  7. function unsubscribeMember()
  8. {
  9. var data = "memId=" + <?php echo $_SESSION['memberId'];?> + "&actID=" + <?php echo $_GET['actID']; ?> ;
  10. alert(data);
  11.  
  12. $.ajax({
  13. dataType: 'json',
  14. url: 'json-responses.php?fct=deleteMemberFromActivity',
  15. data: data,
  16. cache: false
  17. });
  18. }
  19.  
  20. if ($_GET['fct'] == 'deleteMemberFromActivity')
  21. {
  22. $result = deleteMemberFromActivity($connectionObject, $_GET['actID'], $_GET['memId']);
  23. echo $result;
  24. }
  25.  
  26. function deleteMemberFromActivity($PDOdbObject, $actId, $memberId)
  27. {
  28. $deleteSignUpsSQL = "DELETE FROM 'member_activity' WHERE 'activity_id' = ? AND 'member_id' = ?";
  29. $stmt = $PDOdbObject->prepare($deleteSignUpsSQL);
  30. $stmt -> execute([$actId, $memberId]);
  31. $affected_rows = $stmt->rowCount();
  32. return $affected_rows;
  33. }
Add Comment
Please, Sign In to add comment