Projectworlds Online Hotel Booking SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in Projectworlds Online Hotel Booking version 1.0, specifically within the '/reservation.php' file. This vulnerability arises from inadequate validation of user input in the 'checkin' parameter, allowing attackers to inject malicious SQL queries. Exploitation of this vulnerability can lead to unauthorized access to the database, manipulation or deletion of data, and exposure of sensitive information. The vulnerability can be exploited remotely, without the need for authentication.

Impact

Exploitation of this vulnerability allows for SQL injection, enabling attackers to manipulate database queries. This could result in unauthorized database access, leakage or modification of sensitive data, and potential disruption of services.

Reproduction

The vulnerability can be reproduced by sending a POST request to 'reservation.php' with a crafted 'checkin' parameter that includes malicious SQL code. This injected SQL code can then be executed by the database, bypassing normal query restrictions. The 'checkout' parameter must also be included in the request.

Remediation

To address this vulnerability, it is recommended to use prepared statements and parameter binding to separate SQL code from user input, ensuring that injected data is not executed as part of a SQL command. Additionally, input validation and filtering should be implemented to enforce expected data formats. Minimizing database user permissions and conducting regular security audits can further enhance the application's security.