php 计算点击量

CREATE TABLE click_count (
    id INT AUTO_INCREMENT PRIMARY KEY,
    page_name VARCHAR(255) NOT NULL,
    count INT DEFAULT 0
);

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取页面名称
$page_name = $_GET['page'];

// 查询点击次数
$sql = "SELECT count FROM click_count WHERE page_name = '$page_name'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $count = $row['count'] + 1;
    // 更新点击次数
    $update_sql = "UPDATE click_count SET count = $count WHERE page_name = '$page_name'";
    if ($conn->query($update_sql) === TRUE) {
        echo "点击次数: " . $count;
    } else {
        echo "更新失败: " . $conn->error;
    }
} else {
    // 插入新的记录
    $insert_sql = "INSERT INTO click_count (page_name, count) VALUES ('$page_name', 1)";
    if ($conn->query($insert_sql) === TRUE) {
        echo "点击次数: 1";
    } else {
        echo "插入失败: " . $conn->error;
    }
}

$conn->close();
?>

<?php
// 连接数据库
$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 开启事务
$conn->begin_transaction();

try {
    // 获取页面名称
    $page_name = $_GET['page'];

    // 查询点击次数
    $sql = "SELECT count FROM click_count WHERE page_name = ? FOR UPDATE";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("s", $page_name);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        $count = $row['count'] + 1;
        // 更新点击次数
        $update_sql = "UPDATE click_count SET count = ? WHERE page_name = ?";
        $stmt = $conn->prepare($update_sql);
        $stmt->bind_param("is", $count, $page_name);
        $stmt->execute();
        echo "点击次数: " . $count;
    } else {
        // 插入新的记录
        $insert_sql = "INSERT INTO click_count (page_name, count) VALUES (?, 1)";
        $stmt = $conn->prepare($insert_sql);
        $stmt->bind_param("s", $page_name);
        $stmt->execute();
        echo "点击次数: 1";
    }

    // 提交事务
    $conn->commit();
} catch (Exception $e) {
    // 回滚事务
    $conn->rollback();
    echo "错误: " . $e->getMessage();
}

$conn->close();
?>