CREATE DATABASE grad_student_management;
USE grad_student_management;
CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
major VARCHAR(255),
year INT,
email VARCHAR(255)
);
]]>
from flask import Flask, render_template, request
from flask_mysqldb import MySQL
app = Flask(__name__)
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_DB'] = 'grad_student_management'
mysql = MySQL(app)
@app.route('/')
def index():
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM students")
rows = cur.fetchall()
return render_template('index.html', students=rows)
@app.route('/add', methods=['POST'])
def add_student():
name = request.form['name']
major = request.form['major']
year = request.form['year']
email = request.form['email']
cur = mysql.connection.cursor()
cur.execute("INSERT INTO students (name, major, year, email) VALUES (%s, %s, %s, %s)",
(name, major, year, email))
mysql.connection.commit()
return "Student added successfully"
if __name__ == '__main__':
app.run(debug=True)
]]>