app.py

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

app = Flask(__name__)


def db_connection():
    db = mysql.connector.connect(
        host="mysql",
        user="root",
        password="123456",
        database="user_db"
    )

    cursor = db.cursor()

    cursor.execute("""
    CREATE TABLE IF NOT EXISTS users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(100),
        email VARCHAR(100)
    )
    """)
    return [db, cursor]


@app.route("/", methods=["GET", "POST"])
def index():
    if request.method == "POST":
        name = request.form["name"]
        email = request.form["email"]

        [db, cursor] = db_connection()
        cursor.execute(
            "INSERT INTO users (name, email) VALUES (%s, %s)",
            (name, email)
        )
        db.commit()

    return render_template("index.html")


@app.route("/go")
def go():
    return render_template("show.html")


@app.route("/show")
def show():
    [db, cursor] = db_connection()
    cursor.execute("SELECT name, email FROM users")
    data = cursor.fetchall()
    return render_template("show.html", data=data)


app.run(host="0.0.0.0", port=5000)