| 제목 | girishsaraf Online-Appointment-Booking-System f427b4757128ca253d33d0cc4e87bbb9c999a4d5 SQL Injection |
|---|
| 설명 | The affected component is the root `cover.php` patient login handler. After checking that `uname` and `psw` are non-empty, it concatenates both POST values directly into the query:
```php
$username=$_POST['uname'];
$password=$_POST['psw'];
$query = mysqli_query($conn,"select * from patient where password='$password' AND username='$username'");
```
Because the credentials are embedded into the SQL string without escaping or prepared statements, an unauthenticated attacker can submit `nouser' OR '1'='1` as the username to make the WHERE clause always true. This bypasses authentication and grants a patient session (`$_SESSION['username']`, `$_SESSION['user']`), which can then be used to book or cancel appointments on behalf of the account.
|
|---|
| 원천 | ⚠️ https://github.com/girishsaraf/Online-Appointment-Booking-System/issues/5 |
|---|
| 사용자 | zsh07 (UID 101257) |
|---|
| 제출 | 2026. 09. 15. PM 07:08 (20 날 ago) |
|---|
| 모더레이션 | 2026. 10. 05. PM 12:27 (20 days later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 413581 [girishsaraf Online-Appointment-Booking-System 까지 f427b4757128ca253d33d0cc4e87bbb9c999a4d5 Patient Login cover.php mysqli_query uname/psw SQL 주입] |
|---|
| 포인트들 | 20 |
|---|