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?
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.