How to use PHP to develop the access statistics module in CMS

With the development of the Internet, more and more websites require a complete content management system (CMS) to manage and maintain site content. The access statistics module is one of the very important components of CMS. This module can help website administrators understand the access status of the site in order to better understand the needs of website users and improve the operation quality of the website. In this article, I will introduce how to use PHP to develop the access statistics module in CMS.

1. Database design

First, we need to design a database table to store the website access data. This table has the following fields:

• id: auto-increment primary key
• date: date
• pageviews: page views
• visitors : Number of visitors
• new_visitors : Number of new visitors

The following is the SQL code for this table:

CREATE TABLE access_statistics (
id int(11) NOT NULL AUTO_INCREMENT,
date date NOT NULL,
pageviews int(11) NOT NULL,
visitors int(11) NOT NULL,
new_visitors int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

2. Statistical code implementation

After designing the database table, we need to write code to count access data and store the data into the database.

In CMS, we usually have an entry file for processing page requests, such as index.php. We can write the statistics code in this file. Specifically, we need to add the following code to index.php:

// Connect to the database
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Get the visitor’s IP address
$ip = $_SERVER['REMOTE_ADDR'];

// Determine whether it is a new visitor
$sql = "SELECT * FROM access_log WHERE ip = '$ip'";
$result = $conn->query($sql);
if ($result->num_rows == 0) {

$new_visitor = 1;

} else {

$new_visitor = 0;

}

// Record access data
$sql = "INSERT INTO access_statistics (date, pageviews, visitors, new_visitors)
VALUES (CURDATE( ), 1, 1, $new_visitor)
ON DUPLICATE KEY UPDATE pageviews = pageviews 1,
visitors = visitors 1,
new_visitors = new_visitors $new_visitor";
$conn->query($sql);

// Close the database connection
$conn->close();

In the above code, we first connect to the database and obtain the IP address of the current visitor. Then, we query the database based on the IP address to determine whether it is a new visitor. If it is a new visitor, set the value of $new_visitor to 1, otherwise set to 0.

Finally, we insert a piece of access data into the database. If there is already corresponding access data for this date, just add 1 to the page views, number of visitors, and number of new visitors respectively.

3. Data display

After completing the data statistics, we need to display the statistical data in the background of the CMS so that the website administrator can view it.

First, we need to write a PHP file to query the statistical data in the database. The code is as follows:

//Connect to the database
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = " your_database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

//Query data
$sql = "SELECT * FROM access_statistics ORDER BY date DESC LIMIT 30";
$result = $conn->query( $sql);

// Store data in an array
$data = array();
while ($row = $result->fetch_assoc()) {

$date = date("Y-m-d", strtotime($row["date"]));
$pageviews = $row["pageviews"];
$visitors = $row["visitors"];
$new_visitors = $row["new_visitors"];
$data[] = array("date"=>$date, "pageviews"=>$pageviews, "visitors"=>$visitors, "new_visitors"=>$new_visitors);

}

//Output JSON data
echo json_encode($data);

//Close the database connection
$conn->close();

In the above code, we query the data of the last 30 days in the access statistics table and store the data in a PHP array. Then, we convert the array into JSON format and output it so that the front-end page can call the interface to obtain the data.

Next, we can write an HTML page to display the data. This page needs to include a chart to display information such as the number of visits, the number of visiting users, and the number of new users. We can use some popular front-end frameworks such as Bootstrap and jQuery to quickly build this page.

Specifically, we can use open source chart libraries such as Chart.js to implement charts, and use the ajax method in jQuery to call the PHP interface written above to obtain data.

4. Summary

Through the above steps, we can complete a simple access statistics module so that website administrators can better understand the access status of the site. Of course, this is just a simple example. You can improve the code according to your actual needs, such as increasing the traffic statistics of different pages and other functions.

The above is the detailed content of How to use PHP to develop the access statistics module in CMS. For more information, please follow other related articles on the PHP Chinese website!