mysql如何创建接口

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建一个简单的GET接口
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
    $sql = "SELECT * FROM table_name";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $rows = array();
        while($row = $result->fetch_assoc()) {
            $rows[] = $row;
        }
        echo json_encode($rows);
    } else {
        echo "0 结果";
    }
} else {
    echo "无效的请求方法";
}

$conn->close();
?>

const express = require('express');
const mysql = require('mysql');

const app = express();
const port = 3000;

// 创建MySQL连接
const connection = mysql.createConnection({
    host: 'localhost',
    user: 'username',
    password: 'password',
    database: 'database_name'
});

connection.connect((err) => {
    if (err) throw err;
    console.log('连接到MySQL数据库');
});

// 创建一个简单的GET接口
app.get('/api/data', (req, res) => {
    const sql = 'SELECT * FROM table_name';
    connection.query(sql, (err, results) => {
        if (err) throw err;
        res.json(results);
    });
});

app.listen(port, () => {
    console.log(`服务器运行在 http://localhost:${port}`);
});

from flask import Flask, jsonify
import mysql.connector

app = Flask(__name__)

# 创建MySQL连接
mydb = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

@app.route('/api/data', methods=['GET'])
def get_data():
    cursor = mydb.cursor(dictionary=True)
    cursor.execute("SELECT * FROM table_name")
    result = cursor.fetchall()
    return jsonify(result)

if __name__ == '__main__':
    app.run(debug=True)