Code-Projects Online Complaint Site SQL Injection Vulnerability in Subcategory Management

A SQL injection vulnerability exists in Code-Projects Online Complaint Site version 1.0, specifically within the file '/cms/admin/subcategory.php'. The issue arises from inadequate validation of the 'category' parameter, allowing attackers to inject malicious SQL queries. This vulnerability could lead to unauthorized database access, data manipulation, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows attackers to execute arbitrary SQL commands, potentially leading to unauthorized access to the database, manipulation or deletion of data, and exposure of sensitive information. Such actions could disrupt services and compromise overall system security.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/cms/admin/subcategory.php' with a crafted 'category' parameter that includes malicious SQL code. This injection takes advantage of time-based blind SQL injection techniques, where the injected SQL query is designed to cause a delay in the response, indicating successful exploitation.

Remediation

To address this vulnerability, it is recommended to use prepared statements and parameter binding to separate SQL code from user input, validate and filter input data, minimize database user permissions, and conduct regular security audits.