PHP Account Activation by Email: Require the User to Confirm their Email Before They Can Log In

Learn how to develop functionality in PHP that requires a user to confirm their email address before they can login.
Once they sign up, they'll have to click on a link in an email to activate their account. If they don't do that, they can't login.
Please consider supporting my channel:
☕ ko-fi.com/davehollingworth
This is part 3 of Signup and Login with PHP and MySQL:
Part 1: Signup and Login with PHP and MySQL:
‣ • Signup and Login with ...
Part 2: PHP Password Reset by Email:
‣ • PHP Password Reset by ...
Code shown in the video:
‣ github.com/daveh/php-account-...
00:00 Introduction
00:20 Starting Point
01:16 How it will work
01:59 Database changes
02:40 Initial Code
02:58 Generate Activation Token
04:21 Change Signup Success
04:45 Send Activation Email
06:35 Activate the Account
08:17 Prevent Login Until Activated
09:46 Summary
#PHP #MySQL #signup #login #activation

[@collenzaligway4458]

This is a great video. Keep doing this man, will support you

[@ahooton]

Hi Dave, I've worked through your PHP courses which eventually lead to me learning Laravel and completing my first project using this framework. I found the framework quite easy to grasp and had an idea of what goes on under the hood. This is all thanks to your teaching. I would recommend to anyone that they first learn PHP / MVC, then move onto a framework when you understand the concepts. These videos are a nice refresher of the topics I first learnt from you. Thanks!

[@mlindatech]

I have just received a notification of the video...❤. Just watching it now...man you are a great teacher. You are straight to the point no blah blah 😅😅

[@joosepkunder]

Thank you, Dave! It is useful.:)

[@danieligbinidu6880]

Cool video from a great teacher 😎😄

[@alalyrealestate1136]

Great as always 🍰🍰🍰

[@HashimJAVEDBUTT-ip7jm]

Excellent 👍 Teacher. You have made the php so much easy ."

[@RoterFruchtZwerg]

Be aware that some e-mail providers actually try to access links sent in mails in order to scan these for malware. This might introduce a security issue here. Having a user actually pressing a button to confirm the token would be better. GET shouldn't modify users data 😉

[@alalyrealestate1136]

Really great

[@lokmankhan3626]

Your Video is very useful

[@elvis_v]

Hey Dave, thanks for your videos, they are the perfect starting point for me learning PHP. I saw on your profile you are open to ideas for new videos. I have looked for a video about how to learn (the right way) to built some kind of time booking logic. For example managing appointments or booking meeting rooms, etc. But haven't been able to find one, which is near the quality of your content. It could be a very generic solution just to showcase how the proper approach to such a project would be. Basically just CRUD for time bookings, doesn't even have to be shown on a calender in the front-end or something.

[@dave-hollingworth]

Great idea - I do have a PHP CRUD video on my list, I'll see if I can get round to doing it sooner rather than later

[@DiHardyRushes]

Very cool! Thanks a lot :)

[@jasonramirez6182]

Thankyou soo much

[@jamestrey3049]

so awesome

[@firasgasmy1229]

😂Dave your amaizing🤣

[@garminizator]

Mate, may I suggest a tutorial on creating/displaying more user-friendly URLs in PHP? These PHP tutorials of yours have been of a huge assistance for me and I'm at a point at which I should really get the user-friendly URLs done to hide the IDs and PHP files from the URL and I'd love to see such tutorial from you as your explanations are beyond fantastic. And thank you for this tutorial as well, this too is something I needed and was about to start looking things up online on how to get it done, but now I won't need to since everything I need is right here.

[@dave-hollingworth]

That's a great idea - I am doing this as part of my upcoming PHP MVC course update, but a standalone video on KZbin will fit well I think. Thank you for the suggestion!

[@tanzimibthesam5861]

​@@dave-hollingworth hae Dave will update be for mvc course ?

[@dave-hollingworth]

@@tanzimibthesam5861 Yes I'm currently working on updating the MVC course

[@boulaidabdessamad9003]

This is a helpful tutorial, i can't install phpmailer with composer, i'll look for the files to include and i will give it a try

[@dave-hollingworth]

This is part 3. Part 1 is here: Signup and Login with PHP and MySQL: ‣ kzbin.info/www/bejne/a32chpuFo9qiqZI and part 2 is here: PHP Password Reset by Email: ‣ kzbin.info/www/bejne/iGrFl6epbr95oNU

[@sarmadkinany4867]

I love your lessons and videos! Thank you for putting the time and effort in creating them! One question: any chance you could provide some info (release date) of “php MVC Framework from scratch” course adapted for php8?

[@dave-hollingworth]

I can't give a specific date, but I am working on it right now - I would hope in the next month or two!

[@sarmadkinany4867]

@@dave-hollingworth that is good info, thank you! :)

[@abdelhamidnehlil7277]

merci

[@emmanuelterdoomzer6309]

I took the Codeigniter 4 course and it was nothing short of amazing! I like your teaching style Dave. One thing though, I'm wondering if the PHP/MVC course are ok to be taken in 2023? Are they up-to-date?

[@dave-hollingworth]

The concepts in the PHP MVC course are relevant, but some of the code is a little out of date. I am working on updating the course right now, I hope to have it ready soon (in a month or two hopefully)

[@emmanuelterdoomzer6309]

@@dave-hollingworth Thank you for the reply. I will be looking forward to the release.

[@emmanuelterdoomzer6309]

@@dave-hollingworth Pardon me please. Do we also expect an update to the PHP Unit Testing course?

[@dave-hollingworth]

@@emmanuelterdoomzer6309Eventually, yes, but I can't say when that will be available I'm afraid

[@jamestrey3049]

in the next video, I hope it will be a tutorial of how to resend messages in case there will be an error sending message from the admin mail

[@mounir101]

Pretty awesome! Please, could you make a video about PHPslim framework? Thank you

[@dave-hollingworth]

Great idea, I'll add it to my list!

[@forex-ity]

I would like to create a member profile page and add some basic information about the members account. Do you have any resources?

[@dave-hollingworth]

I'm afraid I don't at the moment, but that's a good idea for another video, I'll make a note of it

[@NeilMohammad]

please create a tutorial on how to store qr-code in the database based on your last video about creating qr-code please sir.

[@alalyrealestate1136]

Do you have a full php course ? and oop in php also ?

[@dave-hollingworth]

Full PHP course is here: www.udemy.com/course/php-for-beginners-/?referralCode=17940C6990C841C140EC and full PHP MVC course is here: www.udemy.com/course/php-mvc-from-scratch/?referralCode=79E182F5C6C90EB6A3FE (which I'll be updating very soon)

[@victorsempereguilabert9127]

I need a database file, the file is not on github

[@user-qs8be1dp5i]

Hello Sir, Is there any possibility that we can send fax using php as we send mail using php mailer??

[@dave-hollingworth]

I've never done it, but it looks like there are ways: medium.com/ringcentral-developers/programmatic-methods-to-sending-a-fax-in-php-49a2aeed23fa

[@sakshitathorat2544]

Sir I'm getting sql error

[@shadow-gx4ul]

Can you give me the name of the code editor please?

[@dave-hollingworth]

Visual Studio Code

[@shadow-gx4ul]

@@dave-hollingworth thanks