php - 我正在尝试使用 PHP 和 mysql 制作点击计数器

Question

<?php
$hostname = 'localhost';
$username = 'root';
$password = '';
$db_name = 'somedb';
$conn = mysqli_connect($hostname, $username, $password, $db_name);
if (isset($_POST['abc'])){
    $date_today = date('Y-m-d');
    $somecount=("INSERT INTO sometable (today,somecount) VALUES ('".$date_today."', '') ON DUPLICATE KEY UPDATE somecount=somecount+1");
    mysqli_query($conn, $somecount);
}

?>

<form method="post" action="some.php">
    <input type="submit" name="abc">
</form>

我已经尝试过这段代码。请有人帮我计算用户在按钮或提交输入标签上的点击次数。提前致谢。

Answer 1

只需更新这一行:来自

$somecount=("INSERT INTO sometable (today,somecount) VALUES ('".$date_today."', '') ON DUPLICATE KEY UPDATE somecount=somecount+1");

至

$somecount=("INSERT INTO sometable (today,somecount) VALUES ('".$date_today."', '1') ON DUPLICATE KEY UPDATE somecount=somecount+1");

此外，为了确保您不会重定向到当前页面本身执行以下代码的另一个页面:

<form method="post" action="">
    <input type="submit" name="abc">
</form>

这样做将确保您提交到同一页面。