| Title | tittuvarghese CollegeManagementSystem 1.0 SQL Injection |
|---|
| Description | The `fetch.php` endpoint is used to fetch course data based on a `department_code` parameter sent via POST. The script directly embeds the user‑supplied value into an SQL query without any sanitisation or parameterisation:
```php
$department_code = $_POST['department_code'];
$sql = mysql_query("SELECT * FROM `courses` WHERE department_code='$department_code' ORDER BY id DESC");
```
Because the endpoint lacks any authentication (no session check is performed), an unauthenticated attacker can inject arbitrary SQL syntax into the department_code field. Even though the immediate output is a JSON‑encoded array of values, the underlying SQL injection is exploitable—for instance, using boolean‑based or time‑based blind techniques to extract sensitive information from the database. |
|---|
| Source | ⚠️ https://github.com/tittuvarghese/CollegeManagementSystem/issues/3 |
|---|
| User | Nicole_mo (UID 98333) |
|---|
| Submission | 05/18/2026 16:04 (21 days ago) |
|---|
| Moderation | 06/05/2026 10:10 (18 days later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 368872 [tittuvarghese CollegeManagementSystem fetch.php department_code sql injection] |
|---|
| Points | 20 |
|---|