Codezips Gym Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in Codezips Gym Management System version 1.0. The issue resides in the 'm_id' parameter of the '/dashboard/admin/submit_payments.php' file. This vulnerability allows remote attackers to inject arbitrary SQL code, potentially leading to unauthorized database access, data manipulation, and full system compromise.

Impact

Exploitation of this vulnerability could result in a database compromise, allowing attackers to read, modify, or delete data. There is also a risk of leaking sensitive customer and payment information, interrupting system performance, and escalating privileges for broader system control.

Reproduction

The vulnerability can be reproduced by sending a request to the '/dashboard/admin/submit_payments.php' endpoint with a crafted 'm_id' parameter that includes SQL injection payloads. This can be done using tools like sqlmap, which automates the process of finding and exploiting SQL injection vulnerabilities.

Remediation

To address this vulnerability, it is recommended to use prepared statements or parameter binding to separate SQL logic from user input, enforce strict input validation on the 'm_id' parameter, apply the principle of least privilege for database user accounts, and schedule regular security audits to identify and fix vulnerabilities.