Code-Projects Online Reviewer System SQL Injection Vulnerability

A SQL injection vulnerability has been identified in Code-Projects Online Reviewer System version 1.0. The issue arises in the file '/system/system/admins/assessments/pretest/questions-view.php', where the 'id' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without any authentication.

Impact

Exploitation of this vulnerability allows attackers to inject SQL queries that can be executed by the database. This could lead to unauthorized data access, data manipulation or deletion, and in some cases, executing commands on the server, depending on the database and application configuration.

Reproduction

The vulnerability can be reproduced by sending a crafted HTTP GET request to 'questions-view.php' with an injected SQL payload in the 'id' parameter. This can be done using a tool like sqlmap, which automates the process of finding and exploiting SQL injection vulnerabilities.

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, ensuring that the account used to connect to the database has only the necessary privileges.