sql - Who has replaced a dot with a semicolon while composing a SQL query in php? Me. 😤😤😤😤😤 Two hours spent in - devRant

Ranter

Comments

4

user11001

329

7y

That query will crash if there are semicolons in the filename. Or quotes. Better start using PDO
1

gitpush

31934

7y

I'm not a php dev, but shouldn't queries go inside service instead of inside php web page? even though it is not returned with the result page
2

ardnahcimor

307

7y

Thanks for telling us, I'll never hire you
1

gitpush

31934

7y

@ardnahcimor that was harsh :P
0

Sankalp179

94

7y

You could have figured it out in a matter of minutes, next time just copy paste sql in phpmyadmin or workbench
3

TylerDDevRant

1861

7y

And this is how you suffer from sql-injection attacks
xD
2

Root

79767

7y

Never use concatenation to build SQL queries.
Not even at gunpoint.
0

cha-m-ra

1052

7y

Are you sure that's a good way to execute the SQL query?? I feel can be SQL injection attack

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service