PDO不关心大写/小写字母

Question

So i've got a MYSQL query which looks like

SELECT * FROM users WHERE login=:login and password=:password

I am using PDO and no matter in which way I will write a password it will select it, like if I've got "passWord" in database and my :password will be "password" it will still get it, any solution how to fix it?

Answer 1

This issue is that your field in the database is not case sensitive. You can fix that with this statement...

ALTER TABLE users CHANGE password password VARCHAR(50) BINARY NOT NULL;

On as side note, if you are dealing with passwords I suggest you hash them, Here is the link.