User rating and friend recommendation function of real-time chat system based on PHP

User ratings and friend recommendation functions of real-time chat system based on PHP

With the development of the Internet, real-time chat systems play an increasingly important role in our daily lives important role. In this era of information explosion, people hope to communicate with friends, family and colleagues in a timely manner through chat systems. In order to improve user experience, a good real-time chat system not only needs to have basic chat functions, but also should be equipped with user ratings and friend recommendation functions.

The user rating function allows users to evaluate their friends during the chat process, thereby helping other users choose suitable chat partners. There are many ways to implement the user rating function. This article will use PHP as the development language and MySQL as the database to demonstrate.

First, we need to create a user rating table. The table structure is as follows:

CREATE TABLE `user_ratings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `friend_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
);

In this table, user_id represents the ID of the rating user, friend_id represents the ID of the rated user, and rating represents the rating value. Next, we can add a rating button to the chat system and provide users with a rating interface.

<button onclick="rateUser()">评分</button>
<script>
  function rateUser() {
    var friendId = prompt("请输入要评分的好友ID：");
    var rating = prompt("请输入评分值：");
    // 使用Ajax将评分信息发送到后台进行处理
    // 代码省略
  }
</script>

After clicking the rating button, a dialog box pops up allowing the user to enter the friend ID and rating value to be rated. This information is then sent to the background for processing using Ajax. Behind the scenes, we can use PHP to process this rating information and store it in a database.

<?php
$friendId = $_POST['friendId'];
$rating = $_POST['rating'];

// 将评分信息插入到数据库中
$conn = new mysqli("localhost", "username", "password", "database");
$stmt = $conn->prepare("INSERT INTO user_ratings (user_id, friend_id, rating) VALUES (?, ?, ?)");
$stmt->bind_param("iii", $_SESSION['user_id'], $friendId, $rating);
$stmt->execute();
$stmt->close();
$conn->close();
?>

In this way, users can rate their friends by clicking a button. Based on this rating information, we can also implement the friend recommendation function.

The friend recommendation function can recommend suitable chat partners based on the user's rating information and other relevant data. In actual development, we can use data mining algorithms to recommend friends based on user ratings, interests and hobbies.

Here, we demonstrate a simple friend recommendation algorithm, which can recommend friends based on the user's rating information and the number of common friends.

<?php
$userId = $_SESSION['user_id'];

// 获取用户评分数据
$conn = new mysqli("localhost", "username", "password", "database");
$stmt = $conn->prepare("SELECT friend_id, AVG(rating) as avg_rating FROM user_ratings WHERE user_id = ? GROUP BY friend_id");
$stmt->bind_param("i", $userId);
$stmt->execute();
$result = $stmt->get_result();

$ratings = array();
while ($row = $result->fetch_assoc()) {
  $ratings[$row['friend_id']] = $row['avg_rating'];
}

$result->close();
$stmt->close();

// 获取共同好友数量
$stmt = $conn->prepare("SELECT friend_id, COUNT(*) as common_friends FROM friends WHERE user_id = ? GROUP BY friend_id");
$stmt->bind_param("i", $userId);
$stmt->execute();
$result = $stmt->get_result();

$commonFriends = array();
while ($row = $result->fetch_assoc()) {
  $commonFriends[$row['friend_id']] = $row['common_friends'];
}

$result->close();
$stmt->close();
$conn->close();

// 根据评分和共同好友数量进行推荐
$recommendedFriends = array();
foreach ($ratings as $friendId => $rating) {
  if (isset($commonFriends[$friendId])) {
    $score = $rating * $commonFriends[$friendId];
    $recommendedFriends[$friendId] = $score;
  }
}

arsort($recommendedFriends);

foreach ($recommendedFriends as $friendId => $score) {
  // 输出推荐结果
  echo "好友ID：" . $friendId . "，推荐分数：" . $score . "<br>";
}
?>

Through this simple recommendation algorithm, we can recommend suitable chat partners based on the user's rating and the number of mutual friends.

To sum up, the user rating and friend recommendation function of the PHP-based real-time chat system can store the user's rating information through the database, and use a simple algorithm to make recommendations based on the rating and the number of common friends. Of course, this is just a simple example and can be improved and expanded according to needs during actual development.

The above is the detailed content of User rating and friend recommendation function of real-time chat system based on PHP. For more information, please follow other related articles on the PHP Chinese website!