PHPGurukul News Portal SQL Injection Vulnerability in Edit Subcategory Admin File

A critical SQL injection vulnerability has been identified in PHPGurukul News Portal Project version 4.1. The issue resides in the admin/edit-subcategory.php file, where the 'category' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, with no login or authorization required.

Impact

Exploitation of this vulnerability allows unauthorized access to the database, where attackers can 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 the 'admin/edit-subcategory.php' file with a crafted 'category' parameter that includes malicious SQL payloads. This input is then processed by the application without proper sanitization, allowing the injection of harmful SQL commands.

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, blocking malicious entries. Finally, database user permissions should be minimized, granting only necessary access rights.