PHPGurukul Pre-School Enrollment System SQL Injection Vulnerability in Enrollment Details Management

A critical SQL injection vulnerability has been identified in the PHPGurukul Pre-School Enrollment System version 1.0. The issue resides in the file '/admin/enrollment-details.php', where the 'status' parameter in POST requests is not properly validated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, potentially leading to unauthorized database access, data manipulation, and disruption of services.

Impact

Exploitation of this vulnerability allows attackers to inject malicious SQL, which can be used to access, modify, or delete database information. This could include sensitive data, and in some cases, it may allow attackers to execute administrative operations on the database or the underlying system.

Reproduction

To reproduce this vulnerability, send a POST request to '/preschool/admin/enrollment-details.php' with an injected payload in the 'status' parameter that exploits time-based blind SQL injection. The injection can be crafted to, for example, use the 'RLIKE' operator with a 'SLEEP' function to create a time delay, indicating successful exploitation.

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, thereby blocking malicious data. Finally, database user permissions should be minimized, ensuring that the account used for database connections has only the necessary privileges.