How to develop a simple online question and answer system using MySQL and Python

How to use MySQL and Python to develop a simple online question and answer system

In recent years, with the rapid development of the Internet, intelligent technology has gradually been widely used in various fields. As one of the important means of human-computer interaction, online question and answer system has been paid attention to and used by more and more people. This article will introduce how to use MySQL and Python to develop a simple online question and answer system, and provide specific code examples.

1. Environment configuration
Before development, we need to perform some environment configuration. First, you need to install the MySQL database and create a database to store question and answer information. Secondly, you need to install Python's MySQL library for connecting and operating the MySQL database. Finally, we also need to install the Python Flask library for developing web applications.

2. Database design
Before we start writing code, we need to design a suitable database structure to store question and answer information. A simple question and answer system contains at least two tables: one for storing question information and one for storing answer information. The following is a simplified database structure design example:

1. Questions table (questions):

   • id: question ID
   • title: question Title
   • content: Question content
   • create_time: Question creation time

2. Answers:

   • id: answer ID
   • question_id: question ID
   • content: answer content
   • create_time: answer creation time

3. Code Implementation
Next, we start writing code to implement a simple online question and answer system. First, we need to import the necessary libraries and make a database connection:

import mysql.connector
from flask import Flask, request, jsonify

app = Flask(__name__)

# 连接MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="root",
    password="123456",
    database="qa_system"
)

Then, we create an interface for getting a list of questions:

@app.route("/questions", methods=["GET"])
def get_questions():
    cursor = db.cursor()
    cursor.execute("SELECT * FROM questions")
    questions = cursor.fetchall()

    results = []
    for row in questions:
        question = {
            "id": row[0],
            "title": row[1],
            "content": row[2],
            "create_time": row[3]
        }
        results.append(question)

    return jsonify(results)

Next, we create an interface for posting questions Interface:

@app.route("/questions", methods=["POST"])
def create_question():
    data = request.json
    title = data["title"]
    content = data["content"]

    cursor = db.cursor()
    cursor.execute("INSERT INTO questions (title, content) VALUES (%s, %s)", (title, content))
    db.commit()

    return jsonify({"message": "Question created"})

Finally, we create an interface for obtaining a list of answers to specified questions:

@app.route("/questions/<int:question_id>/answers", methods=["GET"])
def get_answers(question_id):
    cursor = db.cursor()
    cursor.execute("SELECT * FROM answers WHERE question_id = %s", (question_id,))
    answers = cursor.fetchall()

    results = []
    for row in answers:
        answer = {
            "id": row[0],
            "question_id": row[1],
            "content": row[2],
            "create_time": row[3]
        }
        results.append(answer)

    return jsonify(results)

4. Run the test
After writing the code, we can run the test to Verify that the system is working properly. First, we need to start the Flask application:

if __name__ == "__main__":
    app.run()

Then, we can use tools such as Postman to test the interface we created. For example, you can use the GET method to request the /questions interface to obtain a list of questions, use the POST method to request the /questions interface to post questions, and use the GET method to request the /questions/<question_id> The /answers</question_id> interface obtains a list of answers to a specified question.

Through the above steps, we have successfully developed a simple online question and answer system using MySQL and Python.

Summary
This article introduces how to use MySQL and Python to develop a simple online question and answer system, and provides specific code examples. Of course, this is just a simple example, and the actual online question and answer system still has many functions and details that need to be considered and improved. I hope this article will be helpful to people who are new to the development of online question and answer systems and can be used as a starting point for more complex and complete development work.

The above is the detailed content of How to develop a simple online question and answer system using MySQL and Python. For more information, please follow other related articles on the PHP Chinese website!