php 点击次数

CREATE TABLE click_counts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    item_id INT NOT NULL,
    clicks INT DEFAULT 0
);

<button id="clickButton">Click Me!</button>
<p>Clicks: <span id="clickCount">0</span></p>

<script>
document.getElementById('clickButton').addEventListener('click', function() {
    fetch('increment_click.php', { method: 'POST', body: JSON.stringify({ item_id: 1 }) })
        .then(response => response.json())
        .then(data => {
            document.getElementById('clickCount').textContent = data.clicks;
        });
});
</script>

<?php
// 连接数据库
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// 获取POST数据
$data = json_decode(file_get_contents('php://input'), true);
$item_id = $data['item_id'];

// 更新点击次数
$stmt = $db->prepare("UPDATE click_counts SET clicks = clicks + 1 WHERE item_id = ?");
$stmt->execute([$item_id]);

// 查询当前点击次数
$stmt = $db->prepare("SELECT clicks FROM click_counts WHERE item_id = ?");
$stmt->execute([$item_id]);
$row = $stmt->fetch();

echo json_encode(['clicks' => $row['clicks']]);
?>