Code-Projects Assessment Management SQL Injection Vulnerability in add-module.php

A SQL injection vulnerability exists in the Code-Projects Assessment Management application, version 1.0. The issue arises in the admin/add-module.php file, where the linked[] parameter can be manipulated to inject malicious SQL code. This unsanitized input is exploited to alter SQL queries, potentially leading to unauthorized database access and manipulation. The vulnerability can be exploited remotely without authentication.

Impact

Exploitation of this vulnerability allows for unauthorized SQL query manipulation, which could result in unauthorized data access, data modification, or execution of administrative operations on the database.

Reproduction

To reproduce this vulnerability, send a POST request to the /admin/add-module.php endpoint with the linked[] parameter. Inject SQL payloads, such as error-based or time-based blind SQL injection payloads, to exploit the vulnerability. The injection can be verified by using payloads that trigger SQL errors or by causing a delay in the response, indicating that the injected SQL command was executed.

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 that user input conforms to expected formats, blocking malicious data. Finally, database user permissions should be minimized, ensuring that the account used for database connections has only the necessary privileges.