How to develop a simple web page counter using PHP

How to use PHP to develop a simple web page counter

When creating and maintaining a website, it is very important to know information such as the number of visitors and pages viewed. The web page counter is one of the tools that helps us achieve this function. In this article, we will learn how to develop a simple web page counter using PHP and provide specific code examples.

1. Create database table

First, we need to create a database table to store web page access information. We can use MySQL database to accomplish this task. The following is a simple table structure example:

CREATE TABLE `page_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_url` varchar(255) NOT NULL,
  `view_count` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

In this table, we have four fields:

• id: primary key, a unique ID used to identify each web page.
• page_url: Stores the URL of the web page.
• view_count: stores the number of visits.
• created_at: Record the timestamp of each visit.

2. Create a counter page

Next, in the page where you want to count the number of visits, add the following code:

<?php
// 引入数据库连接配置文件
require_once "config.php";

// 获取当前访问的页面URL
$page_url = $_SERVER['REQUEST_URI'];

// 查询数据库中是否已存在当前页面的访问记录
$query = "SELECT * FROM page_views WHERE page_url = :page_url";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':page_url', $page_url);
$stmt->execute();

if ($stmt->rowCount() > 0) {
    // 如果已存在记录，则更新访问次数
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    $view_count = $row['view_count'] + 1;
    $query = "UPDATE page_views SET view_count = :view_count WHERE page_url = :page_url";
    $stmt = $pdo->prepare($query);
    $stmt->bindParam(':view_count', $view_count);
    $stmt->bindParam(':page_url', $page_url);
    $stmt->execute();
} else {
    // 如果不存在记录，则插入新的访问记录
    $view_count = 1;
    $query = "INSERT INTO page_views (page_url, view_count) VALUES (:page_url, :view_count)";
    $stmt = $pdo->prepare($query);
    $stmt->bindParam(':page_url', $page_url);
    $stmt->bindParam(':view_count', $view_count);
    $stmt->execute();
}
?>

In the above In the code, we first introduced the database connection configuration file (config.php). Then, we get the URL of the currently visited page and query whether an access record for this page already exists in the database. If a record exists, add 1 to the number of visits and update it to the database; if no record exists, insert a new record and set the number of visits to 1.

3. Display the number of visits

In order to display the number of visits on the page, we need to add the following code:

<?php
$query = "SELECT view_count FROM page_views WHERE page_url = :page_url";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':page_url', $page_url);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$view_count = $row['view_count'];

echo "该页面已被访问 " . $view_count . " 次";
?>

In the above code, we query the database The number of visits to the current page and display it on the page.

Through the above three steps, we can implement a simple web page counter. As users visit pages on the website, the counter is updated automatically. You can adjust the counter display as needed to suit your website style.

I hope this article will be helpful to you when developing web page counters using PHP.

The above is the detailed content of How to develop a simple web page counter using PHP. For more information, please follow other related articles on the PHP Chinese website!