| Titel | tittuvarghese CollegeManagementSystem 1.0 SQL Injection |
|---|
| Beschreibung | 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. |
|---|
| Quelle | ⚠️ https://github.com/tittuvarghese/CollegeManagementSystem/issues/3 |
|---|
| Benutzer | Nicole_mo (UID 98333) |
|---|
| Einreichung | 18.05.2026 16:04 (vor 5 Monaten) |
|---|
| Moderieren | 05.06.2026 10:10 (18 days later) |
|---|
| Status | Akzeptiert |
|---|
| VulDB Eintrag | 368872 [tittuvarghese CollegeManagementSystem fetch.php department_code SQL Injection] |
|---|
| Punkte | 20 |
|---|