How to develop a simple Q&A community function using PHP

How to use PHP to develop a simple Q&A community function

As a very popular server-side scripting language, PHP is popular for developing web applications. This article will introduce how to use PHP to develop a simple Q&A community function and provide specific code examples.

First, we need to create a database to store information such as users, questions and answers. We can use MySQL as our database management system. The following is the SQL statement to create a database named qa_community:

CREATE DATABASE qa_community;

Next, we need to create three tables to store user, question and answer information. The following are the SQL statements to create these tables:

CREATE TABLE users(

id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
password VARCHAR(255) NOT NULL

);

CREATE TABLE questions(

id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
description TEXT NOT NULL,
user_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES users(id)

);

CREATE TABLE answers(

id INT AUTO_INCREMENT PRIMARY KEY,
answer_text TEXT NOT NULL,
user_id INT NOT NULL,
question_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES users(id),
FOREIGN KEY (question_id) REFERENCES questions(id)

);

Next, we need to create a page to display the list of questions and provide a form to submit questions. The following is a basic PHP code example:

// First, the code that contains the database connection
$conn = mysqli_connect("localhost", "username", "password" , "qa_community");
if (!$conn) {

die("数据库连接失败：" . mysqli_connect_error());

}

// Get the question list
$query = "SELECT * FROM questions";
$result = mysqli_query($conn, $query);

//Display question list
if (mysqli_num_rows($result) > 0) {

while ($row = mysqli_fetch_assoc($result)) {
    echo "<h2>".$row['title']."</h2>";
    echo "<p>".$row['description']."</p>";
    echo "<hr>";
}

} else {

echo "暂无问题";

}

// Display the form to submit a question
echo "

Submit a question

//Close the database connection
mysqli_close($conn);
?>

The above code creates a simple page that displays the problem list and a form to submit a question. Users can fill in the title and issue description and click the submit button to post the issue.

Next, we need to create a file called submit_question.php to process the submitted question and save it to the database. The following is a basic PHP code example:

// First, the code that contains the database connection
$conn = mysqli_connect("localhost", "username", "password" , "qa_community");
if (!$conn) {

die("数据库连接失败：" . mysqli_connect_error());

}

// Get the submitted question title and description
$title = $_POST['title '];
$description = $_POST['description'];

//Insert questions into the database
$query = "INSERT INTO questions (title, description, user_id) VALUES ('$ title', '$description', 1)";
$result = mysqli_query($conn, $query);

// Display corresponding information according to the insertion result
if ($result) {

echo "问题提交成功";

} else {

echo "问题提交失败：" . mysqli_error($conn);

}

//Close the database connection
mysqli_close($conn);
?>

The above code inserts the received question title and description into the questions table, and displays the corresponding information based on the insertion results.

Through the above code example, we can implement a simple Q&A community function. Users can browse questions, submit questions and view answers to questions. Of course, this is only a very basic implementation. In order to make it more complete, functions such as user authentication, answering questions, and searching for questions need to be added.

The above is the detailed content of How to develop a simple Q&A community function using PHP. For more information, please follow other related articles on the PHP Chinese website!