下面讲讲关于php mysql实现点赞功能的步骤,文字的奥妙在于贴近主题相关。所以,闲话就不谈了,我们直接看下文吧,相信看完php mysql实现点赞功能的步骤这篇文章你一定会有所受益。

php mysql怎么实现点赞功能

1、index.php 读取数据库点赞表的数量。

<!DOCTYPE html><html><head><meta charset="utf-8"><title>点赞</title><script src="jquery-2.1.1.min.js"></script><script src="index.js"></script></head><body><button id="btn">赞</button><span id="result"><?php$con = mysqli_connect('localhost', 'username', 'password');if(! $con ){ die('连接失败: ' . mysqli_error($con));}mysqli_select_db($con,'jwhuang');mysqli_query($con,"set names utf8");$result = mysqli_query($con,"SELECT * FROM zan");while($row = mysqli_fetch_array($result)){echo $row['zan'];}mysqli_close($con)?></span></body></html>

2、server.php 用户点击赞按钮就向数据库插入一条数据。

<?phpheader("Content-type:text/html;charset=utf-8");$con = mysqli_connect('localhost', 'username', 'password');if(!$con ){ die('连接失败: ' . mysqli_error($con));}mysqli_select_db($con,'jwhuang');mysqli_query($con,"set names utf8");mysqli_query($con,"UPDATE zan SET zan = zan+1");$result = mysqli_query($con,"SELECT * FROM zan");if(isset($_GET['name'])){while($row = mysqli_fetch_array($result)) { echo $row['zan']; }}else{echo "赞失败!";}mysqli_close($con);?>

3、index.js 请求数据

$(document).ready(function(){$("#btn").on("click",function(){$.get("sever.php",{name:$("#btn").val()},function(data){$("#result").text(data);});});});

对于以上php mysql实现点赞功能的步骤相关内容,大家还有什么不明白的地方吗?或者想要了解更多相关,可以继续关注我们的行业资讯板块。