mysql表点赞实现_phpmysql怎么实现点赞功能

php mysql怎么实现点赞功能

1、index.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)

?>

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

header("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相关知识，请访问PHP中文网！