SourceCodester Online Eyewear Shop SQL Injection Vulnerability in Users.php

A critical SQL injection vulnerability has been identified in SourceCodester Online Eyewear Shop version 1.0. The issue arises in the Users.php file, specifically within the delete function, where the ID parameter is manipulated to execute unauthorized SQL commands. This vulnerability can be exploited remotely, allowing attackers to access sensitive information from the server.

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 '/oews/classes/Users.php?f=delete' with the 'id' parameter. Include a payload that exploits the SQL injection, such as '1 and updatexml(1,concat(0x7e,(database())),3)-- q'. This payload tricks the application into executing arbitrary SQL commands, which can be used to extract database information.