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

332

6y

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

gitpush

32687

6y

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

314

6y

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

gitpush

32687

6y

@ardnahcimor that was harsh :P
0

Sankalp179

95

6y

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

TylerDDevRant

1884

6y

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

Root

82994

6y

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

cha-m-ra

1062

6y

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