SourceCodester Apartment Visitor Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in SourceCodester Apartment Visitor Management System version 1.0. The issue arises in the file '/add-apartment.php', where the 'buildingno' parameter can be manipulated to execute arbitrary SQL commands. This vulnerability can be exploited remotely, potentially affecting multiple parameters.

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 request to '/add-apartment.php' with a crafted 'buildingno' parameter that includes SQL injection payloads. The application will process the request and execute the injected SQL commands, demonstrating the vulnerability.