A full-stack web application to manage classrooms, schedules, and availability with role-based access (Admin & Faculty).
- 🔐 User Authentication (Admin & Faculty)
- 🏫 Classroom Management (Add, View, Delete)
- 📅 Schedule Management with Conflict Detection
- ⏱️ Real-time Room Availability Check
- 👨🏫 Faculty-specific dashboard (limited access)
- 💾 Persistent storage using MySQL
- 🌐 Frontend-Backend Integration using REST APIs
Frontend:
- HTML
- CSS
- JavaScript
Backend:
- Python (Flask)
Database:
- MySQL
SE PROJECT/
├── backend/
│ ├── app.py
│ ├── config.py
│ ├── requirements.txt
│ ├── controllers/
│ ├── models/
│ ├── routes/
│ ├── utils/
│ └── database/
├── frontend/
│ ├── index.html
│ ├── dashboard.html
│ ├── style.css
│ └── js/
- Admin: username:
admin, password:admin - Faculty: username:
faculty1, password:faculty1
- Make sure MySQL service is running
- Check if the user credentials in
.envmatch what you created - Try connecting manually:
mysql -u classroom_user -p(password: classroom123)
If port 5000 is busy:
- Kill the process:
netstat -ano | findstr :5000 - Or change the port in
backend/app.py
- Make sure you're in the virtual environment
- Install missing packages:
pip install -r backend/requirements.txt
- ✅ User authentication (admin/faculty)
- ✅ Classroom management
- ✅ Schedule creation with conflict detection
- ✅ Availability checking
- ✅ Permanent data storage with MySQL
- ✅ Responsive web interface
- All CRUD operations for classrooms and schedules
- User authentication
- Conflict detection for overlapping schedules
- Data persistence across server restarts
- Complete frontend-backend integration
Your classroom scheduling system is now fully functional with permanent data storage! 🎉 FLUSH PRIVILEGES; EXIT;
4. **Update `.env` file:**
```env
DB_USER=classroom_user
DB_PASSWORD=classroom123
- Test and setup:
python test_connection.py python setup_database.py
-
Install dependencies:
cd backend pip install -r requirements.txt -
Configure MySQL:
- Edit
backend/.envwith your MySQL credentials - Test connection:
python test_connection.py
- Edit
-
Setup database:
python setup_database.py
-
Run the application:
python app.py
-
Open frontend:
- Open
frontend/index.htmlin browser
- Open
- Admin: username:
admin, password:admin - Faculty: username:
faculty1, password:faculty1
-
Clone or download the project
cd backend -
Install Python dependencies
pip install -r requirements.txt
-
Configure MySQL Database
Copy the environment template:
cp .env.example .env
Edit
.envfile with your MySQL settings:DB_HOST=localhost DB_USER=your_mysql_username DB_PASSWORD=your_mysql_password DB_NAME=classroom_scheduler DB_PORT=3306
-
Setup Database
Run the database setup script:
python setup_database.py
This will:
- Create the
classroom_schedulerdatabase - Create all necessary tables
- Insert default users
- Create the
-
Start the Flask backend:
python app.py
-
Open the frontend:
- Open
frontend/index.htmlin your web browser - Or serve the frontend files with a web server
- Open