PHPGurukul Curfew e-Pass Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in PHPGurukul's Curfew e-Pass Management System version 1.0. The issue arises in the file '/admin/pass-bwdates-reports-details.php', where the 'fromdate' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, potentially affecting other parameters as well.

Impact

Exploitation of this vulnerability allows unauthorized access to the database, where attackers can leak, modify, or delete data. Additionally, it could lead to unauthorized database access, sensitive data leakage, data tampering, comprehensive system control, and service interruption.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/admin/pass-bwdates-reports-details.php' with the 'fromdate' parameter. The injected SQL payload can be crafted to exploit the time-based blind SQL injection vulnerability, using a payload that, for example, includes a SQL injection payload that causes the database to pause for a few seconds before responding. This indicates that the injection was successful, as the database processed the malicious SQL query.

Remediation

To address this vulnerability, it is recommended to use prepared statements and parameter binding to prevent SQL injection. Input validation and filtering should be implemented to ensure user input conforms to expected formats. Additionally, database user permissions should be minimized, granting only necessary access rights, and regular security audits should be conducted to identify and fix potential vulnerabilities.