A Flask web app to submit and view school reviews.

✅ Add new school reviews with:

• School Name
• Reviewer Name
• Rating (1–5)
• Comment

✅ View all submitted reviews in a responsive table:

• Bootstrap 5 design
• Mobile-friendly
• Dark header with hover effects

✅ Persistent database storage using:

• MySQL
• SQLAlchemy ORM

• Python 3
• Flask
• Flask-SQLAlchemy
• MySQL
• Bootstrap 5
• HTML / Jinja2 Templates

school_review_app/ │ ├── app.py # Main Flask app ├── config.py # DB configuration ├── .env # Environment variables (DB_URI) ├── requirements.txt # Python dependencies └── templates/ ├── add_review.html # Form to add a review └── reviews.html # View all reviews

git clone https://github.com/simran487/SchoolReviewApp.git
cd SchoolReviewApp

2️⃣ Install Dependencies pip install -r requirements.txt

3️⃣ Setup the Database

✅ Make sure MySQL server is running (e.g. XAMPP, WAMP, Workbench). ✅ Create the database and table in MySQL:

CREATE DATABASE IF NOT EXISTS school_reviews;

USE school_reviews;

CREATE TABLE IF NOT EXISTS reviews ( id INT AUTO_INCREMENT PRIMARY KEY, school_name VARCHAR(100), reviewer_name VARCHAR(100), rating INT, comment TEXT );

4️⃣ .env Configuration

create a .env file with: DB_URI=mysql+mysqlconnector://root:@localhost/school_reviews

Run App

python app.py