| 제목 | girishsaraf Online-Appointment-Booking-System f427b4757128ca253d33d0cc4e87bbb9c999a4d5 SQL Injection |
|---|
| 설명 | The affected components are the root AJAX endpoints `get_town.php`, `getclinic.php`, `getdoctordaybooking.php`, and `getDay.php`. Each one concatenates a POST parameter into a SQL query without escaping:
```php
// get_town.php
$query = "SELECT * FROM clinic WHERE City = '" . $_POST["countryid"] . "'";
// getclinic.php
$query = "SELECT * FROM clinic WHERE Town = '" . $_POST["townid"] . "'";
// getdoctordaybooking.php
$query = "SELECT distinct DID FROM doctor_availability WHERE CID =".$_POST["cid"];
// getDay.php
$query = "SELECT * FROM doctor_availability WHERE DID = '" . $_POST["didval"] . "' AND CID='".$_POST["cidval"]."'";
```
These endpoints require no authentication. An attacker can inject `SLEEP()` expressions and observe measurable response delays (e.g. `time_total=2.004s`, `10.016s`), confirming blind SQL injection and enabling time-based data exfiltration.
|
|---|
| 원천 | ⚠️ https://github.com/girishsaraf/Online-Appointment-Booking-System/issues/7 |
|---|
| 사용자 | jiqinwang (UID 101291) |
|---|
| 제출 | 2026. 09. 16. PM 03:47 (19 날 ago) |
|---|
| 모더레이션 | 2026. 10. 05. PM 04:58 (19 days later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 413615 [girishsaraf Online-Appointment-Booking-System 까지 f427b4757128ca253d33d0cc4e87bbb9c999a4d5 AJAX Endpoint get_town.php countryid/townid/cid/didval/cidval SQL 주입] |
|---|
| 포인트들 | 20 |
|---|