Like unlike functionality used in many websites to know the user response to their content or article.
In this tutorial, I will add like and unlike buttons within the content and handle with jQuery and PHP.
In the demonstration, I will show the list of posts within these posts they have like unlike button.
It also has a label that shows how many totals like and unlike gets a post. Whenever the user clicked on a button the value of the label gets changed.
Contents
1. Table structure
I am using two tables in the example.
posts table
CREATE TABLE `posts` ( `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `title` varchar(100) NOT NULL, `content` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
like_unlike table
CREATE TABLE `like_unlike` ( `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `userid` int(11) NOT NULL, `postid` int(11) NOT NULL, `type` int(2) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2. Configuration
Create a config.php file for the database connection.
Completed Code
<?php
$host = "localhost"; /* Host name */
$user = "root"; /* User */
$password = ""; /* Password */
$dbname = "tutorial"; /* Database name */
$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
}
3. HTML
Creating layout where display posts that contain title, content, and like, unlike button.
Fetch records from the posts table and count total like and unlike on the posts.
Also, select the user attempt on the post from like_unlike table and change button color accordingly.
Note – I am using
postidfor creating like and unlike button ids. This one is use in jQuery for identifying what post button is clicked.
Completed Code
<div class="content">
<?php
$userid = 5;
$query = "SELECT * FROM posts";
$result = mysqli_query($con,$query);
while($row = mysqli_fetch_array($result)){
$postid = $row['id'];
$title = $row['title'];
$content = $row['content'];
$type = -1;
// Checking user status
$status_query = "SELECT count(*) as cntStatus,type FROM like_unlike WHERE userid=".$userid." and postid=".$postid;
$status_result = mysqli_query($con,$status_query);
$status_row = mysqli_fetch_array($status_result);
$count_status = $status_row['cntStatus'];
if($count_status > 0){
$type = $status_row['type'];
}
// Count post total likes and unlikes
$like_query = "SELECT COUNT(*) AS cntLikes FROM like_unlike WHERE type=1 and postid=".$postid;
$like_result = mysqli_query($con,$like_query);
$like_row = mysqli_fetch_array($like_result);
$total_likes = $like_row['cntLikes'];
$unlike_query = "SELECT COUNT(*) AS cntUnlikes FROM like_unlike WHERE type=0 and postid=".$postid;
$unlike_result = mysqli_query($con,$unlike_query);
$unlike_row = mysqli_fetch_array($unlike_result);
$total_unlikes = $unlike_row['cntUnlikes'];
?>
<div class="post">
<h2><?php echo $title; ?></h2>
<div class="post-text">
<?php echo $content; ?>
</div>
<div class="post-action">
<input type="button" value="Like" id="like_<?php echo $postid; ?>" class="like" style="<?php if($type == 1){ echo "color: #ffa449;"; } ?>" /> (<span id="likes_<?php echo $postid; ?>"><?php echo $total_likes; ?></span>)
<input type="button" value="Unlike" id="unlike_<?php echo $postid; ?>" class="unlike" style="<?php if($type == 0){ echo "color: #ffa449;"; } ?>" /> (<span id="unlikes_<?php echo $postid; ?>"><?php echo $total_unlikes; ?></span>)
</div>
</div>
<?php
}
?>
</div>
4. PHP
Create likeunlike.php file for handling AJAX requests.
I fix the userid value to 5 which you can change on your project or you can use $_SESSION variable for getting login user id.
Here, if $type value is –
0 – means user have clicked, unlike button.
1 – means user have clicked a like button.
Check if a user has any record in like_unlike table on the post. If not then insert a new record otherwise update the record.
Count total like unlike on the $postid and initialize $return_arr with the counts.
Return an Array in JSON format.
Completed Code
<?php
include "config.php";
$userid = 5;
$postid = $_POST['postid'];
$type = $_POST['type'];
// Check entry within table
$query = "SELECT COUNT(*) AS cntpost FROM like_unlike WHERE postid=".$postid." and userid=".$userid;
$result = mysqli_query($con,$query);
$fetchdata = mysqli_fetch_array($result);
$count = $fetchdata['cntpost'];
if($count == 0){
$insertquery = "INSERT INTO like_unlike(userid,postid,type) values(".$userid.",".$postid.",".$type.")";
mysqli_query($con,$insertquery);
}else {
$updatequery = "UPDATE like_unlike SET type=" . $type . " where userid=" . $userid . " and postid=" . $postid;
mysqli_query($con,$updatequery);
}
// count numbers of like and unlike in post
$query = "SELECT COUNT(*) AS cntLike FROM like_unlike WHERE type=1 and postid=".$postid;
$result = mysqli_query($con,$query);
$fetchlikes = mysqli_fetch_array($result);
$totalLikes = $fetchlikes['cntLike'];
$query = "SELECT COUNT(*) AS cntUnlike FROM like_unlike WHERE type=0 and postid=".$postid;
$result = mysqli_query($con,$query);
$fetchunlikes = mysqli_fetch_array($result);
$totalUnlikes = $fetchunlikes['cntUnlike'];
// initalizing array
$return_arr = array("likes"=>$totalLikes,"unlikes"=>$totalUnlikes);
echo json_encode($return_arr);
5. jQuery
On like unlike button click split the id to get the postid.
Send an AJAX request where pass the postid and type.
On successful callback update total counts on the elements with data['likes'] and data['unlikes'].
Change the color of the button based on the click.
Complete Code
$(document).ready(function(){
// like and unlike click
$(".like, .unlike").click(function(){
var id = this.id; // Getting Button id
var split_id = id.split("_");
var text = split_id[0];
var postid = split_id[1]; // postid
// Finding click type
var type = 0;
if(text == "like"){
type = 1;
}else{
type = 0;
}
// AJAX Request
$.ajax({
url: 'likeunlike.php',
type: 'post',
data: {postid:postid,type:type},
dataType: 'json',
success: function(data){
var likes = data['likes'];
var unlikes = data['unlikes'];
$("#likes_"+postid).text(likes); // setting likes
$("#unlikes_"+postid).text(unlikes); // setting unlikes
if(type == 1){
$("#like_"+postid).css("color","#ffa449");
$("#unlike_"+postid).css("color","lightseagreen");
}
if(type == 0){
$("#unlike_"+postid).css("color","#ffa449");
$("#like_"+postid).css("color","lightseagreen");
}
}
});
});
});
6. Demo
7. Conclusion
On the example, I used like unlike on the Post list you can either use this on any other cases for example – To get the response on your web design from your registered users or using it in the comment section, etc.
If you found this tutorial helpful then don't forget to share.
