Login System Tutorial with PHP and MYSQL Database

[@clevertechie]

To all the people who are asking about not getting account verification email. You need to modify php.ini and set your email and email host settings. Here are my settings: SMTP = smtp.west.cox.net smtp_port = 25 sendmail_from = [e-mail] You need to find out what your SMTP is and configure accordingly.

[@shak80z58]

Thank you for following up on comments. Could you plz help me understand why i get this error Fatal error: Call to undefined method mysqli::error() in /home/mark87/public_html/login-system/register.php on line 19 Nothing happens when i take () at end.

[@clevertechie]

Yes, removing the round brackets fixes it because there is no method error() if mysqli class, there is only property error, so it's a typo in the tutorial.

[@joshuabenedicto4358]

Where can I find the file or where can I view the message response during the verification phase?

[@TeBateDoamneDoamne]

i've changed that and still not sending mail . i did change my SMTP to gmail SMTP and send mail with one of my emails and the port is the same .

[@helloworld8428]

where is the php.ini file? Do I have to create it?

[@BucurIonNiculae]

finally someone who makes in system a forgotten password. Nice job man.

[@Knightfire66]

yeah thats really helpfull... but whats with double password input to be sure that the user gives in the right password ?!

[@joyceonyeri4678]

Excellent tutorial. Well done Clever.

[@antonykiokomusyoka8162]

@@joyceonyeri4678 Hi! kindly share the source code zip I tried to download they want $5? email: [e-mail]

[@mohammedehsan5533]

After watching the video, I think, KZbin can introduce "double Like" or "Multiple Like" option. Had there been any Multiple-Like option I would have clicked that. I have watched many Login, Registration types of HTML-PHP- CSS tutorial. But Clever Techie's one is I feel, the best specially the beautifully color coded diagram is a superb work by the presenter. This diagram clears out confusions very quickly. It is one of the keys to success. Thank you Clever Techie.

[@ganeshkondalkar7995]

This tutorial is really awesome! :) "To all the people who are asking about not getting account verification email": It worked for me after I added the 4th param to mail() function. // Code Sample here $headers = "From: "; mail( $to, $subject, $message_body, $headers ); Note: I have also configured the SMTP as given below. There is one more article which says, you need to Right click > properties: /sendmail/sendmail.exe. right click > properties > compatibility > Check "Run this program in compatibility mode for "Windows XP (Service Pack 3)". Restart system, start the xampp server and done!

[@KeepSkippin]

I already built a register/login system in php in another tutorial, but this one seems 100 times better yet the video is a lot shorter than the other one, good job!

[@clevertechie]

Thank you :)

[@alexandermayorga2918]

Excellent Tutorial! The chart was very helpful to understand the workflow and what's going on at each step. Im a front end dev and was looking for a login system tutorial to implement at work for an internal dashboard. This definitely helped a lot :)

[@madyxter8258]

To all those who are redirected to index.php , when implementing this into website i had the same problem then i re anlalize all the code and found the solution. You just have to put session_start(); in the starting of php coding of registration.php page. And you are good to go... 😊

[@angelocabaysa9400]

I hope this tutorial will help all beginners who wants to learn PHP. Thank you Clever Techie for this tutorial

[@arihasan3423]

Thanks for sharing this amazing video!! People like you who really teach others how to code. You explain everything in detail, and it shows that you have a clear understanding of your work. Keep doing this great job!!

[@eantwi6215]

Great tutorial man! I especially liked how you (perhaps unintentionally) subtly demonstrated variations of the 'if' statement, freestyled debugging with print_r() or die, etc. ONLY ONE THING RE: that sql syntax error you made at the end, you forgot to add a space between (WHERE email='$email' AND" . "hash='$hash') during concatenation, and ended up changing the sql statement to update the hash variable with the new password. Some people unfamiliar with SQL might miss that. Other than that SMALL detail, AWESOMENESS through and through.

[@cristhiancantillo4922]

This is the most detail tutorial i ever saw. Nice job

[@liljohnx3475]

