Advertisement
michaelyuen

Untitled

May 2nd, 2018
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.69 KB | None | 0 0
  1. <?php
  2. $sql1 = "SELECT * FROM likes WHERE id_user='$_SESSION[id_user]' AND id_post='$row[id_post]'";
  3. $result1 = $conn->query($sql1);
  4. if($result1->num_rows > 0) {
  5. ?>
  6.     <a class="post-add-icon inline-items" disabled>
  7.         <svg class="olymp-heart-icon">
  8.             <use xlink:href="svg-icons/sprites/icons.svg#olymp-heart-icon"></use>
  9.         </svg>
  10.         <?php
  11. } else {
  12. ?>
  13.             <a href="#" class="post-add-icon inline-items" id="addLike" data-id="<?php echo $row['id_post']; ?>" onClick="return false">
  14.                 <svg class="olymp-heart-icon">
  15.                     <use xlink:href="svg-icons/sprites/icons.svg#olymp-heart-icon" id="addLike" data-id="<?php echo $row['id_post']; ?>"></use>
  16.                 </svg>
  17.                 <?php
  18. }
  19. ?>
  20.                     <?php $sql2 = "SELECT * FROM likes WHERE id_post='$row[id_post]'";
  21. $result2 = $conn->query($sql2);
  22. $totalLikes = (int)$result2->num_rows;
  23. ?>
  24.                         <span><?php echo $totalLikes; ?></span>
  25.             </a>
  26.  
  27.             Now that like button calls a javascript script on the bottom of my page :
  28.  
  29.             <script>
  30.                 $("#addLike").on("click", function() {
  31.                     var id_post = $(this).attr("data-id");
  32.                     $.post("includes/handlers/addlike.php", {
  33.                         id: id_post
  34.                     }).done(function(data) {
  35.                         var result = $.trim(data);
  36.                         if (result == "ok") {
  37.                             location.reload();
  38.                         } else {
  39.                             console_log(result);
  40.                         }
  41.                     });
  42.                 });
  43.             </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement