For every school important task for administration department is to manage student information in a procedure oriented manner with latest updates for every year which need to be available for easy access. This can be provided by a simple Students Management system to help administration so to efficiently manage student’s details. To store data MySQL is used by connecting MySQL with Python using MySQL Connector. There is also a Login Panel where now admin can register themselves and can Login.
pip install mysql- Login and Register
- Adding New Student
- Viewing Students
- Searching Student
- Updating Student
- Deleting Student
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | varchar(50) | YES | NULL | ||
| password | varchar(100) | YES | NULL |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| sch_no | int | NO | PRI | NULL | |
| name | varchar(100) | YES | NULL | ||
| class | varchar(50) | YES | NULL | ||
| fee_status | varchar(100) | YES | NULL | ||
| age | int | YES | NULL | ||
| varchar(150) | YES | NULL | |||
| phone | varchar(150) | YES | NULL |
To deploy this project just run .py files.