Username: 
Password: 
Restrict session to IP 

Double query  Go to the Training: MySQL II challenge

Global Rank: 79
Totalscore: 201114
Posts: 1
Thanks: 1
UpVotes: 1
Registered: 15y 47d





Last Seen: 161d 21h
The User is Offline
Double query
Google/translate1Thank You!1Good Post!0Bad Post! link
I'm trying to inject a second command that will get executed after the select, but before the password check. Am I on the right track?
This works locally for me, but when I try it on wechall I get an "GDO 1064". Is there something "blocking" executing two queries with the command "queryFirst"?
Global Rank: 227
Totalscore: 94360
Posts: 1684
Thanks: 1360
UpVotes: 920
Registered: 16y 314d




Last Seen: 1d 10h
The User is Offline
RE: Double query
Google/translate0Thank You!1Good Post!0Bad Post! link
You cannot execute two queries in a single query.
This is a limitation, once introduced for security, in mysql/mysqli (if i recall correctly)

Most other languages and their mysql bindings should have the same limits.

I googled a bit and it seems that it would be possible.

Take a look at https://stackoverflow.com/questions/802437/how-to-execute-two-mysql-queries-as-one-in-php-mysql
The geeks shall inherit the properties and methods of object earth.
Global Rank: 14900
Totalscore: 110
Posts: 1
Thanks: 1
UpVotes: 1
Registered: 6y 197d
Last Seen: 6y 195d
The User is Offline
RE: Double query
Google/translate1Thank You!1Good Post!0Bad Post! link
with the username, I can use the sql injection, but I don't know how to bypass the password check.
Global Rank: 1
Totalscore: 758910
Posts: 437
Thanks: 497
UpVotes: 470
Registered: 15y 152d












The User is Offline
RE: Double query
Google/translate1Thank You!1Good Post!0Bad Post! link
exp32, that is not a question. It also does not relate to the topic of this thread.

Perhaps research SQLi a bit more?
Global Rank: 227
Totalscore: 94360
Posts: 1684
Thanks: 1360
UpVotes: 920
Registered: 16y 314d




Last Seen: 1d 10h
The User is Offline
RE: Double query
Google/translate0Thank You!1Good Post!0Bad Post! link
@exp32: Just make your sent data fulfil the password check.... at least that's what i want you todo ;)
The geeks shall inherit the properties and methods of object earth.
tunelko, Redknee, silenttrack, n0tHappy, nonfungiblesecurity, quangntenemy, TheHiveMind, Z, balicocat, Ge0, samuraiblanco, arraez, jcquinterov, hophuocthinh, alfamen2, burhanudinn123, Ben_Dover, stephanduran89, braddie0, SwolloW, dangarbri, csuquvq have subscribed to this thread and receive emails on new posts.
1 people are watching the thread at the moment.
This thread has been viewed 4162 times.