Tenant Directory Management System using PHP/PDO with Source Code

This project is entitled Tenant Directory Management System that was developed using PHP/PDO. The system has a Floor Plan of the specific building that indicates the exact location of the stalls of each tenant of the specific commercial building. The system also processes the tenants' lease payments and electricity bill payments. This project has 3 images of floor plans which are the Ground Floor, Second Floor, and the Wet Market Area. Each stall can be easily identified with its color which the green ones are the stalls that are available/vacant and the red ones are the stalls that have already tenants that renting. The system also generates printable reports.

This system was specifically developed for the Victorias Commercial Center (VCC). The following are the major functions of this system.

1. It has a directory page wherein a color-coded map is displayed. This map shows the occupied stalls of VCC in green color while the vacant stalls are in red color.
2. The TDMS also records the monthly payments of each respective tenant and automatically calculates the remaining balance for the particular month. It also allows the admin to update active and inactive tenants of the building.    
3. The system generates several reports such as the active and inactive tenants, the tenant's previous and current stall location, and the monthly lease payments and electric consumption. The activity log is also established to track all the transactions made by the user.

Features

• Directory
  • Ground Floor
  • Second Floor
  • Wet Market
• Tenants
• Change Tenants Location
• Stalls
• Payments
  • Lease Payments
  • Electric Consumption Bills
• Activity Logs
• Reports
  • Active Tenants
  • Inactive Tenants
  • Electric Consumption
  • Lease Payments
  • Tenants Location
  • Electric Graphical Reports

How to Run

Requirements

• Download and Install any local web server such as XAMPP/WAMP.
• Download the provided source code zip file. (download button is located below)

Installation/Setup

1. Open your XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
2. Extract the downloaded source code file.
3. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
5. Create a new database naming "vccdms".
6. Import the provided SQL file. The file is known as "vccdms.sql" located inside the extracted source code folder.
7. Browse the Tenant Directory Management System in a browser. i.e. http://localhost/vccdms

System Access

Username: admin
Password: admin

Demo

That's it! You can now explore the features and functionalities of this Tenant Directory Management System Project in PHP/PDO. I hope this can help you with your needs and develop/enhance your programming skills using PHP Language.

Enjoy :)