Html部分代码:
<?php
$id = $_GET['id'];
require_once 'mysqlHelper.php';
$db = new mysqlHelper('localhost','root','root','dianzan');
$sql = "select * from news where id = '$id'";
$news = $db->GetOneData($sql);
?>
<!doctype html>
<html>
<head>
<script src="jquery-1.9.1.min.js"></script>
<meta charset="UTF-8">
</head>
<body>
<h1><?php echo $news['title'];?></h1>
<pre>
<?php echo $news['content'];?>
</pre>
<input type="hidden" name="id" value="<?php echo $id;?>">
点赞数:<span id="s"><?php echo $news['dianzan'];?></span>
<button id="btn">点赞</button>
</body>
</html>
Js代码:
$("#btn").click(function(){
$.ajax({
url:"index.php",
type:"POST",
data:{id:<?php echo $id;?>},
async:false,
success:function(data){
if(data === false){
alert('点赞失败!');location.href='dianzan.php?id=<?php echo $id;?>';
}else{
alert('点赞成功!');$("#s").html(data);
}
}
})
})
PHP代码:
<?php
header("Content-type:text/html;charset=utf-8");
require_once 'mysqlHelper.php';
$db = new mysqlHelper('localhost','root','root','dianzan');
$id = $_POST['id'];
$sql = "UPDATE news SET dianzan = dianzan +1 WHERE id = '$id'";
$res = $db->execSql($sql);
if($res){
$dz = $db->getOneData("select * from news where id = '$id'");
$dz = $dz['dianzan'];
echo $dz;
}else{
return false;
}
?>