In our database we have a 'user' table with username, password, email, etc columns. From the start we have always encrypted a user password into the database before storing it. This has been troublesome for our staff when a user asks what their password is, we can only reset it for them.
So for the past two months I have modified our login script to capture the plain text password our users are entering upon successful login. Is there an easy way to match the user id from my new passwords table and overwrite it with the encrypted password in the user table?
Data looks like this:
user_id | username | password | email | etc
user_id | password
I want to copy all of the passwords from `password_helper` and overwrite the password rows that match with the user_id from the `user` table.