Code-Projects Online Product Reservation System SQL Injection Vulnerability in Product Editing

A critical SQL injection vulnerability has been identified in the Online Product Reservation System version 1.0. The issue arises in the product editing feature within the file '/handgunner-administrator/edit.php'. The vulnerability is caused by the application directly inserting user input from both GET and POST parameters into SQL queries without proper validation. This flaw allows attackers to manipulate the 'prod_id', 'name', 'price', 'model', and 'serial' parameters, potentially leading to unauthorized access to sensitive database information and modification of product details. The vulnerability can be exploited remotely and does not require authentication.

Impact

Exploitation of this vulnerability allows for SQL injection, where an attacker can interfere with the application's database queries. This could lead to unauthorized data access, data manipulation, or in some cases, executing administrative operations on the database.

Reproduction

To reproduce this vulnerability, access the 'edit.php' file within the 'handgunner-administrator' directory. The vulnerability can be triggered by sending a request that includes the 'prod_id' parameter via GET, and the 'name', 'price', 'model', and 'serial' parameters via POST. The absence of input validation allows for the injection of malicious SQL code, which is executed by the application.