SQL Injection - Lab #3 SQLi UNION attack determining the number of columns returned by the query

Опубликовано: 13 Август 2026
на канале: Rana Khalil
35,943
729

In this video, we cover Lab #3 in the SQL injection track of the Web Security Academy. This lab contains a SQL injection vulnerability in the product filter category field. This vulnerability can be exploited using a UNION attack to retrieve data from other tables. To solve the lab, we perform a SQL injection attack that determines the number of columns that are being returned by the query.This is the first step of a SQL injection UNION attack. We'll use this technique in subsequent labs to construct the full attack.

▬ ✨ Support Me ✨ ▬▬▬▬▬▬▬▬▬▬
Buy my course: https://academy.ranakhalil.com/p/web-...

▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
00:00​​​​ - Introduction
01:36​​​ - Understand the exercise and make notes about what is required to solve it
13:14​​​ - Exploit the lab manually
20:46​​​ - Script the exploit
33:27 - Summary
34:00​​​ - Thank You

▬ Links ▬▬▬▬▬▬▬▬▬▬
SQL injection Lab #2 video (previous video):    • SQL Injection - Lab #2 SQL injection vulne...  
SQL Injection | Complete Guide (theory video):    • SQL Injection | Complete Guide  
Python script: https://github.com/rkhal101/Web-Secur...
Notes.txt document: https://github.com/rkhal101/Web-Secur...
Web Security Academy: https://portswigger.net/web-security​
Rana's Twitter account:   / rana__khalil