| शीर्षक | girishsaraf Online-Appointment-Booking-System f427b4757128ca253d33d0cc4e87bbb9c999a4d5 SQL Injection |
|---|
| विवरण | The affected components are the root `book.php` booking handler and `cancelbookingpatient.php` cancellation handler. In `book.php`, the `Doctor` POST value is concatenated into the availability check and the INSERT:
```php
$did=$_POST['Doctor'];
$query ="SELECT * FROM doctor_availability WHERE DID = '" .$did. "' AND CID='".$cid."'";
$sql = "INSERT INTO book (...) VALUES (...'$did'...)";
```
In `cancelbookingpatient.php`, the `appointment` POST value is concatenated into an UPDATE:
```php
$timestamp=$_POST['appointment'];
$updatequery="update book set Status='Cancelled by Patient' where username='$username' and timestamp= '$timestamp'";
```
A logged-in patient can inject `1' AND SLEEP(2) -- -` (or `x' OR SLEEP(2) -- -`) to trigger measurable delays, confirming SQL injection in authenticated flows. |
|---|
| स्रोत | ⚠️ https://github.com/girishsaraf/Online-Appointment-Booking-System/issues/10 |
|---|
| उपयोगकर्ता | jiqinwang (UID 101291) |
|---|
| सबमिशन | 16/09/2026 03:49 PM (20 दिन पहले) |
|---|
| संयम | 05/10/2026 04:58 PM (19 days later) |
|---|
| स्थिति | स्वीकृत |
|---|
| VulDB प्रविष्टि | 413618 [girishsaraf Online-Appointment-Booking-System तक f427b4757128ca253d33d0cc4e87bbb9c999a4d5 Booking book.php Doctor/appointment SQL इंजेक्शन] |
|---|
| अंक | 20 |
|---|