PHPGurukul Old Age Home Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in the Old Age Home Management System version 1.0. The issue resides in the '/admin/view-enquiry.php' file, where the 'viewid' parameter is manipulated to inject malicious SQL queries. This vulnerability can be exploited remotely, allowing attackers to gain unauthorized access to the database, manipulate or delete data, and disrupt services.

Impact

Exploitation of this vulnerability allows for unauthorized database access, data manipulation or deletion, and potential disruption of services.

Reproduction

The vulnerability can be reproduced by sending a POST request to 'contact.php' with crafted payloads that exploit the SQL injection flaw in the 'fname' parameter. The injection can be verified by using a time-based blind SQL injection technique, such as adding a payload that makes the database wait for a few seconds before responding.

Remediation

To address this vulnerability, it is recommended to implement prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be applied to ensure that user input meets expected formats, blocking malicious data. Finally, database user permissions should be minimized, granting only necessary access rights.