37:29 Two things: - Instead of echoing the message and using exit(); after you should just use die("insert message here"); - After the if statement, you could just remove the else statement due the command inside the if statement, because if there is infact an error it will stop the script thus being useless to make an else and just continue the script normally Besides that loved it!
I have spent hours trawling through the many TH-cam tutorials on how to set up a login system using php. This is by far the most useful and comprehensive presentation. Very easy to follow. You clearly have a great depth of knowledge. When I first saw the tutorial duration of over an hour I was hesitant. You had me captured for the full extent of the course. Hats off to you mate.
*I was waiting for this episode. I made a **_Signup_** and **_Login_** system by watching your previous video. I have also watched the whole playlist of PHP but couldn't understand one video where you explained **_How to upload and change profile picture._** Could you please make another video on that? Thank you for your all efforts and time. Learned a lot.*
For anyone getting the issue --- PHP Fatal error: Uncaught Error: Call to undefined function mysqli_stmt_get_result() --- You have to have the PHP extension "nd_mysqli" enabled. Took me a while to figure this out. Hope this helps save someone time~!
By far the most enjoyable tutorials on TH-cam that I have experienced so far! Your voice is also very nice to listen to, and you have a nice equipment. Also, glad that you're using a camera, so the courses feel more natural. Your videos are helping me a lot in my CMS Website college project. Looking forward to more videos from you! :) Happy holidays!
Great tutorials! And to give something back: a) == break b) bind is an irregular verb so => bind / bound / bound not "binded". c) !== "pointy arrow thingies, they are called chevrons or angle brackets. But really amazing tutorials! :D
Great Lesson. I do have 3 questions on the parts you have made an in video notice: 58:13 - Note to the viewer - I forgot to close the php using ; Is this correct (create-new-password.php):
You did this tutorial for me bro,, i have a reporting system that i developed using your tutorials, everything else works but i was stuck trying to figure out how to make reset password,,, u a freaking freaking genius,,
This was perfect! I don't want to make a forget password system but instead I needed to know how to send and email by PHP with the click of a button. I am creating a sort of ticket system that will give users a reply via email.
The only challenge am facing is that the link for the password reset can only be send to Webmail server the reset password link can't be send to a Gmail and mostly people use Gmail so that was the challenge. I love your tutorial and I have been following for long time. Thanks may Almighty God bless you. Like right now am in school and those things you are saying is same thing so I found it simple.
Great video Daniel. Don't stop saying *"Inside Of Here"* I like it, your easy to understand. I watched this as a refresher and it was just what I needed. I look forward to the next video, from down here in little old NZ.
This is the first time I comment on a tutorial ever .. your video cam handy to me and on time (This is one thing I need to thank you for) The other thing is your knowledge and the willing to share in a very nice organized way. I am from Egypt and am sending you lots of respect. Stay Blessed
Thank you soooo much Dani Krossing! I've been trying to figure out for the longest why php mail function doesn't send emails and how to configure it to send emails.
Awesome! Can't wait to run though this tonight. Btw, idea that I would like to eventually see is interaction with session users like maybe a chat system or something. You have the best content, thanks for all your tutorials!
Just wanted to give a shout out and a thank you. This tutorial was extremely easy to follow and I was able to incorporate this into my existing project without any problem. Thank you!!
Thanks for the video. I created my forgot password system about 6 months before. It uses OTP system and it’s working awesome. Still awesome video. I learned a bit more
Outstanding - thank you, like this better than my current temp password with forced change on login. Your tutorials have been the best I've watched. You don't just say do this, this and this - you also explain why and most don't do that. Suggested add - check to see if user exists before doing anything ;)
I loved the video. It worked for me though for me i used PHP mailer to send the email. KEEP IT UP. I love how you explain the concepts in a very simple way
Great tutorial as always Daniel. Quick query - should we not have checked that the email actually exists in the users database, before going though this process? Thanks for the continued high quality teaching :-)
First...I love all your Video's on PHP, HTML, CSS! Tnx. I like you to make a video on: How to create *"Authorized Users" and *"Access to Pages"; so you can decide on which page members have entrance or not! I think it's a nice follow-up on your Login System ! thank's in advance, Gerrit (webmaster Bazeja)
I've seen your all most of the tutorials from start to now, thank you for such a informative and useful video!! I had been paid for the lesson tutorials, learn a lots. Looked forward to the newest video come out, support you!!! And thank you for sharing and teaching in youtube ~
I 'actually' went through this twice, thoroughly. The first time as show, then I learned the OOP login system, then I went through this again and put it into the OOP paradigm. I did take some time from step to step to make sure I had it right, but it really wasn't too hard either. Thank you, it gave the codeholic in me a🙂 good fix and a good step forward.
Wauw! Cudos to you!💯 I tried the same, because the rest of my website is all OOP. Unfortunately, I'm stuck at this part of the video: 1:10:31 if (!$row = mysqli_fetch_assoc($result)) For some reason I can not fetch the row inside my table. I hope I will find that annoying bug soon 😅
Hey that's awesome you got it man. Unfortunately I get Linux notifications that this portion at 15:15 of code is outdated, granted it's an old video. I haven't had time to research the updated version yet, just wanted to comment and ask if you had recieved an updated version.
Great videos. Could you also show an implementation of a 2 factor authentication login system? There are no good tutorials for an updated Google Authenticator 2FA php implementation.
I love following your work and am currently a Patreon subscriber. I'm just a little frustrated! The 2 scripts I wanted to use - Login and this current one, however mysqli_stmt_get_result() is not supported on my server and my host says they don't offer this unless I move from a shared server. I'm sure people will just say move host but that's not really an option. It would be so good to get a full PDO version of the Forgotten Password at some stage as I've tried writing tons of workarounds this mysqli_stmt_get_result() but nothing gives a satisfactory result. Thanks though for all the tutorials. Brian
I had exactly the same problem! And my host also said they don't offer this I become a Patreon subscriber and asked mmtuts to give some alternative, but unfortunately he doesnt even answer any question inside the Patreon website... I hope him or somenone of his team read this and give us some workaround!
@@eugeniodecastrooficial Make sure you get your money back if he doesn't bother answering you. I checked the site but it is clear there is some information missed off with so many people have the same problem at line 34.
This is marvelous.but user need to be a existing user who was already signed up in the system.this does not check against it.anyway appreciate ur work.i have learned a lot from you. Keep it up. Huge thumbs up 👍
Great tutorial! I got it running. One thing to note, my version of mySQL doesn't allow table names to be capitalized, yet you named your table pwdReset , this throws a table not found error on my machine. To find and capture mysqli errors append mysqli_stmt_error($stmt) to your error message.
Thank you man for you videos . But in e-mail if you don't have HTTPS in url-reset-link you can't click it. ( You probably know, but it's complicated and long to explain ) Thanks again, you are a treasure .
I got this work, though i got PHP version problems with this, but it did reset my password with PHP 7.2, once i made some configurations on it... It worked perfectly with my own database, which is much more different, than your version of login system, but i got the point while coding...only i took database config for resetting, and it seemed work just as it should be.
A great tutorial, well explained. The code I've patterned after yours fails at the point of fetching the row from the result object, and I've spent two days trying to figure out why. My error trapping shows everything is good up to the creation of the result object, but no row can be fetched. Since the table only has one row, and the result object instantiates without error, why can't I pull the row out of it? I've tried various mysqli_fetch alternatives. They all fail. I've researched the crap out this and nothing. Sure could use some help if you have any suggestions.
wait wait wait wait, 1800 seconds != 1 hour hehe its == 30 Minutes :) but nevertheless he is actually the best programming teacher i know on here thanks to you buddy, you make coding as easy as possible :) love watching ur videos
Thanks for a wonderful tutorial once again Dani. I do have a couple of questions though ? 1. If you have a users table, why not just use that and the users email as a selector - rather than create a seperate table and generate a new selector - which is tied to the users email address anyway ? 2. Why the crypto-secure hashed token ? At the end of the day, the only person that gets to use this in order to reset the password is the person who has access to the email account. So if the email account is comprimised - the user has big problems anyway ?
Hi Dani. Thanks for the great Tutorials. Just a few questions. When you check for errors in an IF first and stop executing when an error happen, why do you continue with an ELSE? It is not really necessary. Also why do you not use SWITCH-CASE instead of many IF-ELSE following each other?
Thanks, I learn from your tutorials all the time. Just have a question. Maybe I'm wrong, but don't you want first to try and delete the password-reset-token from the database BEFORE update the user's password? because otherwise if you first update the password and then the SQL fail to delete the token, you now have a user that can login AND has a reset token in the db. What do you think?
Deleting it before won't have a difference effect than deleting it after :) The order in this case has the same effect, so if your SQL fails before updating the users password, then we still have a token in the database. Instead, if you want to be absolutely sure you deleted the token, you just need to make sure that you run the proper error handlers to make sure you check if you deleted the token or not. But it is really not that important here, because the code either works for all users or it doesn't. Meaning that we would be able to tell by looking at the database if all tokens created never gets deleted. Then we just fix the code from here if this happens :)
For anyone viewing this in 2020, you can do your prepared statements as such: if ($stmt = $con->prepare('SELECT * FROM users WHERE email=?')) { $stmt->bind_param('s', $email); $stmt->execute();
} //For results add: $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { //code here } Remember the while loop will run as many times as there are # of results / rows
Hi I am Loving your tutorial approach to explaining the forgot Password coding. Just one thing I would like to know and that is the structure of the "users" table. You don't mention it in this video. Is it contained in another video? Could you help me out with this. Cheers, Mick
Really nice, is it possible you show how to make the signup form check if the e-mail already exists in our database? Because I can sign up with the same e-mail on multiple accounts. Thank you Daniel, love your vids, learning a lot.
hey, what about all the expired tokens that might be stored in the db and were never used by the users that requested them? Example: I requested 10 times password reset and never reset my password. Shouldn't these be somehow removed after an hour somehow from the db? Excellent video! Thx!
Great videos as always. I've not seem them all, so I suspect you have already done this what I'm about to request. Is there a document or video that shows all of the packages you install with Sublime and your Sublime custom configuration? Thanks!
Do you have any videos on dealing with the php reset password for open source social network. It seems like they already have a set up but idk what has to change in order for it to work n i was trying to follow along in this video cause you have taught me allot but this one, this one right here has my brain hurtin lol
Thank you! In the PHP Section I think there was enough to learn, even there is much more. So, i will repeat my Idea, that I wrote somewhere else in your Videos... "Why not to make a video or Playlist like "Learn PHP, MySQL, Javascript,Ajax,JQuery, including basics of HTML and CSS"". So all them together in, of course not to repeat the videos or tutorials you allready did. Anyway, its just an Idea:)
I think it was your comment that made me decide to create a new playlist for each course, ment for project based videos like the I uploaded here. I have been working on recreating the structure of my courses so they would only have lessons related to learning the language in them :) in short, yes I remember your comment and I'm looking into it ;)
Hi man. Thanks for all the tutorials - you're great. I have just implemented the registration+reset system thanks to your tuts. Please confirm if it would be better to also check if the user has already been registered by email? If there are 2 users with same email, that means that when reseting password --- passwords of both registered lines in database will be reset. Much love
We have the whole row. I grabbed the unique id from the users table and did my update based on that where condition instead of email. It guarantees we will not update more than 1 row. Only problem I see is if two people with the same email requested password change at the same time you will get two rows returned on the lookup, but my signup reject a request if the email already exists, so it shouldn't happen.
@mmtus this was very helpful , do you have a tutorial on how to pull individual user files/content/docs from folders and view them on their profiles or on the homepage , any recommendations ?
Hey man, thanks for this great content, really insightful. Though, i have a problem. in reset-password.php after the query, when we bind $selector, $currentDate and execute the statement no rows are being found, i tried redoing it and stackoverflow, but no answers lol, basically my "if(!$row = mysqli_fetch_assoc($result))" falls under the echo message where row shows an empty array, help please.
same Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in C:\xampp\htdocs\Jahstagram\includes eset-password.src.php on line 29 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\Jahstagram\includes eset-password.src.php on line 33 You need to re-submit your reset request!!!
Hi Dani, at 1:08:52 you mention you forgot to include the $currentDate but added it later off camera. Can you just show me where you added it please? I love the whole video, but if I cant follow 100% its not gonna help me... EDIT: wait sorry, after using my head I saw what I had to do. Its working PERFECTLY now!! Thanx for creating amazing videos!!
I would just like to ask, why is it that inside the it is different from the last video tutorial about creating a complete login system? I double check it with the last video it is different, what should be followed? Thank you! God bless!
Hello, thanks for that in depth videos. I am having issues with password reset, I am able to get the email to the user. But when the user receives the email to reset the password, they get a 404 error. Not sure why, any ways to fix it? Not sure how I’m getting a 404 error when the page exists.
I managed to get my first job as a web developer after an internship and I owe you a lot, man. Your tutorials are clear, clean, and very useful.
how do i get an intership?
37:29 Two things:
- Instead of echoing the message and using exit(); after you should just use die("insert message here");
- After the if statement, you could just remove the else statement due the command inside the if statement, because if there is infact an error it will stop the script thus being useless to make an else and just continue the script normally
Besides that loved it!
I have spent hours trawling through the many TH-cam tutorials on how to set up a login system using php. This is by far the most useful and comprehensive presentation. Very easy to follow. You clearly have a great depth of knowledge. When I first saw the tutorial duration of over an hour I was hesitant. You had me captured for the full extent of the course. Hats off to you mate.
Ideas for next tutorials..
*Adding security questions
*PHPMailer
*CURL
*PHP Forum
*SMS API (sms tokens)
I like your videos..keep it coming
*I was waiting for this episode. I made a **_Signup_** and **_Login_** system by watching your previous video. I have also watched the whole playlist of PHP but couldn't understand one video where you explained **_How to upload and change profile picture._** Could you please make another video on that? Thank you for your all efforts and time. Learned a lot.*
For anyone getting the issue --- PHP Fatal error: Uncaught Error: Call to undefined function mysqli_stmt_get_result() --- You have to have the PHP extension "nd_mysqli" enabled. Took me a while to figure this out. Hope this helps save someone time~!
i have similar problem, please can you elaborately explain how to enable nd_mysqli
Thanks teacher
I really appreciate you and your tutorials.
By far the most enjoyable tutorials on TH-cam that I have experienced so far!
Your voice is also very nice to listen to, and you have a nice equipment. Also, glad that you're using a camera, so the courses feel more natural.
Your videos are helping me a lot in my CMS Website college project.
Looking forward to more videos from you! :)
Happy holidays!
My guy you are one of the best php teachers here on youtube.May Mudzimu bless you .
Great tutorials! And to give something back:
a) == break
b) bind is an irregular verb so => bind / bound / bound not "binded".
c) !== "pointy arrow thingies, they are called chevrons or angle brackets.
But really amazing tutorials! :D
Great Lesson. I do have 3 questions on the parts you have made an in video notice:
58:13 - Note to the viewer - I forgot to close the php using ;
Is this correct (create-new-password.php):
I'm from Brazil and thanks to your videos, i got a job in PHP.
You did this tutorial for me bro,, i have a reporting system that i developed using your tutorials, everything else works but i was stuck trying to figure out how to make reset password,,, u a freaking freaking genius,,
lol my name is also Terry and I feel the same + had similar issues hehe
This was perfect! I don't want to make a forget password system but instead I needed to know how to send and email by PHP with the click of a button. I am creating a sort of ticket system that will give users a reply via email.
Use PHPMailer to do that
Such a great series of PHP tutorials. You are a great educator, thanks for doing this. Helped me immensely with my project.
We would love to have you teach us the other way of doing this (i.e. without tokens)...
So, I'm eagerly waiting for it...
And......
Get Well Soon!!!!
You almost started my new career in web development. Thank you so much and please do more videos like it
The only challenge am facing is that the link for the password reset can only be send to Webmail server the reset password link can't be send to a Gmail and mostly people use Gmail so that was the challenge.
I love your tutorial and I have been following for long time. Thanks may Almighty God bless you. Like right now am in school and those things you are saying is same thing so I found it simple.
Great video Daniel. Don't stop saying *"Inside Of Here"* I like it, your easy to understand. I watched this as a refresher and it was just what I needed. I look forward to the next video, from down here in little old NZ.
I've been waiting for this video for so long! thank you man, you're the best at teaching PHP.
woww..nvr seen such a quality content for free...hatss off.u rock daniel
This tutorial is so informative, well understandable and just nice to watch. I never saw a tutorial like those. Thank you :)
I would like to request for a video on how to create a Php blog and also admin panel for it. Thanks alot for your awesome tutorials.
This is the first time I comment on a tutorial ever .. your video cam handy to me and on time (This is one thing I need to thank you for) The other thing is your knowledge and the willing to share in a very nice organized way.
I am from Egypt and am sending you lots of respect.
Stay Blessed
Thank you soooo much Dani Krossing! I've been trying to figure out for the longest why php mail function doesn't send emails and how to configure it to send emails.
All of your teachings make this very easy to adapt to any needs :) thank you again!
this works even with phalcon using mvc and routing
Hey Dani i just wanted to say that i'm learning so much things from your videos, thanks for this awesome content!
I must thank you for your generosity. I've been following your tutorials and like very much your method. Keep on that track!
Awesome! Can't wait to run though this tonight. Btw, idea that I would like to eventually see is interaction with session users like maybe a chat system or something. You have the best content, thanks for all your tutorials!
Was never really inspired to to try webdev till I came across your channel. Thanks a lot.
Just wanted to give a shout out and a thank you. This tutorial was extremely easy to follow and I was able to incorporate this into my existing project without any problem. Thank you!!
Thanks for the video. I created my forgot password system about 6 months before. It uses OTP system and it’s working awesome. Still awesome video. I learned a bit more
Outstanding - thank you, like this better than my current temp password with forced change on login. Your tutorials have been the best I've watched. You don't just say do this, this and this - you also explain why and most don't do that.
Suggested add - check to see if user exists before doing anything ;)
I was also wondering why he didn't check if the email actually exists in the database before inserting it into the "pwdReset" table !
25:20 isn't an hour 3600 seconds? 1800 seconds should be half an hour.
I loved the video. It worked for me though for me i used PHP mailer to send the email. KEEP IT UP. I love how you explain the concepts in a very simple way
Best/clear voice and best breakdown/explanation. Keep up the good work bruuh!
Great tutorial as always Daniel. Quick query - should we not have checked that the email actually exists in the users database, before going though this process? Thanks for the continued high quality teaching :-)
Yes you should :)
First...I love all your Video's on PHP, HTML, CSS! Tnx.
I like you to make a video on:
How to create *"Authorized Users" and *"Access to Pages"; so you can decide on which page members have entrance or not!
I think it's a nice follow-up on your Login System !
thank's in advance, Gerrit (webmaster Bazeja)
Inside of this video ;) you gave a lot of useful information (as usually). Thanks a lot!
I've seen your all most of the tutorials from start to now, thank you for such a informative and useful video!!
I had been paid for the lesson tutorials, learn a lots. Looked forward to the newest video come out, support you!!! And thank you for sharing and teaching in youtube ~
I 'actually' went through this twice, thoroughly. The first time as show, then I learned the OOP login system, then I went through this again and put it into the OOP paradigm. I did take some time from step to step to make sure I had it right, but it really wasn't too hard either. Thank you, it gave the codeholic in me a🙂 good fix and a good step forward.
Wauw! Cudos to you!💯
I tried the same, because the rest of my website is all OOP.
Unfortunately, I'm stuck at this part of the video: 1:10:31
if (!$row = mysqli_fetch_assoc($result))
For some reason I can not fetch the row inside my table.
I hope I will find that annoying bug soon 😅
Hey that's awesome you got it man. Unfortunately I get Linux notifications that this portion at 15:15 of code is outdated, granted it's an old video. I haven't had time to research the updated version yet, just wanted to comment and ask if you had recieved an updated version.
I am waiting for your user profile tutorial when are you going to release it?
Great man... Really waiting for your upcoming php videos.. You are the best👍
This was great, two questions. Looks like expires was never used and Is the selector validator dual thing just to add some complexity for hackers?
Great videos. Could you also show an implementation of a 2 factor authentication login system? There are no good tutorials for an updated Google Authenticator 2FA php implementation.
I love following your work and am currently a Patreon subscriber. I'm just a little frustrated! The 2 scripts I wanted to use - Login and this current one, however mysqli_stmt_get_result() is not supported on my server and my host says they don't offer this unless I move from a shared server. I'm sure people will just say move host but that's not really an option. It would be so good to get a full PDO version of the Forgotten Password at some stage as I've tried writing tons of workarounds this mysqli_stmt_get_result() but nothing gives a satisfactory result. Thanks though for all the tutorials. Brian
I had exactly the same problem! And my host also said they don't offer this I become a Patreon subscriber and asked mmtuts to give some alternative, but unfortunately he doesnt even answer any question inside the Patreon website... I hope him or somenone of his team read this and give us some workaround!
@@eugeniodecastrooficial Make sure you get your money back if he doesn't bother answering you. I checked the site but it is clear there is some information missed off with so many people have the same problem at line 34.
This is marvelous.but user need to be a existing user who was already signed up in the system.this does not check against it.anyway appreciate ur work.i have learned a lot from you. Keep it up. Huge thumbs up 👍
Great tutorial! I got it running. One thing to note, my version of mySQL doesn't allow table names to be capitalized, yet you named your table pwdReset , this throws a table not found error on my machine. To find and capture mysqli errors append mysqli_stmt_error($stmt) to your error message.
Great work thanks alot for the goodwork.
Success and error messages are not displaying yet there is no error and I have done it exactly as you did.
Thank you man for you videos . But in e-mail if you don't have HTTPS in url-reset-link you can't click it. ( You probably know, but it's complicated and long to explain ) Thanks again, you are a treasure .
I got this work, though i got PHP version problems with this, but it did reset my password with PHP 7.2, once i made some configurations on it... It worked perfectly with my own database, which is much more different, than
your version of login system, but i got the point while coding...only i took database config for resetting, and it seemed work just as it should be.
Thanks for the great tutorial as usual, one question do you have a tutorial on creating php shopping cart using MVC model?
Very very useful Dani. Thank. I hope to impliment this on my site(s) soon. I still need a profile page yet.
Wonderful tutorial...Excellent teacher. Thank you for helping out. You are appreciated
As a beginner I found this video very useful. Thank you very much!
A great tutorial, well explained. The code I've patterned after yours fails at the point of fetching the row from the result object, and I've spent two days trying to figure out why. My error trapping shows everything is good up to the creation of the result object, but no row can be fetched. Since the table only has one row, and the result object instantiates without error, why can't I pull the row out of it? I've tried various mysqli_fetch alternatives. They all fail. I've researched the crap out this and nothing. Sure could use some help if you have any suggestions.
I have the same problem. Did you find any solutions?
Me too😢@Dani_Krossing Please help us!🙏
For me, this is the most powerful tutorial. keep it up.
wait wait wait wait, 1800 seconds != 1 hour hehe its == 30 Minutes :)
but nevertheless he is actually the best programming teacher i know on here
thanks to you buddy, you make coding as easy as possible :)
love watching ur videos
Hey, I learnt a lot with you video. I implemented your algorithm with Angularr as Frontend and PHP as Backend. Thank you very much :)
Thanks for a wonderful tutorial once again Dani. I do have a couple of questions though ? 1. If you have a users table, why not just use that and the users email as a selector - rather than create a seperate table and generate a new selector - which is tied to the users email address anyway ? 2. Why the crypto-secure hashed token ? At the end of the day, the only person that gets to use this in order to reset the password is the person who has access to the email account. So if the email account is comprimised - the user has big problems anyway ?
Its ok - figured it out now :)
Hi Dani. Thanks for the great Tutorials. Just a few questions. When you check for errors in an IF first and stop executing when an error happen, why do you continue with an ELSE? It is not really necessary. Also why do you not use SWITCH-CASE instead of many IF-ELSE following each other?
There's also match in PHP8 much concise than switch
How cool is this tutorial. Paid stuff for free!!! Thank you Dani.
Excellent work Dani. Very clearly explained and very good information. It really does make life easier. Thanks.
you are very helpful to us, as a beginner keep it up bro. thumbs up
Thanks, I learn from your tutorials all the time. Just have a question. Maybe I'm wrong, but don't you want first to try and delete the password-reset-token from the database BEFORE update the user's password? because otherwise if you first update the password and then the SQL fail to delete the token, you now have a user that can login AND has a reset token in the db. What do you think?
Deleting it before won't have a difference effect than deleting it after :) The order in this case has the same effect, so if your SQL fails before updating the users password, then we still have a token in the database.
Instead, if you want to be absolutely sure you deleted the token, you just need to make sure that you run the proper error handlers to make sure you check if you deleted the token or not. But it is really not that important here, because the code either works for all users or it doesn't. Meaning that we would be able to tell by looking at the database if all tokens created never gets deleted. Then we just fix the code from here if this happens :)
@@Dani_Krossing I would use a PDO transaction.
@@HEKuiper then why don't YOU do a tutorial. He chose this route. I'm glad he did.
For anyone viewing this in 2020, you can do your prepared statements as such:
if ($stmt = $con->prepare('SELECT * FROM users WHERE email=?')) {
$stmt->bind_param('s', $email);
$stmt->execute();
}
//For results add:
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) { //code here
}
Remember the while loop will run as many times as there are # of results / rows
Great, now I am pronouncing "password" just like you.
Hi I am Loving your tutorial approach to explaining the forgot Password coding.
Just one thing I would like to know and that is the structure of the "users" table.
You don't mention it in this video.
Is it contained in another video?
Could you help me out with this.
Cheers,
Mick
He covers that in the PHP Login tutorial
Please can u do more tutorials like this it's really helpful , like e-store
Your Voice Sounds amazing , Can you please share which microphone are you using right now ?
Really nice, is it possible you show how to make the signup form check if the e-mail already exists in our database? Because I can sign up with the same e-mail on multiple accounts.
Thank you Daniel, love your vids, learning a lot.
hey, what about all the expired tokens that might be stored in the db and were never used by the users that requested them? Example: I requested 10 times password reset and never reset my password. Shouldn't these be somehow removed after an hour somehow from the db?
Excellent video!
Thx!
man, you are a fuck**g legend. no one does this kind of videos so easy and most of all educative way. thank you and keep it up
Great videos as always. I've not seem them all, so I suspect you have already done this what I'm about to request. Is there a document or video that shows all of the packages you install with Sublime and your Sublime custom configuration? Thanks!
Do you have any videos on dealing with the php reset password for open source social network. It seems like they already have a set up but idk what has to change in order for it to work n i was trying to follow along in this video cause you have taught me allot but this one, this one right here has my brain hurtin lol
hats off for you my man....i appreciate your work and effort you put in your tutorials.
Thank you!
In the PHP Section I think there was enough to learn, even there is much more. So, i will repeat my Idea, that I wrote somewhere else in your Videos... "Why not to make a video or Playlist like "Learn PHP, MySQL, Javascript,Ajax,JQuery, including basics of HTML and CSS"". So all them together in, of course not to repeat the videos or tutorials you allready did.
Anyway, its just an Idea:)
I think it was your comment that made me decide to create a new playlist for each course, ment for project based videos like the I uploaded here. I have been working on recreating the structure of my courses so they would only have lessons related to learning the language in them :) in short, yes I remember your comment and I'm looking into it ;)
You are a perfect teacher. Thank you for all
Oldie but Goldie
THank you so so much I learnt alot of things Clean Code THANK AGAIN ! Teacher
Hi man. Thanks for all the tutorials - you're great. I have just implemented the registration+reset system thanks to your tuts. Please confirm if it would be better to also check if the user has already been registered by email? If there are 2 users with same email, that means that when reseting password --- passwords of both registered lines in database will be reset. Much love
We have the whole row. I grabbed the unique id from the users table and did my update based on that where condition instead of email. It guarantees we will not update more than 1 row. Only problem I see is if two people with the same email requested password change at the same time you will get two rows returned on the lookup, but my signup reject a request if the email already exists, so it shouldn't happen.
that was a very well explained video :). Thank you very much for such content!
@mmtus this was very helpful , do you have a tutorial on how to pull individual user files/content/docs from folders and view them on their profiles or on the homepage , any recommendations ?
Keep up the good work! Excellent tutorials.
Thank you it is very helpful.., I love to watch all your tutorials
pro tutorial thanks well explained better than many college teachers , +1 subscriber
Great tutorial but would be great if, at some point in time, you were able to create this same tutorial in PDO. Thanks again.
Thanks Dani... Superb Tutorial
Great and dynamic tutorials. Please keep sharing your videos, Thank you!
Thanks for this a lot. could you please make a video on email verification with this method?
Hey man, thanks for this great content, really insightful. Though, i have a problem. in reset-password.php after the query, when we bind $selector, $currentDate and execute the statement no rows are being found, i tried redoing it and stackoverflow, but no answers lol, basically my "if(!$row = mysqli_fetch_assoc($result))" falls under the echo message where row shows an empty array, help please.
I got same problem .i tried lots of ways but not success .if you find the solution please let me know
I also had the same problem
same
Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in C:\xampp\htdocs\Jahstagram\includes
eset-password.src.php on line 29
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\Jahstagram\includes
eset-password.src.php on line 33
You need to re-submit your reset request!!!
same.
check if you added date or not: mysqli_stmt_bind_param($stmt, "ss", $selector, $currentDate);
1:08:52 he made a mistake here
This is the best tutorial! Very helpful!
Outstanding and incredibly clear. Thanks, man! Keep running! :)
Thank you very much for this video sir...
Please can you do a video on PHP AUTOMATIC UPDATE SYSTEM EVERY 24HRS
Hi Dani, at 1:08:52 you mention you forgot to include the $currentDate but added it later off camera. Can you just show me where you added it please? I love the whole video, but if I cant follow 100% its not gonna help me... EDIT: wait sorry, after using my head I saw what I had to do. Its working PERFECTLY now!! Thanx for creating amazing videos!!
can you tell me where did you put it please?
mysqli_stmt_bind_param($stmt, "ss", $selector, $currentDate);
I finally finished and understood the video. Thanks for the great tutorials !
I would just like to ask, why is it that inside the it is different from the last video tutorial about creating a complete login system? I double check it with the last video it is different, what should be followed? Thank you! God bless!
Hello, thanks for that in depth videos. I am having issues with password reset, I am able to get the email to the user. But when the user receives the email to reset the password, they get a 404 error. Not sure why, any ways to fix it? Not sure how I’m getting a 404 error when the page exists.
I asked on the login tutorial if you do a forgotten password link and just like magic, here it is lol
Great tutorial though, just for clarity where should the $currentDate var be??