Code-Projects Employee Profile Management System SQL Injection Vulnerability in print_personnel_report.php

A SQL injection vulnerability has been identified in version 1.0 of the Code-Projects Employee Profile Management System. The issue arises in the print_personnel_report.php file, where the per_id parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, potentially leading to unauthorized database access, data modification or deletion, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for unauthorized database access via the injected SQL, with the potential to modify or delete data, access sensitive information, and disrupt overall system functionality.

Reproduction

The vulnerability can be reproduced by sending a request to the print_personnel_report.php file with a crafted per_id parameter that includes malicious SQL code. This can be done using a variety of tools or scripts that automate the injection process, taking advantage of the application's lack of input validation.

Remediation

To address this vulnerability, it is recommended to implement prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be applied to ensure that user input meets expected formats, and database user permissions should be minimized to reduce the risk of unauthorized access.