php - 在数据库的帮助下在 PHP 中创建一个计数器？

Question

我有网址为 http://siteurl/directory/onemore/ 的网页$文件ID.php我试图只提取 $fileID，然后使用

$query = $mysqli->query("SELECT * FROM tablename WHERE ID = $fileID");
$rows = mysqli_fetch_array($query);
$hits = $rows['HITS'];
$hits = $hits + 1;
$query = $mysqli->query("UPDATE tablename SET HITS = $hits WHERE ID = $fileID");
echo 'Total hits on page'.$hits.'';

我不知道如何只获取 $fileID 部分，想问一下我的其余程序是否正确？

编辑

使用上面的代码，点击停留在一个位置。我在想，每次页面刷新后，它们都会更新为 +1。

Answer 1

您可以这样确定 $fileId:

/* $_SERVER['PHP_SELF'] results to e.g. '/directory/onemore/5.php' */
/* basename(...) results to e.g. '5.php' */
$fileName = basename($_SERVER['PHP_SELF']);
/* take the text before the last occurrence of '.' */
$fileID = substr($fileName, 0, strrpos($fileName, '.'));


$query = $mysqli->query("UPDATE tablename SET HITS = HITS + 1 WHERE ID = $fileID");

$query = $mysqli->query("SELECT * FROM tablename WHERE ID = $fileID");
$rows = mysqli_fetch_array($query);
$hits = $rows['HITS'];
echo 'Total hits on page'.$hits.'';