that challenge pretty hard for me without hint from comment :)) but okay, im done

Paradoxically it's pretty easy to solve this using sqlmap, picking correct table to inject and that's all. Also, it was fun and some practical lesson abt SQL injection. Very Good Challenge bro!

It was a pain for me but did it finally

sqlinjection is easy for me :V

Give me an answer, friends. I'm tired of trying to find it

I'm master in union based sql injection

sqlmap is carring

as a hint try finding number of columns, try union and then try finding table name, then column name and then find column name from table name

try not to use any tool do it manually for better learning

Good Challenge i used splmap in Linux

Hello,

I have a doubt.

when given an id, it returns 3 text values (name,breed and color). When I try the payload (id=1+union+select+'a','b','c','d') why is it returning nothing.

because since when an id is given it is returning text values the result from the union operation should be text values or union query will fail.

but when I use the below payload it is working fine. id=1+union+select+1,2,3,4

the above query should cause error and should not give any results. But the app is returning 1,2,3 values on to the website.

What is happening here? Could anyone explain me?

Thanks

inplace of 1 in id=1+union+select+1,2,3,4 I have used 'a'. SO the query now is

id=1+union+select+'a',2,3,4. <---- This is returning 0 results.

But when I use below query it is returning table names.

id=1+union+select+table_name,2,3,4 from information_schema.tables <---- returns table names

No idea why. Could someone please explain?

THanks

If you're struggling, the concepts on this blog are explained very nicely-

Exploiting SQL Injection: a Hands-on Example

You're the best!

hmmm I just started doing all the techniques in the article but it's not working for me nearly in the same way

you're great, bro

Found this very difficult, took me lots of research to solve. Site mentioned in comments was helpful. In the end got much better at understanding sql stuff and am ready to break the interweb.

Very awesome and one of the CTF in this website!!

I swear i knew sql for sqli like 2 months ago and i just forgot most of it ☠️

show tables in information_schema.tables then show column in information_schema.columns

Hello,

I have a doubt.

when given an id, it returns 3 text values (name,breed and color). When I try the payload (id=1+union+select+'a','b','c','d') why is it returning nothing.

because since when an id is given it is returning text values the result from the union operation should be text values or union query will fail.

but when I use the below payload it is working fine. id=1+union+select+1,2,3,4

the above query should cause error and should not give any results. But the app is returning 1,2,3 values on to the website.

What is happening here? Could anyone explain me?

Thanks

quick update:- inplace of 1 in id=1+union+select+1,2,3,4 I have used 'a'. SO the query now is

id=1+union+select+'a',2,3,4. <---- This is returning 0 results.

But when I use below query it is returning table names.

id=1+union+select+table_name,2,3,4 from information_schema.tables <---- returns table names

No idea why. Could someone please explain?

THanks

Because the sever use mysql_real_escape_string, which will change the quotation marks. You need to encode string to hex, i.e. id=1+union+select+0x61,0x62,0x63,0x64.

I don't know if you solved it yet but you inspired me, thanks.