My apologies if you have already answered this, but I would like to have the verification email send to me instead of the person logging-in (in this case a student). Context: I am a teacher and attempting to create a login that will only allow students from 1 particular class to register and sign-in. At some point I would love to figure out how to use the Google id sign-in, but that is a separate question. So ideally I would need: 1. email sent to me with name and email of student applicant containing an approve or deny function; 2. email sent to student to let them know that their request is being processed; and finally, (I hope) 3. an email to let them know that their registration has been approved or denied, or that there was an error of somekind. Also, thank you for this video!! I am actually a SOCI professor trying to figure out how to make materials online accessible for students. PHP doesn't come intuitively, so videos such as these are a massive help! Best regards... oh this is where I got stuck: early in the game i know.

[@guylemay1471]

Thanks for the offer.... I will be looking elsewhere for free tutorials on these subjects, which by the way are available to all from people who have given their times to help others enjoy the Internet Experience.

[@emanandchill]

This tutorial is free. What are you talking about?

[@guylemay1471]

@@emanandchill And I just gave you a FREE comment ....now we are even! =>=>=> Download this video's files here: www.patreon.com/posts/login-s...

[@0xC]

@@guylemay1471 $5 for an entire login system with a guy explaining it. What's not to love?

[@veetoutas]

Sir, You are incredible. I have just checked Your website. Can't thank You enough for giving away the knowledge!

[@ILIILLLIIILL]

I learnt this from other tutorials. it is good for study by compare lots of codes and designs. Thanks!

[@clevertechie]

No problem

[@RealToughCandy]

This video is freaking awesome! Thank you for producing and sharing this! I don't even know why KZbin allows thumbs/up down ratings for vids like this, it should be the option to click Like and that's it.

[@AbdullahBiler27]

you cannot imagine how useful this thing is! Thanks a lot!

[@Gamesational1]

The video that got me into web development!

[@clevertechie]

Awesome to hear that!

[@sharksean6363]

Due to special reason I cannot download the code from your website~ So I can only type the code in the video, but I found that not all the codes(or pages) were included... But... JUST RIGHT like that, I finished the missing codes and pages by my understanding, also I fixed something wrong with the codes(may be caused by the missing codes)... ...Thanks! This video helps me a lot! Your codes is nice and concise, Thank you!

[@theberend21]

literaly the best login video I've ever seen and used, Thank You!

[@Terry1212]

Nice tutorial. Just a couple things to consider: email and email hash should have UNIQUE indexes. This will prevent duplicates from being inserted into the database. The PHP code does perform a check on the email, but not the email hash. md5(rand(0, 1000) gives a total of 1001 possible email hashes that can be inserted into the database. As more people register, the odds of a duplicate being inserted increase.

[@yoshis3760]

Detailed information and useful for who want to coding Subscribe to this guy!

[@claudiobras22]

Hi Clever, I followed your tutorial, and I have to say, It´s very helpful. and thanks for including the file. One more thing, When I loaded the index.php page without internet connection, and clicked the signup button i didnt show the signup page. and then i connected the internet it was working.

[@NoMoreShada]

Superb Dude! You have done hardwork to make video simpler as possible

[@EclipticalD]

You really put an effort into this. I really liked and found it very helpful. Thanks!

[@michestanol9862]

Thanks for having this video, now I have an idea on my next project. thanks @Clever Techie

[@jsr7599]

Incredibly helpful and comprehensive, thank you!

[@ddstutorials6048]

I wish I could like this video more than once! Thanks for taking the time to make this and your other awesome tutorials.

[@klausi1115]

dataspecialist open 2 account lmao

[@mansurbhamani3905]

Excellent Clever Techie. It works fine. Good job. Well done.

[@DoubleBob]

Great quality content and I love how you go the extra mile (e.g. graphs and explanations). Subscribed.

[@ronymuliana]

Good tutorial! Try logging in with wrong password on purpose, and you will get "You have typed the wrong password" message. Then log in with the correct password. The same error message will still show again. So in error.php I added a line "unset($_SESSION['message'];" right after the echo $_SESSION['message']; Thanks,

[@devanshisukhija7375]

Really appreciate what you do.. you made everything really easy for me .. thanks a ton.. never stop doing what you doing... thumbs up!!

[@karlcarloshuderz]

Amazing tutorial with all the helping images and the free source code, so you can implement it very fast. Thanks a lot!

[@clevertechie]

No problem, I try to make them fun and useful.

[@haisuno]

i already liked your video once i saw the system chart , really GREAT JOB , it makes it super comprehensible!! btw how did you do it ? using a software or a website or what ?

[@erichernandez5659]

Nice presentation, it was well explained and structured. I do have a question about logging out. you didn't go into detail about that. Will you be doing a presentation on that?

[@rackdevelopment]

For the people wondering why when clicking signup it is not working, at the bottom of index.php you need to update the jquery. Replace the link that is there for it with this: cdnjs.cloudflare.com/ajax/libs/jquery/2.1.4/jquery.min.js

[@curtisjordan9210]

What flowchart software did you use? Thanks.

[@kevgits]

Great work! You forgot to explain the profile.php page though.

[@idontwantmynameinhere]

Hi, I'm interested in the program you used to make the chart which shows what happens where. I think it's a really clean way to show myself what happens when and where.

[@dsushik]

Great tutorial! Can you tell me what program you used to create the chart?

[@clevertechie]

MindJet

[@jimconnors]

great video, quick question - what do you use to generate the login system chart @2:05 in the video?

[@blablablahut]

One of the best tutorials I have ever seen! Thank you very much.

[@clevertechie]

No problem, thank you for watching :)

