PHPGurukul Art Gallery Management System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in PHPGurukul Art Gallery Management System version 1.1. The issue resides in the '/admin/add-art-medium.php' file, where the 'MULTIPART artmed' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, with the injected SQL code executed without proper input validation or sanitization.

Impact

Exploitation of this vulnerability allows unauthorized access to the database, enabling attackers to leak, modify, or delete data. Additionally, it could lead to complete control over the system and disruption of services.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/admin/add-art-medium.php' with the 'artmed' parameter. The request must include a crafted SQL payload that exploits the application's SQL query handling. This can be done using tools like sqlmap, which automates the process of finding and exploiting SQL injection vulnerabilities.

Remediation

To address this vulnerability, it is recommended to implement prepared statements and parameter binding to separate SQL code from user input. Additionally, input validation and filtering should be applied to ensure data conforms to expected formats. Finally, database user permissions should be minimized, restricting accounts to only the necessary privileges.