itsourcecode School Management System SQL Injection Vulnerability

A SQL injection vulnerability has been identified in itsourcecode School Management System version 1.0. The issue resides in the file '/subject/index.php', where the 'id' parameter can be manipulated to inject malicious SQL code. This vulnerability can be exploited remotely and has been made public.

Impact

Exploitation of this vulnerability allows attackers to inject and execute malicious SQL queries, potentially leading to unauthorized database access, data manipulation, and disruption of service.

Reproduction

The vulnerability can be reproduced by sending a GET request to '/ramonsys/subject/index.php' with the 'view' parameter set to 'edit' and the 'id' parameter manipulated to include a SQL injection payload. The injection can be verified by using a time-based blind SQL injection technique, such as adding a payload that causes the database to delay its response.

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 are also advisable.