PHP 和 MySQL 命中计数器多页计数问题？

Question

以下脚本将更新数据库，但不会在每个不同页面上显示正确的页数。由于某种原因，大多数时候它会卡住页面上的页数。

这是 PHP 代码:

<?php
$page = $_SERVER['SCRIPT_FILENAME']; 

// Query member data from the database and ready it for display
$mysqli = new mysqli("localhost", "root", "", "sitename");
$dbc = mysqli_query($mysqli,"SELECT id page FROM mysql_counter_logs WHERE page = '$page'");

if (mysqli_num_rows($dbc) == 0) {
    $mysqli = new mysqli("localhost", "root", "", "sitename");
    $clean_page = mysqli_real_escape_string($mysqli, $page);
    $dbc = mysqli_query($mysqli,"INSERT INTO mysql_counter_logs (page) VALUES ('$clean_page')");
} 

if ($dbc == 1) {
    $dbc = mysqli_query($mysqli,"UPDATE mysql_counter_logs SET hits = hits + 1 WHERE page = '$page'");
}

//Retrieves the current count
$count = mysqli_fetch_row(mysqli_query($mysqli,"SELECT hits FROM mysql_counter_logs"));

if (!$dbc) {
    // There was an error...do something about it here...
    print mysqli_error();
} 

//Displays the count on your site
echo $count[0];
?>

Answer 1

如果你给出表结构会更好，因为我理解这个表结构的方式是你使用页面字符串作为id，从你的插入查询select id as可以明显看出page ... where page =... 我不知道你的表结构。所以我不能说问题出在插入或更新上。

如果我的上述假设是正确的，您将 page 放在更新查询 where 子句中的 id 位置，将更新语句更改为 -

$dbc = mysqli_query($mysqli,"UPDATE mysql_counter_logs SET hits = hits + 1 WHERE id= '$page'");