SourceCodester Online Magazine Management System SQL Injection Vulnerability

A SQL injection vulnerability has been identified in SourceCodester Online Magazine Management System version 1.0. The issue arises in the file '/view_magazine.php', where the 'id' parameter is not properly sanitized before being used in SQL queries. This flaw allows remote attackers to manipulate the 'id' parameter and execute arbitrary SQL commands, 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 GET request to 'magazines/index.php' with the 'page' parameter set to 'view_magazine' and the 'id' parameter manipulated to include a SQL injection payload, such as '1'or+sleep(3)%23'. This request will demonstrate the SQL injection vulnerability by causing a delay in the response, indicating that the injection was successful.