Skip to main content

Gym Management System using PHP/MySQLi with Source Code


Project: Gym Management System using PHP/MySQLi


The Gym Management System is a simple PHP/MySQLi project that manages a fitness gym business memberships and payments records. The system stores the fitness gym membership plans, packages, and trainers. The plan list helps organize the member's selected plan for his/her membership with the fitness gym and each plan are one-time payment only, which means the membership fee of the members are based on their selected plan and this refers to how long the member will be marked as an active member in the fitness gym. The packages list refers to the list of packages that the fitness gym management offers to their members and this program of the fitness gym is payable by month until the expiration of the member's membership. The trainer list will be used if the member will hire also a trainer if every trainer is not included in his/her package. The trainer's rate will be added to the monthly amount payable to the member. The membership can be renewed when the fitness gym member's membership plan will expire, which means the member can extend his/her membership, and the gym management system will include the membership fee again to the first-month payment of the member after his/her previous membership expires. The gym management or the system user must end the plan of the member if the member will change his/her membership plan or packages after his/her previous membership plan expires to allow the system to know that the member is not active anymore in any membership plan and packages.


  • Login Page
    • The page where the system users will submit their system credentials to access the gym management system data.
  • Home Page
    • The page where the system users will be redirected by default after logging in.
  • Plan Page
    • The page where the fitness gym membership plans are listed and can be managed.
  • Packages Page
    • The page where the system users will populate the list of the packages they offer to their members.
  • Members Page
    • The page where the fitness gym members are listed and managed.
  • Member Details Modal
    • The popup modal in the member's page that shows the member's details, and active/previous membership plans.
  • Trainers Page
    • The page where the list of fitness gym trainers are listed and managed.
  • Membership Validity Page
    • ​​​​​​​The page where the list of active member's plan are listed and managed.
  • Schedule Page
    • ​​​​​​​The page where can system user schedule or store the expected date of the member's presence. This feature only for the fitness gym management's reference to check the expected members on a certain date.

How to Run

  1. Download the source code and extract the zip file.
  2. Download or set up any local web server that runs PHP script.
  3. Open the web-server database and create a new database name it gym_db.
  4. Import the SQL file located in the database folder of the source code.
  5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
  6. Open a web browser and browse the project. E.g [http://localhost/gym-management-system

Admin Default Access

Username: admin

Password: admin123

I hope the Gym Management System project source code will help you with what you are looking for. Feel free to download and modify the source code.

Explore more on this website for more source codes and tutorials.


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.


Submitted byAsita (not verified)on Sun, 12/20/2020 - 22:01

Dear database working fine. but unable to add user..
Submitted byengmohdon Fri, 01/01/2021 - 12:04


SQL query:


  1. -- --------------------------------------------------------
  3. --
  4. -- Table structure for table `registration_info`
  5. --
  7. CREATE TABLE `registration_info` (
  8. `id` int(30) NOT NULL,
  9. `member_id` int(30) NOT NULL,
  10. `plan_id` int(30) NOT NULL,
  11. `package_id` int(30) NOT NULL,
  12. `start_date` date NOT NULL,
  13. `end_date` date NOT NULL,
  14. `trainer_id` tinyint(30) NOT NULL,
  15. `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=Inactive, 1= Active',
  16. `date_created` date DEFAULT current_timestamp()


MySQL said: Image removed.

#1067 - Invalid default value for 'date_created'

Add new comment