CodeAstro Online Classroom SQL Injection Vulnerability in Faculty Details Function

A SQL injection vulnerability has been identified in CodeAstro Online Classroom version 1.0. The issue arises in the faculty details function, specifically within the file '/OnlineClassroom/facultydetails.php'. The vulnerability is triggered by manipulating the 'deleteid' parameter, allowing attackers to inject malicious SQL queries. This SQL injection can be exploited remotely, posing a significant risk to the application's database security.

Impact

Exploitation of this vulnerability allows unauthorized users to inject and execute malicious SQL commands, potentially leading to unauthorized data access, data manipulation or deletion, and in some cases, full system control or service disruption.

Reproduction

The vulnerability can be reproduced by sending a GET request to '/OnlineClassroom/facultydetails.php' with a crafted 'deleteid' parameter that includes malicious SQL payloads. 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, validate and filter user input, minimize database user permissions, and conduct regular security audits.