code-projects Mobile Shop Management System SQL Injection Vulnerability

A SQL injection vulnerability has been identified in code-projects Mobile Shop Management System version 1.0. The issue resides in the ExAddNewUser.php file, where user-supplied data through the Name, Address, email, UserName, Password, confirm_password, Role, Branch, and Activate parameters is not properly sanitized before being incorporated into database queries. This oversight allows attackers to manipulate the SQL query execution, potentially leading to unauthorized data access or modification.

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, send a POST request to the ExAddNewUser.php endpoint with crafted payloads that exploit the SQL injection flaw. The request must include the vulnerable parameters: UserName, which can be injected with SQL payloads, and the other parameters to complete the user creation process. The injection can be verified by, for example, extracting database information through the SQL injection payload.