| 제목 | SourceCodester Drug Recommendation System 1.0 SQL Injection |
|---|
| 설명 | A SQL injection vulnerability exists in SourceCodester Drug Recommendation System 1.0 in Admin/edit_user.php. The GET parameter `id` is directly concatenated into the SQL query `SELECT * FROM users where id='$user_id'` without sanitization or parameter binding. Authentication is required but no role check is enforced, so any logged-in user (Doctor, Pharmacist) can exploit this.
Proof of Concept (authenticated):
GET /Admin/edit_user.php?id=1' UNION SELECT 1,2,name,4,password,role,7,8,9 FROM users-- -
Cookie: PHPSESSID=<valid>
Time-based blind:
GET /Admin/edit_user.php?id=1' AND SLEEP(5)-- -
Impact: An authenticated attacker can extract all user data including plaintext passwords, modify database records, and escalate privileges. 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. AM 05:48 (25 날 ago) |
|---|
| 모더레이션 | 2026. 10. 04. AM 10:50 (24 days later) |
|---|
| 상태 | 중복 |
|---|
| VulDB 항목 | 407955 [SourceCodester Drug Recommendation System 1.0 edit_user.php id SQL 주입] |
|---|
| 포인트들 | 0 |
|---|