SourceCodester Simple Responsive Tourism Website SQL Injection Vulnerability

A SQL injection vulnerability has been identified in SourceCodester Simple Responsive Tourism Website version 1.0. The issue resides in the Login component, specifically within the file '/tourism/classes/Login.php?f=login'. The vulnerability is triggered by manipulating the 'username' parameter, allowing attackers to inject malicious SQL queries. This exploitation can be done remotely and without authentication.

Impact

Exploitation of this vulnerability allows attackers to execute arbitrary SQL commands, potentially leading to unauthorized database access, data manipulation, and access to sensitive information. Such actions could disrupt service and pose a significant threat to overall system security.

Reproduction

To reproduce this vulnerability, send a POST request to '/tourism/classes/Login.php?f=login' with a crafted 'username' parameter that includes SQL injection payloads. The 'password' parameter can be set to any value, such as 'admin123'.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be implemented to ensure user input conforms to expected formats. Minimizing database user permissions and conducting regular security audits are also advisable.