app.py

from flask import Flask, render_template, request, redirect, url_for, flash
from flask_mysqldb import MySQL

app = Flask(__name__)

app.config["MYSQL_HOST"] = "localhost"
app.config["MYSQL_USER"] = "root"
app.config["MYSQL_PASSWORD"] = "1234mpgd"
app.config["MYSQL_DB"] = "crud_app"

mysql = MySQL(app)


@app.route("/")
def Index():  # put application's code here
    cur = mysql.connection.cursor()
    cur.execute("SELECT * FROM students")
    data = cur.fetchall()
    cur.close()

    return render_template("index.html", students=data)


@app.route("/insert", methods=["POST"])
def insert():
    if request.method == "POST":
        name = request.form["name"]
        email = request.form["email"]
        phone = request.form["phone"]
        cur = mysql.connection.cursor()
        cur.execute(
            "INSERT INTO students (name, email, phone) VALUES (%s, %s, %s)",
            (name, email, phone),
        )
        mysql.connection.commit()
        return redirect(url_for("Index"))


@app.route("/delete/<string:id_data>", methods=["GET"])
def delete(id_data):
    cur = mysql.connection.cursor()
    cur.execute("DELETE FROM students WHERE id=%s", (id_data,))
    mysql.connection.commit()
    flash("Record has been deleted successfully")
    return redirect(url_for("Index"))


@app.route("/update", methods=["POST", "GET"])
def update():
    if request.method == "POST":
        id_data = request.form["id"]
        name = request.form["name"]
        email = request.form["email"]
        phone = request.form["phone"]
        cur = mysql.connection.cursor()
        cur.execute(
            """
            UPDATE students
            SET name=%s, email=%s, phone=%s
            WHERE id=%s
        """,
            (name, email, phone, id_data),
        )
        flash("Data Updated Successfully")
        mysql.connection.commit()
        return redirect(url_for("Index"))


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


# to run the app in debug mode, run ```flask --app app.py --debug run``` in the terminal