SourceCodester Open Source Clinic Management System SQL Injection Vulnerability in doctor.php

A critical SQL injection vulnerability has been identified in SourceCodester Open Source Clinic Management System version 1.0. The issue resides in the doctor.php file, where the doctorname parameter is manipulated to inject malicious SQL queries. This vulnerability can be exploited remotely, without any authentication, allowing attackers to access and manipulate database information.

Impact

Exploitation of this vulnerability allows unauthorized access to the database, where attackers can leak, modify, or delete data. This could lead to a complete compromise of the system, including sensitive data exposure and potential service disruptions.

Reproduction

To reproduce this vulnerability, send a POST request to the doctor.php file with the doctorname parameter. Inject a crafted SQL payload that exploits the application's SQL query handling. The injection can be error-based or time-based, depending on the payload used.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection. Additionally, input validation and filtering should be implemented to ensure user input conforms to expected formats. Minimizing database user permissions and conducting regular security audits can also help mitigate such vulnerabilities.