PHP implements the sorting and display functions of question answers in the knowledge Q&A website.

PHP implements the sorting and display function of question answers in the knowledge Q&A website

In the knowledge Q&A website, the sorting and display function of the answer to the question is very important, it can help users quickly find the information they need , and improve user experience. In this article, we will implement these functions by using PHP programming language.

1. Question and answer sorting function

The question and answer sorting function can sort answers according to different sorting criteria, such as sorting by time, popularity or number of likes. Below is an example that shows how to implement the function of sorting from high to low the number of likes.

First, we assume that there is a data table with answers to questions, with the following structure:

CREATE TABLE `answer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `likes` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Next, we can use the following code to get the answers to the questions, and calculate the number of likes from Sort from high to low:

$questionId = 1;

$sql = "SELECT * FROM `answer` WHERE `question_id` = $questionId ORDER BY `likes` DESC";
$result = mysqli_query($conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    echo $row['content'];
    echo "<br>";
}

Through the above code, we first specify the ID of the question to be queried, then use the SELECT statement to get the answer to the question from the database, and use the ORDER BY statement to sort by the number of likes ( The field name is likes) for descending sorting. Finally, we present the answer to the question by iterating over the result set.

2. Question and answer display function

The question and answer display function can display the answers to questions in a certain format, making it easier for users to read and understand. The following is an example that shows how to display the answers to questions in pages.

First, suppose we have a data table of question answers, and assume that 10 answers are displayed on each page:

CREATE TABLE `answer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Next, we can use the following code to implement the paging display function of question answers ：

$questionId = 1;
$page = 1;
$pageSize = 10;

$start = ($page - 1) * $pageSize;

$sql = "SELECT * FROM `answer` WHERE `question_id` = $questionId LIMIT $start, $pageSize";
$result = mysqli_query($conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    echo $row['content'];
    echo "<br>";
}

Through the above code, we first specify the ID of the question to be queried, and then specify the number of pages to be displayed and the number of answers displayed on each page through the $page and $pageSize variables. We calculate the starting position $start and use the LIMIT statement to obtain the answers to the specified number of pages of questions from the database. Finally, we present the answer to the question by iterating over the result set.

Summary:

This article demonstrates the implementation of the question answer sorting and display functions by using the PHP programming language. Whether it is sorting answers according to different sorting criteria or implementing paged display of question answers, it can improve the efficiency and experience of users in finding the information they need in the knowledge Q&A website. By referring to the code examples in this article, you can make corresponding modifications and extensions according to project needs to achieve more interesting functions.

The above is the detailed content of PHP implements the sorting and display functions of question answers in the knowledge Q&A website.. For more information, please follow other related articles on the PHP Chinese website!