Code-Projects Online Shopping Store SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in Code-Projects Online Shopping Store version 1.0. The issue resides in the '/action.php' file, where insufficient input validation of the 'cat_id', 'brand_id', 'keyword', 'proId', and 'pid' parameters allows attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, but requires authentication to the backend system to obtain a valid PHP session ID.

Impact

Exploitation of this vulnerability allows for unauthorized database access, manipulation of database contents, and potential leakage of sensitive information. The vulnerability could also be exploited to disrupt service availability.

Reproduction

To reproduce this vulnerability, send a POST request to 'action.php' with one of the vulnerable parameters ('cat_id', 'brand_id', 'keyword', 'proId', or 'pid') included. The request must also include a valid PHP session cookie to authenticate the user.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection, validate and filter user input, minimize database user permissions, and conduct regular security audits.