| Title | SourceCodester Drug Recommendation System 1.0 SQL Injection |
|---|
| Description | A SQL injection vulnerability exists in SourceCodester Drug Recommendation System 1.0 in Admin/edit_class.php. The GET parameter `id` is directly concatenated into the SQL query `SELECT * FROM classes where school_id='$school_id' and id='$id'` without sanitization or parameter binding. Authentication is required but no role check is enforced. The variable `$school_id` is also referenced uninitialized.
Proof of Concept (authenticated):
GET /Admin/edit_class.php?id=1' UNION SELECT 1,2,3,4,5,6,7,8,9-- -
Cookie: PHPSESSID=<valid>
Time-based blind:
GET /Admin/edit_class.php?id=1' AND SLEEP(5)-- -
Impact: An authenticated attacker can extract database contents and execute arbitrary SQL commands. CWE-89, CVSS v3.1 8.8 (AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H).
|
|---|
| Source | ⚠️ https://www.sourcecodester.com/php/18278/drug-recommender-web-app-student-project.html |
|---|
| User | swj99557271 (UID 101148) |
|---|
| Submission | 09/10/2026 05:49 (25 days ago) |
|---|
| Moderation | 10/04/2026 10:50 (24 days later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 413408 [SourceCodester Drug Recommendation System 1.0 /Admin/edit_class.php id sql injection] |
|---|
| Points | 20 |
|---|