File Tracker Manager System using PHP/MySQLi with Source Code


This a File Tracker Manager System that is designed for the Tanzania Revenue Authority for the purpose of monitoring taxpayers' files. The reason why we created this system was due to the loss of taxpayer files either by employees or misplacement of the file. File Tracker Manager has 3 access levels which are the Administrator, Register, and the Normal User. The Admin is the user who is in charge of enrolling users and password management. The admin can also view and print reports in this system. The Register accepts borrow and return requests of files and adds new files and searches for files. The normal user who borrows and returns files into the system.



  • Manage System Users
  • View User Logs
  • Manage Password
  • View/Print Reports
  • List of Online staff/users


  • Manage Borrow Requests
  • Manage Return Requests
  • Manage Files
  • View List of Borrowed Files
  • View Lis of Available Files
  • Search/Track Files


  • Borrow Files
  • Return Files
  • List of Files that in Possession
  • List of Pending Borrow/Return Requests.
  • Borrow History

This Web Application was originally written in PGP MySQL and now updated to PHP MySQLi so this project can run smoothly in the latest version of PHP. The File Track Manager System was developed using PHP, MySQL Database, MySQLi, HTML, CSS, and JavaScript. To run this project follow the instructions below.

How to Run


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


  1. Extract the source code zip file.
  2. Open the XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
  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. Open a web browser and browse the PHPMyadmin. (http://localhost/phpmyadmin)
  5. Create a new database naming "tra".
  6. Import the provided SQL file provided along with the source code. The file is known as "tra.sql" and located in the "database" folder of the extracted source code folder.
  7. Open a new window/tab in your browser and browse the Web Application. i.e. (http:/localhost/file_manager)

Sample Access

Username: mbarouk.ussi
Password: 12345

Username: faiz.nassor
Password: faiz

Username: juma.ndihagule
Password: 12345


That's it! I hope this File Tracker Manager System in PHP/MySQLi will help you with what you are looking for. For any query please contact me thru WhatsApp +25577210820 and [email protected]

Enjoy and learn from my work. Don't use it. Learn from it. :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Whenever I try to enter the script This message comes out of Login Failed Please Check your username and Password

Add new comment

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
10 + 4 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.