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 file '/admin/add-art-type.php', where the 'arttype' parameter is manipulated, leading to unauthorized database access. This vulnerability can be exploited remotely, without any authentication, allowing attackers to inject malicious SQL queries that could be used to access, modify, or delete database information.

Impact

Exploitation of this vulnerability allows for unauthorized database access, manipulation of data, and potential disruption of services. This poses a significant risk to the overall security of the system and its operational continuity.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/admin/add-art-type.php' with the 'arttype' parameter. The request should include a payload that exploits the SQL injection vulnerability, such as one that uses time-based blind SQL injection techniques, like appending a crafted SQL payload that includes a time delay command, such as 'SLEEP(5)', to the 'arttype' parameter. This demonstrates the injection of malicious SQL that is executed by the database, indicating the presence of the SQL injection vulnerability.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection vulnerabilities. Additionally, input validation and filtering should be implemented to ensure that user input conforms to expected formats, thereby blocking malicious inputs. Finally, database user permissions should be minimized, ensuring that the account used to connect to the database has only the necessary permissions and avoiding accounts with elevated privileges.