Home > Article > Backend Development > PHP implements the question list display function in the knowledge question and answer website.
PHP implements the question list display function in the knowledge question and answer website.
- 王林Original
- 2023-07-02 14:39:071370browse
PHP implements the question list display function in the knowledge Q&A website
As a developer of the knowledge Q&A website, we often need to implement the question list display function. This function allows users to quickly browse and search existing problems, improving user experience and service efficiency. In this article, I will introduce how to use PHP to achieve this functionality.
First, we need to create a question list page so that users can browse questions on this page. You can use HTML and CSS to build the basic structure and style of your page. Here is a simple example:
<!DOCTYPE html>
<html>
<head>
<title>问题列表</title>
</head>
<body>
<h1>问题列表</h1>
<ul>
<li><a href="question.php?id=1">问题1</a></li>
<li><a href="question.php?id=2">问题2</a></li>
<li><a href="question.php?id=3">问题3</a></li>
<li><a href="question.php?id=4">问题4</a></li>
<!-- 添加更多问题 -->
</ul>
</body>
</html>In the above code, we used the ul and li tags to create an unordered list. Each list item is the title of a question and uses a hyperlink (3499910bf9dac5ae3c52d5ede7383485 tag) connects each question to the corresponding question details page (question.php). In the href attribute of the hyperlink, specify the unique identifier of the question by passing the parameter id.
Next, we need to create a question details page (question.php) to display the detailed information of the question clicked by the user. In this page, we need to query the database based on the passed id parameter and display the title and content of the question. Here is a simple example:
<?php // 获取传递的问题id参数 $id = $_GET['id']; // 连接数据库 $dbHost = 'localhost'; $dbUser = 'username'; $dbPassword = 'password'; $dbName = 'database_name'; $conn = mysqli_connect($dbHost, $dbUser, $dbPassword, $dbName); // 查询问题信息 $query = "SELECT * FROM questions WHERE id = $id"; $result = mysqli_query($conn, $query); $row = mysqli_fetch_assoc($result); // 显示问题标题和内容 echo '<h1>'.$row['title'].'</h1>'; echo '<p>'.$row['content'].'</p>'; ?>
In the above code, we first get the passed question id parameter and connect to the database. Then, by executing the SQL query statement, the information corresponding to the question is obtained from the questions table, and the result is saved in an associative array. Finally, use PHP's echo statement to display the title and content of the question on the web page.
It should be noted that the database connection information in the above code needs to be configured and changed according to the actual situation to ensure that the database can be successfully connected.
To sum up, through the above HTML and PHP code examples, we can realize the display function of the question list in the knowledge Q&A website. Users can browse questions on the question list page and jump to the corresponding question details page to view detailed information by clicking on the question title. In this way, users can more easily access and search existing questions, improving the usability and user experience of the website.
The above is the detailed content of PHP implements the question list display function in the knowledge question and answer website.. For more information, please follow other related articles on the PHP Chinese website!