| Title | girishsaraf Online-Appointment-Booking-System f427b4757128ca253d33d0cc4e87bbb9c999a4d5 SQL Injection |
|---|
| Description | The affected components are the admin AJAX endpoints `Admin/getclinic.php`, `Admin/getmanagerregion.php`, `Admin/getdoctor.php`, `Admin/getdoctorday.php`, and `Admin/getmanager.php`. Each concatenates a POST parameter into a SQL query without authentication or escaping:
```php
// Admin/getclinic.php
$query ="SELECT * FROM clinic WHERE City = '" . $_POST["city"] . "'";
// Admin/getmanagerregion.php
$query1 ="SELECT * FROM manager WHERE UPPER(region) like UPPER('%".$_POST["city"]."%')";
// Admin/getdoctor.php
$query ="SELECT distinct DID FROM doctor_availability WHERE CID = '" . $_POST["cid"] . "'";
// Admin/getdoctorday.php
$query ="SELECT * FROM doctor_availability WHERE CID =".$_POST["cid"];
// Admin/getmanager.php
$query ="SELECT * FROM manager_clinic WHERE CID =".$_POST["cid"];
```
An unauthenticated attacker can inject `SLEEP()` expressions and observe delays (e.g. `2.008s`, `10.025s`), confirming blind SQL injection. |
|---|
| Source | ⚠️ https://github.com/girishsaraf/Online-Appointment-Booking-System/issues/13 |
|---|
| User | DOUzhen131415 (UID 101295) |
|---|
| Submission | 09/16/2026 15:52 (1 month ago) |
|---|
| Moderation | 10/12/2026 21:04 (26 days later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 417187 [girishsaraf Online-Appointment-Booking-System up to f427b4757128ca253d33d0cc4e87bbb9c999a4d5 AJAX Endpoint Admin/getclinic.php city/cid sql injection] |
|---|
| Points | 20 |
|---|