App.py

from flask import Flask, render_template, request, redirect, url_for, flash
from flask_sqlalchemy import SQLAlchemy




app = Flask(__name__)
app.secret_key = "Secret Key"

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:''@localhost/crud'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

db = SQLAlchemy(app)


class Data(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100))
    email = db.Column(db.String(100))
    phone = db.Column(db.String(100))



    def __init__(self, name, email, phone):
        self.name = name
        self.email = email
        self.phone = phone





@app.route('/')
def Index():
    all_data = Data.query.all()

    return render_template("index.html",employees = all_data)

@app.route('/insert',methods = ['POST'])
def insert():

    if request.method == 'POST':

        name = request.form['name']
        email = request.form['email']
        phone = request.form['phone']

        my_data = Data(name,email,phone)
        db.session.add(my_data)
        db.session.commit()

        flash("Employee Inserted Sucessfully")




        return redirect(url_for('Index'))

    @app.route('/update',methods = ['GET','POST'])
    def update():

        if request.method == 'POST':
            my_data = Data.query.get(request.form.get('id'))

            my_data.name =  request.form['name']
            my_data.email = request.form['email']
            my_data.phone = request.form['phone']

            db.session.commit()
            flash("Employee Upated Sucessfully")

            return redirect(url_for('Index'))


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