PHPGurukul Daily Expense Tracker System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in PHPGurukul Daily Expense Tracker System version 1.1. The issue resides in the file '/expense-monthwise-reports-detailed.php', where the 'todate' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without any authentication or authorization.

Impact

Exploitation of this vulnerability allows unauthorized access to the database, where attackers can leak, modify, or delete data. Additionally, it could lead to complete control over the system and disruption of services.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/dets/expense-monthwise-reports-detailed.php' with the 'fromdate' parameter set to a fixed date and the 'todate' parameter crafted to include a SQL injection payload. This payload can be designed to manipulate the SQL query execution, such as by adding a condition that is always true or by grouping data in a way that reveals sensitive information.

Remediation

To address this vulnerability, developers should implement prepared statements and parameter binding to separate SQL code from user input, conduct thorough input validation and filtering, and minimize database user permissions to the least required.