Learn php+mysql+ajax to partially refresh the like/cancel like function-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Learn php+mysql+ajax to partially refresh the like/cancel like function

coldplay.xixi

Aug 06, 2020 pm 04:17 PM

Learn php+mysql+ajax to partially refresh the like/cancel like function

Record users who like each like, and count the number of likes
First determine whether the user likes or not. Load different html and call different methods depending on whether it is liked or not

Liked

If it has been liked Like, display the liked html, and cancel the like operation

Related learning recommendations:php programming(video)

Not liked

If not liked, display the unliked html and perform the like operation

For different operations , to increase or decrease the database. At the same time, add or delete records for the likes of different users. By controlling the background of different buttons, you can display different effects. By recording the relationship between the user IDs and like IDs of different users, restrictions on different likes can be implemented.

Effect Demonstration

When the user ID is 1, like it, and the number of likes is increased by 1

Learn php+mysql+ajax to partially refresh the like/cancel like function

Change the user ID, when When the id is 2, user 1 has already liked it, and the number of likes is increased by 1 based on user 1’s likes

Learn php+mysql+ajax to partially refresh the like/cancel like function

database

The database is divided into two data tables. One is used to count the number of likes, and the other is used to record the likes of different users.

Details of the two data tables

Learn php+mysql+ajax to partially refresh the like/cancel like function

Connect to the database

$con = new mysqli(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;,&#39;test&#39;);
	if (!$con)
	{
	 die(&#39;连接数据库失败，失败原因：&#39; . mysqli_error());
	}else {
	 // echo "连接成功";
	}

Determine whether the user likes or not (Operation page)

Extract information from the database

//假设用户编号为1
	$uId="1";
	
	//假设赞编号为1
	$zanId="1";
	
	//查找赞id为1的点赞数
	$count=mysqli_query($con, "SELECT count FROM zanCount WHERE zanId=$zanId ");
	$countResult=mysqli_fetch_array($count);
	$countZan=$countResult[&#39;count&#39;];
	
	//查找改用户是否对赞id为1 点赞
	$uIdLike=mysqli_query($con, "SELECT * FROM zanRecord WHERE uId=$uId ");
	$result=mysqli_fetch_array($uIdLike);

Judge whether the user likes it and output different html

//点赞
if (isset($result)) 
	{
	 $showZan.=<<<html
  <p class="dolikep" id="dolikep">
		 <button id="dolike" οnclick="zanDel()"></button>
		 <span id="zan">$countZan</span>
  </p>
html;
	 
	 
	}
	//没点赞
	else
	{
	 $showZan.=<<<html
 <p class="dolikep" id="dolikep">
		 <button id="donolike" οnclick="zan()"></button>
		 <span id="zan">$countZan</span>
 </p>
html;
	}
	echo $showZan;
 ?>

css style

#dolike, #donolike 
{ 
 width:30px;
 height:30px; 
 margin-left:20px;
 float:left;}
#donolike 
{
background:url(./images/noLearn php+mysql+ajax to partially refresh the like/cancel like function); 
background-size:30px 30px; 
}
#dolike
{
background:url(./images/Learn php+mysql+ajax to partially refresh the like/cancel like function);
 background-size:30px 30px; 
 }

The ajax method called

passes the required data, which is passed here When zanId and uId
remember to introduce the jq file
Like

function zan()
{
	$.ajax({
		type:"POST",
		url:"./likeSever.php",
		data:{&#39;zanId&#39;:$("#zanId").val(),&#39;uId&#39;:$("#uId").val()},
		success:function(text){
			$("#dolikep").html(text);
		}
	});
	
}

Cancel like

function zanDel()
{
	$.ajax({
		type:"POST",
		url:"./disSever.php",
		data:{&#39;zanId&#39;:$("#zanId").val(),&#39;uId&#39;:$("#uId").val()},
		success:function(text){
			$("#dolikep").html(text);
		}
	});
	
}

Processing code

Like processing

//更新赞总数的数据
 mysqli_query($con,"UPDATE zanCount SET count = count+1 WHERE zanId=$zanId");
 
 //添加一条点赞记录 
 mysqli_query($con,"INSERT INTO zanRecord(zanId,uId) VALUES($zanId, $uId); ");
 
 //查找赞的总数
 @$count=mysqli_query($con, "SELECT count FROM zanCount WHERE zanId=$zanId ");
 @$countResult=mysqli_fetch_array($count);
 @$countZan=$countResult[&#39;count&#39;];
 
 //更改输出的html
 $show="";
 $show=<<<html
 <button id="dolike" οnclick="zanDel()"></button>
		<span id="zan">$countZan</span>
html;
 echo $show;

Cancel like processing

//更新赞总数的数据
 mysqli_query($con,"UPDATE zanCount SET count = count-1 WHERE zanId=$zanId");
 
 //添加一条点赞记录
 mysqli_query($con,"DELETE FROM zanRecord WHERE zanId=$zanId AND uId=$uId ");
 
 //查找赞的总数
 @$count=mysqli_query($con, "SELECT count FROM zanCount WHERE zanId=$zanId ");
 @$countResult=mysqli_fetch_array($count);
 @$countZan=$countResult[&#39;count&#39;];
 
 //更新html
 $show="";
 $show.=<<<html
 <button id="donolike" οnclick="zan()"></button>
		<span id="zan">$countZan</span>
html;

like的PICTURES
The picture was drawn by myself, it’s a bit unsightly

Learn php+mysql+ajax to partially refresh the like/cancel like function noLearn php+mysql+ajax to partially refresh the like/cancel like function

The above is the detailed content of Learn php+mysql+ajax to partially refresh the like/cancel like function. For more information, please follow other related articles on the PHP Chinese website!

Statement

This article is reproduced at:jb51. If there is any infringement, please contact admin@php.cn delete

11 Best PHP URL Shortener Scripts (Free and Premium)Mar 03, 2025 am 10:49 AM

Long URLs, often cluttered with keywords and tracking parameters, can deter visitors. A URL shortening script offers a solution, creating concise links ideal for social media and other platforms. These scripts are valuable for individual websites a

Working with Flash Session Data in LaravelMar 12, 2025 pm 05:08 PM

Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-

Build a React App With a Laravel Back End: Part 2, ReactMar 04, 2025 am 09:33 AM

This is the second and final part of the series on building a React application with a Laravel back-end. In the first part of the series, we created a RESTful API using Laravel for a basic product-listing application. In this tutorial, we will be dev

Simplified HTTP Response Mocking in Laravel TestsMar 12, 2025 pm 05:09 PM

Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

cURL in PHP: How to Use the PHP cURL Extension in REST APIsMar 14, 2025 am 11:42 AM

The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.

12 Best PHP Chat Scripts on CodeCanyonMar 13, 2025 pm 12:08 PM

Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom

Announcement of 2025 PHP Situation SurveyMar 03, 2025 pm 04:20 PM

The 2025 PHP Landscape Survey investigates current PHP development trends. It explores framework usage, deployment methods, and challenges, aiming to provide insights for developers and businesses. The survey anticipates growth in modern PHP versio

Notifications in LaravelMar 04, 2025 am 09:22 AM

In this article, we're going to explore the notification system in the Laravel web framework. The notification system in Laravel allows you to send notifications to users over different channels. Today, we'll discuss how you can send notifications ov

See all articles