PHP/MySQL赞按钮 [英] PHP/MySQL Like Button

问题描述

我使用以下代码为我的产品页面设置了喜欢"按钮:

I've made a 'like' button for my product pages with this code:

<?php
if('POST' == $_SERVER['REQUEST_METHOD']) {
$sql = "UPDATE table set `likes` = `likes`+1 where `product_id` = '1'";
$result=mysql_query($sql);
}
?>

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="POST">
<input type = "submit" value = "like"/>
</form>

就像一个魅力吸引人的作品，解决了一个小问题，那就是每次访问该页面都会记录一个喜欢".

Works like a charm excpet for one minor problem being that every visit to the page registers a 'like'.

有人可以帮忙解释一下我需要更改/添加什么，以便仅在提交实际表格时才注册新的喜欢"吗?

Could someone help explain what i need to chnage/add in order that new 'likes' are only registered when the actual form is submitted?

谢谢 丹

推荐答案

<?php
if($_POST['like']) {
$sql = "UPDATE table set `likes` = `likes`+1 where `product_id` = '1'";
$result=mysql_query($sql);
}
?>

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="POST">
<input type = "submit" value = "like" name='like'/>
</form>

这应该有效；-)

这篇关于PHP/MySQL赞按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！