itsourcecode Student Management System SQL Injection Vulnerability in candidates_report.php

A SQL injection vulnerability exists in the itsourcecode Student Management System version 1.0, specifically within the candidates_report.php file. The issue arises from the school's year parameter, which is not properly sanitized before being used in SQL queries. This flaw allows attackers to inject malicious SQL code, potentially leading to unauthorized database access and manipulation. The vulnerability can be exploited remotely without authentication.

Impact

Exploitation of this vulnerability allows for SQL injection, where attackers can manipulate database queries. This could lead to unauthorized data access, data modification, and in some cases, executing administrative operations on the database.

Reproduction

The vulnerability can be reproduced by sending a crafted GET request to the candidates_report.php file with the school_year parameter. The injected SQL payload can be designed to exploit the application's SQL query handling, taking advantage of the lack of input validation and sanitation.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be implemented to ensure user input conforms to expected formats. Minimizing database user permissions and conducting regular security audits can also help enhance the application's security.