Difference between revisions of "PHP-and-MySQL/C4/User-Password-Change-Part-3/English-timed"

|This is the 3rd part of my '''Change password''' tutorial. In this part, we’re going to change the password in the database.

|We’re already connected here, so there’s no need to reconnect since that '''command''' has already been reissued.

|I’ll create a new query called “$query change” and that will be equal to “mysql_ query()" function.

|Now, this is a new bit of '''code'''.  So, I will scroll down so that you can see it easily.

|This is “UPDATE”.  So I’m going to say '''UPDATE users''' - which, you can see is our table - so to update our "users" table.

|I will say '''SET password''' equal to '$new password'

|Then I’ll say '''WHERE username''' is equal to the '$user' variable that I’ve got on my page currently.

|So, since we’ve already processed our php session,  

|This piece of code is basically  saying  “update the table, change the password to the new password entered by the user. – This is the password they want

|and change this “WHERE” to Alex,  

|So, this password will be changed because this "username" is equal to "Alex".

|So, this starts with 900 and as soon as we change it, we can refresh this and check that it actually has been changed.

|Let’s just put this back, up here.

|And I’ll kill the page and say '''die()''' and then say “Your password has been changed”.  

|Then I’ll put a link in saying “Return” and that’s going to return to the main page.

|So, “session_destroy()”.  

|The reason being, once the users have changed their password, this link will take them back to the main page and this will destroy the '''session'''.  

|So, they’ll need to login again using the new password.

|So, if we test this, remember in here, my current password is "abc" whose 'md5 hash' starts with 900.

|And if I go back here, write my old password- "abc", my new password "123" and click '''Change password''', we see that all the validation has been checked, our password has been changed and we get this message to return back to the main page.

|Now if I try to go back to the member page, you will see that you must be logged in. Our '''session''' has been destroyed as we used our “session destroy()” function here.  

|If I try "123", "you’re in!" and evidence of this is shown in here.

|Let’s just go back and click '''Browse'''.  Let's scroll down and we can see that the password has been changed from 900 to 202.  

|All you need to do is learn your "sql" queries properly.  I have tutorials on that too.

|So, really, there are a lot of checks you can do, but this is the basic skeleton for changing the password in php using a MySQL database.  

|Thanks for watching! This is Harini, dubbing for the Spoken Tutorial Project.