PHPGurukul Park Ticketing Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in PHPGurukul Park Ticketing Management System version 2.0. The issue resides in the file '/normal-search.php', where the 'searchdata' parameter is manipulated to inject malicious SQL code. This unsanitized input is directly used in SQL queries, allowing attackers to alter the queries and execute unauthorized database operations. The vulnerability can be exploited remotely, with public knowledge of the exploit available.

Impact

Exploitation of this vulnerability allows attackers to access the database without authorization, potentially leading to data modification or deletion, unauthorized data access, and disruption of services.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/ptms/normal-search.php' with the 'searchdata' parameter. The request can include a payload that exploits the SQL injection, such as a time-based blind injection payload that uses the SQL 'SLEEP' function to demonstrate the injection capability.

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 that user input meets expected formats, blocking malicious data. Finally, database user permissions should be minimized, granting only necessary privileges to the account used for database connections.