How to use PHP and UniApp to implement the browsing history function of data

How to use PHP and UniApp to implement the browsing history function of data

Introduction:
With the rapid development of the mobile Internet, more and more applications are emerging. For users, the browsing history function has become an important and convenient function. This article will introduce how to use PHP and UniApp to implement the browsing history function of data to help developers better meet user needs.

1. Overview
The browsing history function is a function that records the data that users have browsed in the application. By viewing browsing history, users can easily review previously browsed data and quickly locate content of interest. The key to implementing the browsing history function is to store and display the user's browsing history.

2. Use PHP to store browsing history data
PHP is a scripting language widely used in Web development. It can interact with the database and perform operations such as adding, deleting, modifying, and checking data. In implementing the browsing history function, we can use PHP to save the user's browsing history to the database.

1. Create database table
   First, we need to create a database table to store browsing history data. The table structure can be designed according to actual needs, and usually includes the following fields:

id: unique identifier
user_id: user ID, used to associate users with their browsing history
data_id: Browsed data ID
timestamp: browsing timestamp
The following is an example of the SQL statement to create a browsing history table:

CREATE TABLE browse_history (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) NOT NULL,
data_id int(11) NOT NULL,
timestamp int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. Add browsing history
   When a user browses to certain data, we need to add his browsing record to the database. You can use PHP's MySQLi extension to connect to the database and perform insert operations. The sample code is as follows:

//Connect to the database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Check whether the connection is successful
if ($mysqli -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit( );
}

// Get the user ID and browsed data ID
$user_id = $_POST["user_id"];
$data_id = $_POST["data_id"];

// Get the current timestamp
$timestamp = time();

// Insert browsing history
$stmt = $mysqli -> prepare("INSERT INTO browse_history (user_id, data_id, timestamp) VALUES (?, ?, ?)");
$stmt -> bind_param("iii", $user_id, $data_id, $timestamp);
$stmt -> ; execute();
$stmt -> close();

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

3. Use UniApp to display browsing history data
UniApp is a cross-platform development framework based on Vue.js, which can be used to quickly develop multi-terminal applications. In implementing the browsing history function, we can use UniApp to display the user's browsing history.

1. Install the uni-request plug-in
   First, we need to install the uni-request plug-in, which is a plug-in in UniApp for sending HTTP requests. You can search and install uni-request in the UniApp official plug-in market.
2. Get browsing history data
   Before displaying browsing history data, we need to obtain browsing history data from the server. You can use uni-request to send an HTTP request and save the returned data to the data of the Vue instance.

The sample code is as follows:

export default {
data() {

return {
  historyList: []  // 存储浏览历史数据
}

},
mounted() {

this.getHistoryList();

},
methods: {

getHistoryList() {
  uni.request({
    url: 'http://localhost/get_history_list.php',  // 替换为服务器端接口地址
    method: 'GET',
    success: res => {
      this.historyList = res.data;  // 将返回的数据保存到historyList中
    },
    fail: error => {
      console.error(error);
    }
  });
}

}
}

3. Display browsing history data
   Finally, we can use the uni-for instruction to loop through the historyList , and display each piece of browsing history data on the page.

The sample code is as follows:

<view v-for="(item, index) in historyList" :key="index">
  <text>{{ item.data_id }}</text>
  <text>{{ item.timestamp }}</text>
</view>

4. Summary
This article introduces how to use PHP and UniApp to implement the data browsing history function. By saving browsing history data to the database and using UniApp to display the data, it can help developers better implement user needs. Developers can further improve and optimize the browsing history function based on actual conditions to enhance user experience.

The above is the detailed content of How to use PHP and UniApp to implement the browsing history function of data. For more information, please follow other related articles on the PHP Chinese website!