| 标题 | 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 日前) |
|---|
| 管理 | 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 |
|---|