| 제목 | Mstfakts College-Management-System 82ab01d057d96c8893c419cd9cb6870120faaea3 SQL Injection |
|---|
| 설명 | The affected components are `Front-end/university.php:117-140` and `Front-end/faculty.php:114-138`. Each unauthenticated book-search handler inserts the attacker-controlled `book_name` and `book_author` POST parameters directly into a SQL statement and executes it with `mysqli_query()`:
```php
$name=$_POST['book_name'];
$author=$_POST['book_author'];
$query = "SELECT * FROM book WHERE book_name = '$name' AND author = '$author'";
$results = mysqli_query($db, $query);
```
Neither endpoint validates nor parameterizes the values, and neither enforces an authenticated session before reaching the query. A remote attacker can use a four-column `UNION SELECT` to read arbitrary database rows. The returned columns are written into the HTML result table, allowing disclosure of account records, password hashes, phone numbers, and role data from the `visitor` table. The same primitive can be adapted to enumerate other accessible tables and records. |
|---|
| 원천 | ⚠️ https://github.com/Mstfakts/College-Management-System/issues/5 |
|---|
| 사용자 | Yangqiangfeng (UID 98164) |
|---|
| 제출 | 2026. 07. 20. AM 11:03 (2 개월 ago) |
|---|
| 모더레이션 | 2026. 09. 05. PM 08:59 (2 months later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 399349 [Mstfakts College-Management-System Search Front-end/university.php mysqli_query book_name/book_author SQL 주입] |
|---|
| 포인트들 | 20 |
|---|