Society Management System using PHP and MySQL

Project Name : Society Management System Project (SMS)

Language Used : PHP

Database : MySQL

User Interface Design : HTML, AJAX,JQUERY,JAVASCRIPT

Web Browser : Mozilla, Google Chrome, IE8, OPERA

Software : XAMPP / Wamp / Mamp/ Lamp (anyone)

In this project, we use PHP and  MySQL database.

The different types of modules present in this project are

1. Admin
2. User

Admin:

1. Dashboard: In this section, admin can see all detail in brief like Total flats, Total bills, Total Allotment, Total Visitor, Unresolved Complain, In progress Complain, Resolved Complain and Total Complain.
2. Flats: In this section, admin can manage flats (Add/Update).
3. Allotment: In this section, admin can manage the allotment (Add/Update).
4. Bills: In this section, the admin can manage bills (Add/Update).
5. View Complain: In this section, the admin can view the complaint of society members and response to the complain and change the status of complaint according to complain status.
6. Visitors: In this section admin, can manage visitors (Add/Update) and visitors manage incoming and outgoing details of visitors.
7. Search: In this section admin, can search allotment of flats and visitors of society by flats number and by name and mobile number of visitors respectively.
8. Reports: In this section admin can view how much allotment has been done in a particular period and also view how many visitor visits in a society in particular periods.

Admin can also update his profile, change the password and recover the password.

User (Society Member):

1. Dashboard: It is a welcome page for society members.
2. View Bill: In this section, user can view his/her own society charges which will be generated by admin per month.
3. Visitor: In this section, user can view detail of the visitor who visited in his/her own flat.
4. Complain: In this section, user can raise the complain and view the complain status which is provided by society admin
5. Search: In this section, user can search visitor who visited in his/her flats
6. Reports: In this section, user can view how many visitors visit a flat in particular periods.

Some Project Screenshots

 

How to run the Society Management System Project (SMS)

1. Download the zip file

2. Extract the file and copy sms folder

3.Paste inside root directory(for xampp xampp/htdocs, for
wamp wamp/www, for lamp var/www/html)

4. Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with name smsdb

6. Import smsdb.sql file(given inside the zip package in SQL
file folder)

7.Run the script http://localhost/sms

Admin Credential

Username: admin

Password: Test@123

User Credential

Mobile No.: 9354778033

Block : A

Flat no.: 201

View Demo——————————————

Project Download Link

---