Guest User

Untitled

a guest
Nov 24th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.87 KB | None | 0 0
  1. <?php
  2. $query = mysqli_query($conn, "select * from `comments`");
  3. while ($row = mysqli_fetch_array($query)) {
  4. ?>
  5. Comments: <?php echo $row['usercom']; ?><br>
  6. <?php
  7. $query1 = mysqli_query($conn, "select * from `favcoms` where fcom_id='" . $row['cid'] . "' and sessionid='" . $_SESSION['id'] . "'");
  8. $query2 = mysqli_query($conn, "select * from `favcoms` where sessionid='" . $_SESSION['id'] . "'");
  9. ?>
  10. <span class="show_like<?php echo $row['cid']; ?>">
  11. <?php if (mysqli_num_rows($query1) > 0) { ?>
  12. <button value="<?php echo $row['cid']; ?>" class="unfavcom"><i title="Remove from Favorite? - (<?php echo mysqli_num_rows($query2); ?>/20)" class="fa fa-star" aria-hidden="true"></i></button>
  13. <?php } else { ?>
  14. <button value="<?php echo $row['cid']; ?>" class="favcom"><i title="Favorite Comment - (<?php echo mysqli_num_rows($query2); ?>/20)" class="fa fa-star-o" aria-hidden="true"></i></button>
  15. <?php } ?>
  16. </span>
  17. <?php
  18. }
  19. ?>
  20.  
  21. $(document).ready(function(){
  22.  
  23. $(document).on('click', '.favcom', function(){
  24. var id=$(this).val();
  25. $.ajax({
  26. type: "POST",
  27. url: "like.php",
  28. data: {
  29. id: id,
  30. like: 1,
  31. },
  32. success: function(){
  33. showLike(id);
  34. }
  35. });
  36. });
  37.  
  38. $(document).on('click', '.unfavcom', function(){
  39. var id=$(this).val();
  40. $.ajax({
  41. type: "POST",
  42. url: "like.php",
  43. data: {
  44. id: id,
  45. like: 1,
  46. },
  47. success: function(){
  48. showLike(id);
  49. }
  50. });
  51. });
  52.  
  53. });
  54.  
  55. function showLike(id){
  56. $.ajax({
  57. url: 'show_like.php',
  58. type: 'POST',
  59. async: false,
  60. data:{
  61. id: id,
  62. showlike: 1
  63. },
  64. success: function(response){
  65. $('.show_like'+id).html(response);
  66.  
  67. }
  68. });
  69. }
  70.  
  71. <?php
  72. session_start();
  73. include('conn.php');
  74.  
  75. if (isset($_POST['showlike'])){
  76. $id = $_POST['id'];
  77. $query3=mysqli_query($conn, "select * from `favcoms` where fcom_id='".$id."' and sessionid='".$_SESSION['id']."'");
  78. $query4=mysqli_query($conn,"select * from `favcoms` where sessionid='".$_SESSION['id']."'");
  79. $numFavs = mysqli_num_rows($query4);
  80. if (mysqli_num_rows($query3)>0){
  81. echo '<button class="mycomoptions unfavcom" value="'.$id.'"><font color="#00CC00"><i title="Remove from Favorite? - ('.$numFavs.'/20)" class="fa fa-star" aria-hidden="true"></i></font></button>' ;
  82. } else {
  83. echo '<button class="mycomoptions favcom" value="'.$id.'"><font color="#00CC00"><i title="Remove from Favorite? - ('.$numFavs.'/20)" class="fa fa-star-o" aria-hidden="true"></i></font></button>' ;
  84. }
  85. }
  86. ?>
  87.  
  88. $(':button[value="'+id+'"]').toggleClass('favcom unfavcom');
  89. $('.unfavcom').html('<i title="Remove from Favorite? - ('+response+'/20)" class="fa fa-star" aria-hidden="true"></i>');
  90. $('.favcom').html('<i title="Favorite Comment - ('+response+'/20)" class="fa fa-star" aria-hidden="true"></i>');
  91.  
  92. $(document).on('click', '.favcom', function(){
  93. var id=$(this).val();
  94. $.ajax({
  95. type: "POST",
  96. url: "like.php",
  97. data: {
  98. id: id,
  99. like: 1,
  100. },
  101. success: function(){
  102. update_likes('.favcom');
  103. }
  104. });
  105. });
  106.  
  107. function update_likes(class){
  108. $(class).each(function() {
  109. show_like( $(this).val() );
  110. });
  111. }
Add Comment
Please, Sign In to add comment