[@oscardudley5114]

Hey, really great tutorial. This is one of the first videos I have actually found on this topic where the guy speaking is actually audible + easy to understand. Thanks for that. However, I am having some trouble with the email verification. Is it possible you could make a separate tutorial teaching us how to set it up? Thanks again.

[@Allright303]

Great work, thank you very much!

[@dangerosa01]

Exellent video! just a question. Why do you mix between php and html ? The idea is to separate the view and the model

[@cecaniacc9165]

Thank god this code be save offline so i can still study this even tho i am in school(my teacher isn't helpful at all) Thank you so much, i hope this work

[@anonshot3264]

Welcome Back!

[@13XFACEX31]

Great Channel, your videos are very easy to follow. Does the user registration check if a user already exists with the given username / email?

[@Vortex-qb2se]

But where the data saves? In my computer? Wheb someone log into his acc will it save his pass and stuff on my pc??

[@ocskon]

best tutorial for php. thank you.

[@TechAlphax]

If you got the mail verification right please share the knowledge.

[@frankspeechhastheevidence6383]

Can you make another video updating to PDO?

[@jacobcrosby101]

The location to download the code is locked out.

[@latutioti]

Great tutorial, thank you. I will be definitely trying it out.

[@roycas3]

simply awesome.! good work

[@andyclement40]

you're a legend mate

[@varcodex45]

Wonderful tutorials. Its amazing. Nice explanation. Thanks.

[@Knych-nr4ot]

Great video!!! I am new to HTML,CSS and PHP programming and still has a lot to learn. I am currently working on Wordpress and CPanel where our website is hosted. I already have some of the webpages setup using Wordpress(using the add page), is there a way for me to use the login page and somehow integrate the database on the login page itself? I have seen some of video tutorials in youtube where the login page already have the Database connection defined on it but im not sure how it will call the other pages, once passed the login page(where the codes are defined via text editor) Thanks a lot!!

[@AAJohnsonCODES-SKILLS]

I suggest you should teach us one after the other and the meaning of each function, but with this method, you used to teach us assumed that all us must have known the basic, but it might be wrong.

[@TriWaZe]

From my understanding using escape_string is not very good protection from sql injection. Should use prepared statements.

[@matthewjey5900]

Hi dear. Thank you for making and sharing this useful video. After I read your code, I found a problem in it. The problem is when you insert a hash into database for a user, you never change and update it. And if a hacker finds the hash code, they can reset the user's password whenever they want. In other words, the hash code should be used just once and be changed after using. Please reply if I'm wrong. Thank you so much.

[@kaushikbiswas9556]

But I must say..... this is very educational.... thank you for your efforts.

[@konstantinoskaragiannis8134]

Which software you used to make the software diagram; Nice tutorial, keep up.

[@ne12bot94]

Excellent job on the video, keep up the amazing job

[@2parinda]

Very Clear explanation. appreciate your effort. Great!

[@clevertechie]

Thank you

[@eleven6262]

THANK YOU!! YOUR TUTORIALS ARE GREAT!!

[@clevertechie]

Glad you liked it :)

