| 제목 | imvks786 student_management_system 1.0 SQL Injection |
|---|
| 설명 | The application contains SQL injection vulnerabilities throughout nearly all database interaction points. User‑supplied input from `$_GET` and `$_POST` is concatenated directly into SQL queries without any parameterisation, escaping, or validation. This allows an attacker to manipulate query logic, leading to:
- **Authentication bypass** – log in as any user (including administrators) without valid credentials.
- **Unauthorised data deletion** – delete student records via `see.php?del=...`.
- **Unauthorised permission changes** – modify user roles via `admin/user_permission.php`.
- **Sensitive data exposure** – extract arbitrary data from the database using UNION‑based or blind techniques.
### Affected Code Examples
**1. Login bypass (department login):**
```php
// index.php
$usr = $_POST['usr'];
$pwd = $_POST['pwd'];
$ret = mysqli_query($con, "SELECT * FROM login WHERE username='$usr' AND password='$pwd' ");
``` |
|---|
| 원천 | ⚠️ https://github.com/imvks786/student_management_system/issues/1 |
|---|
| 사용자 | Amoda (UID 98400) |
|---|
| 제출 | 2026. 05. 25. AM 05:55 (16 날 ago) |
|---|
| 모더레이션 | 2026. 06. 07. PM 09:53 (14 days later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 369147 [imvks786 student_management_system 까지 9599b560ad3c3b83e75d328b76bedcd489ef1f46 Login /index.ph usr/pwd SQL 주입] |
|---|
| 포인트들 | 20 |
|---|