Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $query = mysqli_query($conn, "select * from `comments`");
- while ($row = mysqli_fetch_array($query)) {
- ?>
- Comments: <?php echo $row['usercom']; ?><br>
- <?php
- $query1 = mysqli_query($conn, "select * from `favcoms` where fcom_id='" . $row['cid'] . "' and sessionid='" . $_SESSION['id'] . "'");
- $query2 = mysqli_query($conn, "select * from `favcoms` where sessionid='" . $_SESSION['id'] . "'");
- ?>
- <span class="show_like<?php echo $row['cid']; ?>">
- <?php if (mysqli_num_rows($query1) > 0) { ?>
- <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>
- <?php } else { ?>
- <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>
- <?php } ?>
- </span>
- <?php
- }
- ?>
- $(document).ready(function(){
- $(document).on('click', '.favcom', function(){
- var id=$(this).val();
- $.ajax({
- type: "POST",
- url: "like.php",
- data: {
- id: id,
- like: 1,
- },
- success: function(){
- showLike(id);
- }
- });
- });
- $(document).on('click', '.unfavcom', function(){
- var id=$(this).val();
- $.ajax({
- type: "POST",
- url: "like.php",
- data: {
- id: id,
- like: 1,
- },
- success: function(){
- showLike(id);
- }
- });
- });
- });
- function showLike(id){
- $.ajax({
- url: 'show_like.php',
- type: 'POST',
- async: false,
- data:{
- id: id,
- showlike: 1
- },
- success: function(response){
- $('.show_like'+id).html(response);
- }
- });
- }
- <?php
- session_start();
- include('conn.php');
- if (isset($_POST['showlike'])){
- $id = $_POST['id'];
- $query3=mysqli_query($conn, "select * from `favcoms` where fcom_id='".$id."' and sessionid='".$_SESSION['id']."'");
- $query4=mysqli_query($conn,"select * from `favcoms` where sessionid='".$_SESSION['id']."'");
- $numFavs = mysqli_num_rows($query4);
- if (mysqli_num_rows($query3)>0){
- 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>' ;
- } else {
- 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>' ;
- }
- }
- ?>
- $(':button[value="'+id+'"]').toggleClass('favcom unfavcom');
- $('.unfavcom').html('<i title="Remove from Favorite? - ('+response+'/20)" class="fa fa-star" aria-hidden="true"></i>');
- $('.favcom').html('<i title="Favorite Comment - ('+response+'/20)" class="fa fa-star" aria-hidden="true"></i>');
- $(document).on('click', '.favcom', function(){
- var id=$(this).val();
- $.ajax({
- type: "POST",
- url: "like.php",
- data: {
- id: id,
- like: 1,
- },
- success: function(){
- update_likes('.favcom');
- }
- });
- });
- function update_likes(class){
- $(class).each(function() {
- show_like( $(this).val() );
- });
- }
Add Comment
Please, Sign In to add comment