php 点赞

<button id="likeButton">点赞</button>
<script>
document.getElementById('likeButton').addEventListener('click', function() {
    fetch('/api/like', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/json'
        },
        body: JSON.stringify({ itemId: 123 })
    })
    .then(response => response.json())
    .then(data => {
        document.getElementById('likeButton').innerText = data.likes + ' 赞';
    });
});
</script>

<?php
// 假设使用PDO连接数据库
$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $itemId = $_POST['itemId'];
    $stmt = $pdo->prepare("UPDATE items SET likes = likes + 1 WHERE id = ?");
    $stmt->execute([$itemId]);
    
    $stmt = $pdo->prepare("SELECT likes FROM items WHERE id = ?");
    $stmt->execute([$itemId]);
    $result = $stmt->fetch();
    
    echo json_encode(['likes' => $result['likes']]);
}
?>

$pdo->beginTransaction();
$stmt = $pdo->prepare("UPDATE items SET likes = likes + 1 WHERE id = ?");
$stmt->execute([$itemId]);
$stmt = $pdo->prepare("SELECT likes FROM items WHERE id = ?");
$stmt->execute([$itemId]);
$result = $stmt->fetch();
$pdo->commit();

echo json_encode(['likes' => $result['likes']]);