[@tribiec]

Very very good video man!, thanks a lot

[@kevinrauer]

Amazing video.. what about an update to use PDO??

[@md.mujahidulislammujahid2105]

Many Many thanks brother. I am very glad to get your source code.. and also have been integrate my web portal. so unlimited thanks.

[@namelessone1811]

Tried to get the ebook and never get a confirmation email? Tried 3 times. What did you draft the login-system-chart.png? Image software or some kinda drafting software it looks great and easy to read.

[@GRHood]

thanks for awesome video, it helps me a lot, is there any way to add this page checkbox and connecting to database, or do you have any suggested documentation about that best

[@robertbajo9474]

Great job mate!

[@maksnazarenko9474]

Hi, if you go step by step as described in the article, then you can make a registration? Do I need to buy?

[@hieuthanh4936]

Very helpful. Thanks !

[@gamgnamstile]

Hi, you didn't show "profile.php", is it possible to see how did you confirm "logged" status there?

[@myangel_mylife]

amazing...keep uploading such video

[@lorellhathcock]

Greetings! Just watched this video and it inspired me to go become a Patreon subscriber. It is pretty straight forward to follow along and put the files on my server. What is not clear is the integration between the system and my existing web pages. What code should I add in my existing webpages to force them to interact with the login system? Thanks!

[@branchyapple]

Cool video man!

[@hirephpdevelopers3840]

Thank you for the informative tutorial. I'll be back later for some great stuff.

[@СергейМаклаков-р9т]

Dear SIr, thank you very interesting and useful tutorial. Unfortunately there is no zip (attachment). How is possible to cet it?

[@jaepark75]

Clever Techie What flow chart are you using? Is there a link for that?

[@sandou1daffe258]

Hello Sir! I need your help for CSS code for your pages, we don't see your logout.php and profile.php page code, and you have not process the automatic connexion;THANK

[@djamparo6636]

Boy I love you! Keep it going!

[@TechAlphax]

Mr. Clever, numbers asking about the mail verification is enough reason to at least provide detailed description on how to fix this. Does this work on both local and external webservers? Thanks.

[@JasonPurkiss]

This was great thanks until i realised i had to sit there and configure post fix on my Ubuntu server to send the email which made my day perhaps you could do a follow up tut for others that dont work that out, thanks again and enjoy the 5 pounds :)

[@harishdhulipalla3087]

Great Tutorial. But why don't you update the hash value after reseting the password. I mean you can reset your password without opening the mail since email and hash are same all the time i.e in history we can see the parameters right?

[@kevinperry9425]

Hi! Thumbs Up Techie!... Everything works properly unless if it is not directed to HTTPS: when it becomes secure, the Signup button on the index no longer works. Any ideas?

[@raymondeguagie3042]

How can i download the video files, it's not working from the link you gave?

[@christiancastanares3536]

So helpful thanks man.

[@llBestBoyll]

really nice one 👏🏼

[@akonyajohn5042]

thank you sir... i needed this.. especially how to deal with forgot password... thank you...

[@immortalpvp]

Great video! Everything working fine, but i have a question.... How do i add another page to it, but only allow logged in users to access it? Thanks!

[@jeffj7287]

Hi, good video and you explain really well. Though I have one question that bothered me during the entire video. And it isn't even related to the lesson here. The chart that you show, what is the software that you used for it. I find it is clean and organized. I'm just wondering what's the name of the software or the website you used for it. Thanks

[@clevertechie]

The software is called MindJet

[@qixit5878]

Awesome tutorials! Keep it up!

[@albagdesign]

Thank you very much your video helps me alot

[@m4gg197]

CSS skills Nice video

[@anmolpanna]

Ton of thanks!

[@hariharanthiagarajan7181]

Hi Clever Techie, Just wondering, what is the name of the software you used to create the flow chart at the beginning of the video - Explaining the process flow.

[@xangly1861]

Clever Techie, your tutorial is very helpful. May I know what software did you use to create the login chart with a file extension .png? Thanks.

[@halamostafa937]

thank you so much , this is such a great system!

[@abcdg5030]

this is some really great content, thank you very much!