| 제목 | sourcecodester Expense Management System sql injection in report.php(authenticated) |
|---|
| 설명 | in report.php line 34-37 call the function fetch_report_credit, and the function is implementation in Home_model.php
public function fetch_report_credit($from,$to){
$query= $this->db->query("select (SELECT SUM(credit.amount) FROM credit,recep where credit.date between '$from' and '$to' AND credit.cus_id=recep.id) AS Total,credit.amount, credit.date, recep.name FROM recep,credit where credit.date between '$from' and '$to' AND credit.cus_id=recep.id ORDER BY credit.date");
return $query;
}
it is obvious that the post parameter from and to is weak to sql injection
after login ,we can access report.php and copy the request to txt file from burpsuite and run sqlmap to exploit
python .\sqlmap.py -r .\1.txt --dbs
|
|---|
| 원천 | ⚠️ https://www.sourcecodester.com/php-codeigniter-expense-management-system-source-code |
|---|
| 사용자 | wuerror (UID 30660) |
|---|
| 제출 | 2022. 08. 06. AM 09:58 (4 연령 ago) |
|---|
| 모더레이션 | 2022. 08. 06. PM 06:45 (9 hours later) |
|---|
| 상태 | 수락 |
|---|
| VulDB 항목 | 205811 [SourceCodester Expense Management System POST Parameter report.php fetch_report_credit from/to SQL 주입] |
|---|
| 포인트들 | 17 |
|---|