Password matching problem when accessing DB from an App
Posted: 2020-11-03 16:33
I need to access the DataBase from an App and prior to ver 5.90 I use to do the query:
" ... WHERE memberID='$user' AND passMD5='".md5($password)."' AND isApproved=1 AND isBanned=0 " and it always worked.
I can see that the new version 5.90 is using password_hash($password,PASSWORD_DEFAULT) so I am using this instead but I can not get it to run because the results are different.
The hashed password with the function does not match the one saved in the table (which was created/updated with the 5.90 version).
What am I missing?
" ... WHERE memberID='$user' AND passMD5='".md5($password)."' AND isApproved=1 AND isBanned=0 " and it always worked.
I can see that the new version 5.90 is using password_hash($password,PASSWORD_DEFAULT) so I am using this instead but I can not get it to run because the results are different.
The hashed password with the function does not match the one saved in the table (which was created/updated with the 5.90 version).
What am I missing?