phpcms 列表页点击量

// 前端点击事件绑定
$('#item-link').on('click', function() {
    $.ajax({
        url: '/api/log_click',
        method: 'POST',
        data: { item_id: $(this).data('id') },
        success: function(response) {
            console.log('Click logged:', response);
        },
        error: function(error) {
            console.error('Error logging click:', error);
        }
    });
});

// 后端处理逻辑
<?php
// api/log_click.php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $item_id = $_POST['item_id'];
    // 记录点击量到数据库
    $db = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');
    $stmt = $db->prepare("INSERT INTO click_log (item_id) VALUES (:item_id)");
    $stmt->bindParam(':item_id', $item_id);
    $stmt->execute();
    echo json_encode(['status' => 'success']);
} else {
    echo json_encode(['status' => 'error']);
}
?>

// 使用分页
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$db = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');
$stmt = $db->prepare("SELECT * FROM items LIMIT :limit OFFSET :offset");
$stmt->bindParam(':limit', $limit, PDO::PARAM_INT);
$stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$items = $stmt->fetchAll(PDO::FETCH_ASSOC);