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

Поделиться
HTML-код
  • Опубликовано: 20 мар 2021
  • 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: academy.ranakhalil.com/p/web-...
    ▬ Links ▬▬▬▬▬▬▬▬▬▬
    Detailed video: • SQL Injection - Lab #3...
    SQL injection Lab #2 video (previous video): • SQL Injection - Lab #2...
    SQL Injection | Complete Guide (theory video): • SQL Injection | Comple...
    Notes.txt document: github.com/rkhal101/Web-Secur...
    Web Security Academy: portswigger.net/web-security​​
    Rana's Twitter account: / rana__khalil
  • НаукаНаука

Комментарии • 57

  • @RanaKhalil101
    @RanaKhalil101  2 года назад +7

    Interested in supporting me and gaining early access to the Web Security Academy videos when they're recorded? Consider buying my course: academy.ranakhalil.com/p/web-security-academy-video-series! ✨ ✨

    • @christopherrodriguez6545
      @christopherrodriguez6545 2 года назад

      This course is a steal for the price. I look forward to joining very soon. Peace and Blessings to you.

    • @heuristicalgorithm8465
      @heuristicalgorithm8465 2 года назад

      Why do you put a quote after Gifts?

    • @mr.rabbit1956
      @mr.rabbit1956 Год назад

      genial, me gusta como explicas todo y se te entiende muy bien, contigo complemento mi aprendizaje, tus videos de paga tienen subtitulos en español?

  • @user-ni7rd7st8z
    @user-ni7rd7st8z Год назад +1

    感谢,老师思路清晰,不疾不徐,听得懂的同时听得舒适

  • @cryptohivemind9249
    @cryptohivemind9249 Год назад +2

    This is really What I was looking for, I felt lost.. I was doing it just because someone said it should be like that... you actually explained WHY we were doing that..
    brilliant.
    I Wish the best for you!
    thank you thank you!

  • @shurikensage
    @shurikensage 7 месяцев назад +1

    You are really the best in SQL teaching. Thanks to David Bombal, that's where i saw you and also i have met you again in the portswigger labs

  • @user-fi2ty4bm2n
    @user-fi2ty4bm2n 3 года назад +8

    I want to say THANK YOU.
    As a newbie in this field, I don't even know where to start and how the logic works.
    With your explanation, I now understand and be ready for the next challenge :")

    • @RanaKhalil101
      @RanaKhalil101  3 года назад +2

      No problem! I'm glad it helped :)

    • @jacobdavidgolden862
      @jacobdavidgolden862 Год назад

      @@RanaKhalil101 Your videos are so great. I do Hack The Box Academy and PortSwigger, and your videos really help me grasp the material!

  • @kumarniloy1798
    @kumarniloy1798 3 года назад +2

    Love from Bangladesh
    thank you very much for your work and sharing with us.

  • @allenxd
    @allenxd 2 года назад

    Hey Rana! Hope you're well! just want to say I love your content! Very clear explanation!
    Keep it up! subbed!

  • @yahyamrafe5603
    @yahyamrafe5603 3 года назад +1

    Wow, palestinian woman, who Explain a vulnerability best than any other one
    thanks angel, grateful from Jordan

  • @myoaye6225
    @myoaye6225 Год назад +1

    Thanks for the great video, Rana. Really appreciate it for your effort! Please keep it up

  • @christopherrodriguez6545
    @christopherrodriguez6545 2 года назад

    Thank you so much for your videos. You are doing a Great service for the community.

  • @MsDelta5000
    @MsDelta5000 3 года назад +1

    Thanks, Rana, for posting these series of burp-suite lab, very useful for me, the explained content is very precise and understandable, I will keep track of all them.,Once again, thanks you very much., indeed

  • @ramkuruva9079
    @ramkuruva9079 3 года назад

    As soon as I saw your first video, searched for the subscribe button ... Love from INDIA.. I am a newbie and felt so much comfortable , will continue to learn from all your videos only.

  • @baybars4392
    @baybars4392 3 года назад +7

    It is very nice that you explain the subject with the pre-solution sampling method and explain the question with more than one solution rather than one solution. I am starting to understand SQL better. Thank you for your hard work. Will there be a solution video for other issues after the SQLi series is over?

  • @B0llull0s
    @B0llull0s Год назад

    thank you!! what a amazing tutorial! the best by far!!

  • @TrevThorpe
    @TrevThorpe Год назад

    Thanks for the walk through, it was helpful for the project I am working on.

  • @mahditabatabai9458
    @mahditabatabai9458 2 года назад

    thanks rana .such a hardwork and lovely teacher 🙏❤️

  • @momo-dm3rw
    @momo-dm3rw 3 года назад

    thank you very much for your work and sharing with us.

  • @freeguy37
    @freeguy37 3 года назад

    Great! Love from India!

  • @anygsam8778
    @anygsam8778 2 года назад +1

    Very suitable video for beginners, thanks

  • @savagesavage6923
    @savagesavage6923 Год назад

    Great thanks, it helps me to understand basics!

  • @qaiserkhan4860
    @qaiserkhan4860 Год назад

    Awesome .Keep uploading

  • @natalliakisel-zagoryanskya8868
    @natalliakisel-zagoryanskya8868 7 месяцев назад

    Thank you so much! You are just a Greate Teacher!

  • @LearnTermux
    @LearnTermux 2 года назад +1

    thank you so much for teach us in such a nice way😍...i love your explanation 🐧

  • @faridlannabi
    @faridlannabi 2 года назад

    Merci Hana !

  • @cyozdemir113
    @cyozdemir113 Год назад

    Lovely demonstration, thanks a lot.

  • @amjadal-kadhi1199
    @amjadal-kadhi1199 2 года назад

    Excellent presentation... well done

  • @deepakjindal7701
    @deepakjindal7701 3 года назад

    Thank you it was great you made from starting and good explanation with introduction. @ Rana Khalil

  • @Shahid-qj4nj
    @Shahid-qj4nj 3 года назад +1

    Perfection 🥰

  • @clarkkent6083
    @clarkkent6083 2 года назад

    super interesting, I had no idea how to complete this on port swigger's academy

  • @xtlyk
    @xtlyk 2 года назад

    Thank you ! Best wish for you .

  • @pitercompany7344
    @pitercompany7344 Год назад

    I want to say THANK YOU.

  • @farhadsobhanifard3304
    @farhadsobhanifard3304 2 года назад

    very good - thanks

  • @hackerninjaking2617
    @hackerninjaking2617 Год назад

    Thank you ma'am 😊

  • @acronproject
    @acronproject Год назад

    Thanks for this

  • @paco6266
    @paco6266 Год назад

    👏👏👏👏 Me encanta 👍

  • @Jay-ht9zk
    @Jay-ht9zk 2 года назад

    Do you need Burp Professional for the certification exam ?

  • @alotofbaddayz
    @alotofbaddayz 2 месяца назад

    thanks holy cow!

  • @themrkumar
    @themrkumar Год назад +1

    Why we need to know how many columns will be returned by the query. can we do sqli Union attack without knowing it ?

  • @shiprasoni5668
    @shiprasoni5668 3 года назад

    Hello Rana , I have a question but before I want to tell you that I have became fan of yours . keep up the good work!

    • @shurikensage
      @shurikensage 7 месяцев назад

      There is more than one gift

  • @VarunArora14
    @VarunArora14 3 года назад

    Hi, in 15:40 how did you add the plus(+) sign like the way you did by selecting text and suddenly plus sign took the position of spaces?

  • @hichamafif6852
    @hichamafif6852 Год назад

    the best

  • @suzannemarshall8959
    @suzannemarshall8959 2 года назад

    I am running burp suite community V 2022. 1. 1 when i use the built in browser it wont let me run the lab. Can anyone help?

  • @jacobsamuel4092
    @jacobsamuel4092 Год назад

    what if we still get a 404 even after '-- ?

  • @passerby1553
    @passerby1553 2 года назад

    I followed the steps on both options I got 200 ok but the lab wont say its solved

  • @paco6266
    @paco6266 Год назад

    Y eso que no tengo ni idea de ingles, ni de pyton. Te voy reproduciendo y traduciendo a cámara lenta 🤷‍♂

  • @correabuscar
    @correabuscar Год назад

    not gonna lie, I really wanted to know what happened if the plus sign wasn't used

    • @correabuscar
      @correabuscar Год назад

      and now I know:
      HTTP/1.1 400 Bad Request
      Content-Type: application/json; charset=utf-8
      Connection: close
      Content-Length: 16
      "Protocol error"

  • @chozen_juan
    @chozen_juan 2 года назад

    16:30 you're welcome

  • @jwd42
    @jwd42 10 месяцев назад +1

    You make it more complicated in this video