PHPGurukul COVID19 Testing Management System SQL Injection Vulnerability in Profile.php

A critical SQL injection vulnerability has been identified in version 1.0 of the PHPGurukul COVID19 Testing Management System. The issue resides in the 'profile.php' file, where the 'mobilenumber' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without any authentication or authorization. The lack of proper input validation enables unauthorized access to the database, potential data modification or deletion, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for unauthorized database access, manipulation of data, deletion of database records, and access to sensitive information. Such actions could disrupt services and pose a significant threat to overall system security and business operations.

Reproduction

To reproduce this vulnerability, send a POST request to 'profile.php' with the 'mobilenumber' parameter. Include a payload that exploits the SQL injection, such as one that uses a time-based blind SQL injection technique, like injecting a SQL query that causes a delay in the response. This can be done using tools like sqlmap, which automates the process of finding and exploiting SQL injection vulnerabilities.

Remediation

To address this vulnerability, it is recommended to use prepared statements and parameter binding to prevent SQL injection by separating SQL code from user input. Additionally, implement strict input validation and filtering to ensure data conforms to expected formats. Minimize database user permissions and conduct regular security audits to identify and fix potential vulnerabilities.