Empty set is returned when set condition for password

Question

Im quite new in mysql

I have inserted values into my table customer

INSERT INTO customer(f_name, l_name, mobilehp, username, password)
VALUES
('Ahmad', 'Ali', '013-5404997', 'A_Ali', SHA('something'));

Then I inserted a condition,

select customer_id, f_name FROM customer WHERE password=SHA('something');

However the query returned empty set which is weird when it supposed to display customer_id and f_name. So any help would be greatly appreciated. Thanks

https://stackoverflow.com/questions/46020448/which-method-to-use-to-encrypt-passwords-in-mysql-database/46021602 — Ron Beyer, Nov 22 '21 at 02:35
@MursyidNasir https://www.php.net/manual/en/ref.password.php — vee, Nov 22 '21 at 02:35
or [ref](https://code-boxx.com/password-encrypt-decrypt-php/) — danblack, Nov 22 '21 at 02:39
What have you tried to resolve the problem? Why is this even tagged with PHP, but does not contain a single line of PHP code? — Nico Haase, Nov 24 '21 at 14:50

score -1 · Answer 1 · answered Nov 24 '21 at 14:48

-1

Do not use sha1 for passwords. Use password_hash or other crypto algorithm. sha1 is unsecure.

select customer_id, f_name, password FROM customer WHERE f_name = 'Ahmad';

Then check password.

See comments in links https://www.php.net/manual/en/function.password-hash.php https://www.php.net/manual/en/function.password-verify

answered Nov 24 '21 at 14:48

Sergei Martinov

35
3

Even if SHA1 should not be used, this does not explain why the two queries do not work – Nico Haase Nov 24 '21 at 14:50

Empty set is returned when set condition for password

1 Answers1