| 标题 | AdithyaYelloju Restaurant-Management-System 7f0e7e84255e8fcfd488e83f8f91451bbbff6b9c SQL Injection |
|---|
| 描述 | The affected components are the unauthenticated action scripts under `admin/` that read a record id from the query string and concatenate it directly into a SQL statement:
- `admin/delete1.php` — `mysqli_query($conn,"delete from tables where id='$id'");`
- `admin/delete1_m.php` — `mysqli_query($conn,"delete from menu where id='$id'");`
- `admin/delete_user1.php` — `mysqli_query($conn,"delete from user where id='$id'");`
- `admin/approve.php` — `mysqli_query($conn,"update order_list set status='yes' where id='$id'")`
- `admin/approvet.php` — `mysqli_query($conn,"update t_order set status='Approved' where id='$id'")`
- `admin/notapprove.php` — `mysqli_query($conn,"update order_list set status='no' where id='$id'")`
- `admin/notapprovet.php` — `mysqli_query($conn,"update t_order set status='Cancel' where id='$id'")`
The id is taken directly from `$_GET["id"]` and concatenated into the SQL string with single-quote interpolation. There is no session check, no role check, no anti-CSRF token, and no escaping. An attacker can close the quote, append `OR id>0 -- ` (or `OR '1'='1' -- `) to mass-update or mass-delete rows. Verified in the lab by deleting all `menu` rows through `admin/delete1_m.php`.
|
|---|
| 来源 | ⚠️ https://github.com/AdithyaYelloju/Restaurant-Management-System/issues/5 |
|---|
| 用户 | 100001001X (UID 100909) |
|---|
| 提交 | 2026-09-01 13時26分 (30 日前) |
|---|
| 管理 | 2026-09-30 10時09分 (29 days later) |
|---|
| 状态 | 已接受 |
|---|
| VulDB条目 | 411922 [AdithyaYelloju Restaurant-Management-System 直到 7f0e7e84255e8fcfd488e83f8f91451bbbff6b9c Unauthenticated Action Script admin/delete1.php mysqli_query id SQL注入] |
|---|
| 积分 | 20 |
|---|