Campcodes Computer Sales and Inventory System SQL Injection Vulnerability

A SQL injection vulnerability has been identified in Campcodes Computer Sales and Inventory System version 1.0. The issue arises in the file '/pages/pos_transac.php?action=add', where insufficient input validation of the 'cash' and 'firstname' parameters allows attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without authentication, leading to unauthorized database access, data manipulation, and potential disruption of service.

Impact

Exploitation of this vulnerability allows for unauthorized access to the database, manipulation or deletion of data, access to sensitive information, and could disrupt normal service operations.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/ComputerSalesInventorySystem/pages/pos_transac.php?action=add' with crafted payloads in the 'cash' or 'firstname' parameters. These payloads can include SQL injection techniques such as error-based or time-based blind injections, depending on the parameter used.

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.