kay-23 / dbms-project-php Goto Github PK

A way to revolutionalize hostel permission system, saving time for everyone!
Explore the docs »

View Files · Report Bug · Request Feature

Colleges and most private schools have in-campus hostels. Most possess an improper method of storing and managing their inmates’ data. Moreover, these institutions impose a curfew on the female students residing in their hostels. The rule has, therefore, led to the initiation of permissions. Thus, female students need to attain permissions to leave hostel premises during weekends, obtain approval for escorting first-year girls to on-campus events and for extension of curfew times for girls in cultural or sports teams.

The current system to get permission for leave in the LH requires students to manually submit their applications to the RT well in advance. Later, it is verified with a message from the parent. Finally, the permission is approved by the Warden. Also, copies of the same have to be submitted in the LH Office and LH gate before being permitted to leave. Permissions for fests or on any other occasion, which requires the inmate to stay out of the hostel for an extended time, requires a similar procedure.

The above system is not hassle-free and creates a miserable hostel life for many inmates. Hence, it has led to an increase in the number of individuals who have moved into rented apartments over the past years.

Implementation of a DBMS would contribute greatly to making inmates’ lives easier.

• Pure CSS
• Javascript
• JQuery
• HTML
• PHP
• Python
• AJAX

1. PHP and mySQL for Database Management

2. JS, Jquery and AJAX were implemented through HTML headers.

3. PHPmyadmin for GUI management of the Database.

1. Run the following commands to install PHP, mysql and PHPmyadmin

sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl
sudo apt install mysql-server

2. Clone the repo

git clone https://github.com/kay-23/DBMS-Project-PHP.git

3. Create a database in mySQL called hostel and run the following command to get the table

mysql -u [user] -p hostel < hostel2.sql

4. Change the username and password inside /includes/db.config.php and /includes/db_connection.inc.php

1. In order to start the php server, run the following command inside the repository.

php -S localhost:8000

2. Then proceed to the login page by entering the following URL into your browser.

localhost:8000/login-student.php

3. The rest is GUI assisted. In order to go back to the login page, simply type the URL again.

Distributed under the MIT License. See LICENSE for more information.

Dev Sony - @HotMonkeyWings - [email protected]

Soujanya Namburi - @soujanyanmbri - [email protected]

Sreelakshmi K - @kay-23 - [email protected]

Emily Eldose - [email protected]

Adil Chery - [email protected]

• Img Shields
• Choose an Open Source License
• GitHub Pages
• Font Awesome