Code-Projects Staff Audit System SQL Injection Vulnerability

A critical SQL injection vulnerability has been identified in Code-Projects Staff Audit System version 1.0. The issue arises in the file '/search_index.php', where the 'search' parameter is improperly validated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, potentially leading to unauthorized database access, data manipulation or deletion, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for unauthorized database access, manipulation or deletion of data, and leakage of sensitive information. Such actions could disrupt services and cause significant harm to business operations.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/search_index.php' with a crafted 'search' parameter that includes malicious SQL payloads. Various injection techniques can be used, such as boolean-based blind, error-based, time-based blind, and UNION-based injections.

Remediation

It is recommended to implement prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be applied to ensure user input meets expected formats, blocking malicious data. Finally, database user permissions should be minimized, granting only necessary access rights.