PHPGurukul Online Fire Reporting System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in PHPGurukul Online Fire Reporting System version 1.2. The issue resides in the file '/admin/bwdates-report-result.php', where the 'fromdate' and 'todate' parameters are manipulated to inject malicious SQL code. This unsanitized input is exploited to interfere with SQL queries, potentially leading to unauthorized database access and data manipulation.

Impact

Exploitation of this vulnerability allows attackers to inject malicious SQL queries, bypassing authentication and authorization. This could result in unauthorized data access, data modification or deletion, and in some cases, executing administrative operations on the database.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/ofrs/admin/bwdates-report-result.php' with the 'todate' parameter containing injected SQL payloads. Various injection techniques can be used, including boolean-based blind, error-based, time-based blind, and UNION-based injections.

Remediation

It is recommended to update to a version of PHPGurukul Online Fire Reporting System that addresses this vulnerability. Users can also apply general SQL injection prevention techniques, such as input validation, using prepared statements, and minimizing database user permissions.