| タイトル | Dav-ee dairy-management-system f31a584c3330c013b61f8b0306d9e0849c6d693d SQL Injection |
|---|
| 説明 | The affected component is the `employees/` module. `employees/delete.php` takes `$_GET['e_payroll_no']` and interpolates it directly into a `DELETE` statement, while `employees/edit.php` interpolates the same unescaped GET parameter into the `WHERE` clause of an `UPDATE` and a `SELECT`:
```php
// employees/delete.php
$e_payroll_no = $_GET['e_payroll_no'];
mysqli_query($conn,"DELETE FROM `employees` WHERE `e_payroll_no` = '$e_payroll_no' ");
```
```php
// employees/edit.php
$e_payroll_no = $_GET['e_payroll_no'];
$sql = "UPDATE `employees` SET `e_name` = '{$_POST['e_name']}' , ... WHERE `e_payroll_no` = '$e_payroll_no' ";
$result = mysqli_query($conn,"SELECT * FROM `employees` WHERE `e_payroll_no` ='$e_payroll_no'");
```
These endpoints are reachable by a `Manager` account. A time-based payload such as `999' OR SLEEP(2) -- -` in `e_payroll_no` produced a multi-second delay (SLEEP evaluated per matching row), confirming injection. The flaw lets a Manager (or an attacker who obtains Manager access) read, modify, or delete arbitrary records in the `employees` table — including elevating their own role or resetting passwords — and it provides a primitive for broader database compromise.
|
|---|
| ソース | ⚠️ https://github.com/Dav-ee/dairy-management-system/issues/3 |
|---|
| ユーザー | 7z2Z (UID 101867) |
|---|
| 送信 | 2026年10月02日 14:20 (17 日 ago) |
|---|
| モデレーション | 2026年10月18日 18:26 (16 days later) |
|---|
| ステータス | 承諾済み |
|---|
| VulDBエントリ | 421854 [Dav-ee dairy-management-system employees/delete.php mysqli_query e_payroll_no SQLインジェクション] |
|---|
| ポイント | 20 |
|---|