Chat record search and search result display in PHP real-time chat system

Chat record search and search result display in PHP real-time chat system

Introduction:
With the prevalence of social networks and the popularity of online communication, real-time chat Systems have become an essential part of people's daily lives and work. The basic function of a real-time chat system is to allow users to chat in real time, but with the increase in chat records, how to quickly and accurately find previous chat records has become a necessary function.

This article will introduce how to implement the search of chat records and the display of search results in the PHP real-time chat system, and provide relevant code examples.

1. Database design
Before implementing chat record search, you first need to design a suitable database table structure. A common chat record table structure can include the following fields:

1. chat_id: the unique identifier of the chat record
2. sender: sender
3. receiver: receiver
4. message: message content
5. timestamp: sending timestamp

2. Implementation of search function

1. User interface
   First, a search box and a search button need to be added to the user interface. Users can enter keywords in the search box and then click the search button to trigger the search function.

   <form action="search.php" method="post">
     <input type="text" name="keyword" placeholder="输入关键词">
     <input type="submit" value="搜索">
   </form>

2. Backend code
   Create the search.php file to handle search requests and connect to the database.

// 连接数据库
$host = 'localhost';
$dbname = 'chat_system';
$username = 'root';
$password = '';

try {
  $conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
  echo "数据库连接失败: " . $e->getMessage();
}

// 获取用户输入的关键词
$keyword = $_POST['keyword'];

// 构建SQL查询语句
$sql = "SELECT * FROM chat_records WHERE message LIKE :keyword";
$query = $conn->prepare($sql);
$query->bindValue(':keyword', '%' . $keyword . '%');
$query->execute();

// 获取搜索结果
$results = $query->fetchAll(PDO::FETCH_ASSOC);

// 显示搜索结果
foreach ($results as $result) {
  echo $result['sender'] . ' ' . $result['message'] . '<br>';
}

In the above code, first connect to the database; then obtain the keywords entered by the user; then construct a SQL query statement and use the LIKE statement to fuzzy search chat records containing keywords; and finally traverse the search results Display search results.

3. Display of search results
When the user clicks the search button, it will jump to the search.php page and display the search results. The following is a sample code for displaying search results:

<?php if (count($results) > 0): ?>
  <?php foreach ($results as $result): ?>
    <div class="search-result">
      <p><?php echo $result['sender']; ?>: <?php echo $result['message']; ?></p>
      <p><?php echo $result['timestamp']; ?></p>
    </div>
  <?php endforeach; ?>
<?php else: ?>
  <p>没有找到相关的聊天记录。</p>
<?php endif; ?>

In the above code, first determine whether the number of search results is greater than 0. If it is greater than 0, it will traverse and display the search results; if it is equal to 0, it will display "No related chat found" Record".

Conclusion:
Through the above steps, we can realize the chat record search and search results display functions in the PHP real-time chat system. Users can search previous chats quickly and accurately. Of course, this is just an example of a basic implementation, and you can adjust and improve it according to your needs.

The above is the detailed content of Chat record search and search result display in PHP real-time chat system. For more information, please follow other related articles on the PHP Chinese website!