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 :)

[@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!!

[@cristhiancantillo4922]

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

[@curtisjordan9210]

What flowchart software did you use? Thanks.

[@AbdullahBiler27]

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

[@jimconnors]

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

[@veetoutas]

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

[@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... 😊

[@dsushik]

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

[@clevertechie]

MindJet

[@theberend21]

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

[@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.

[@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.

[@NoMoreShada]

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

[@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??

[@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

[@raymondeguagie3042]

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

[@ILIILLLIIILL]

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

[@clevertechie]

No problem

[@mansurbhamani3905]

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

[@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.

[@jaepark75]

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

[@gamgnamstile]

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

[@alittlebyte]

Hello, which software did you use to create that Login System PHP chart?

[@anonshot3264]

Welcome Back!

[@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.

[@_VISION.]

what mindmap is that you're using at the beginning of the video?

[@michestanol9862]

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

[@gorankavelj5917]

Do we need to change url at 16:40 if we are using XAMPP and if so what do we need to change it to.

[@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?

[@dangerosa01]

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

[@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.

[@rahuldev5118]

How did you create the login flow chart?Any recommendation of tools is appreciated.

[@clevertechie]

I used a software called MindJet

[@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?

[@tylereldred624]

what did he use to make those charts at 2:11?

[@DoubleBob]

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

[@blablablahut]

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

[@clevertechie]

No problem, thank you for watching :)

[@burner918]

What tool did you use for your sitemap where you have the structure of the login system with php files in yellow?

[@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

[@frankspeechhastheevidence6383]

Can you make another video updating to PDO?

[@streetfinance_zw]

HI, what theme plugin are you using for your netbeans?

[@maksnazarenko9474]

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

[@reubenkioko4545]

Hi, which software did you use to draw the chart? it is smooth and detailed i like it

[@emanandchill]

The type of chart is called a "Mind Map". There are several programs that make mind maps but I think he might be using the program: "Mindjet Mindmanager 2012", because that's what he has on his desktop in another video. That's my guess, but he might have upgraded. The good thing is that many programs are similar on the market.

[@mohammedajdir7602]

download script login system : maroc10.com/programme/index.htm

[@codingshadows]

hey ! 5:24 what program did you use to make that chart ?

[@emanandchill]

The type of chart is called a "Mind Map". There are several programs that make mind maps but I think he might be using the program: "Mindjet Mindmanager 2012", because that's what he has on his desktop in another video. That's my guess, but he might have upgraded. The good thing is that many programs are similar on the market.

[@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.

[@SAURABHSINGHRAJPUT50197]

Which editor you are using in this video at time = 7:49 Please reply fast.

[@randytech9752]

I see this was a year ago but the editor is Netbeans

[@jsr7599]

Incredibly helpful and comprehensive, thank you!

[@Riaz_kitchen]

Downloaded the source code but when I click on the sign up page it doesn’t work

[@jacobcrosby101]

The location to download the code is locked out.

[@Jontuzz]

What program did you use for making the login system structure on 2:44

[@dynfo]

I want to know too. It looks like a mental map software. Great video by the way, Clever Techie.

[@grexGER]

maybe smth like freeMind software

[@dynfo]

That's what I thought of, but it's not the same.

[@nickeax]

Maybe, because the text exists in it's own bounding box, all it took was a freemind screenshot and quick GIMP touch up?

[@omara229]

smh that's the command function in windows

[@EclipticalD]

You really put an effort into this. I really liked and found it very helpful. 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

[@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!!

[@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

[@jitendrakr]

How did you create the chart with the list of all files? Did you use a mind mapping tool?

[@clevertechie]

Yes, MindJet

[@TechAlphax]

A little help on mail verification please...

[@jk3gwapo]

hi! everything worked fine for me but I was wondering how would I add a background image? I've tried inserting background-image: linear-gradient(rgba(0,0,0,0.6)),url(img/bglogin.jpg); in body on the css file but it didn't work.

[@konstantinoskaragiannis8134]

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

[@moavazkhokhar5095]

can you tell me the tool name you used to create this diagram at 2: 14 ?

[@clevertechie]

Yes, it's called MindJet

[@moavazkhokhar5095]

thanks for reply love you

[@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.

[@kaushikbiswas9556]

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

[@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?

[@jonsitumorang8808]

Hi, how did you manage to have header function run after HTML tag without turning on output buffering?

[@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.

[@austinsehgal8683]

Do you have any tutorial on login authentication without CSS and without adding fancy stuff?

[@caffeholictj1708]

Uhm Excuse me can you tell me what are the tools and software needed there? thanks

[@prospeedorginal5371]

Hello Clever, i'm having a problem where when i put the source code in "login-system' in www folder (WAMP), it only errors. Any solutions?

[@ItsYaBOIIrcher]

what program do you use for viewing emails??

[@balenzrarabdulsamad9731]

Help 9:00 , i have a problem with some messages, for example once i fill registration form the message is not appear, for example once i write wrong password nothing appear to tell me your password is wrong, look minute 9:00 , Thank you!

[@dixie1018]

How do you get and localhost command thing up ? I do not know how to get it so I can do the MySql

[@C6MERON]

need to run a localhost. install xamp or MAMP look up tuts how to install hope this helps

[@mainchannel18452]

if you want to use localhost. you need some basic development environments like WAMP(for windows), XAMPP (for MAC and Windows)

[@michax575]

if you use XAMPP, go to c:\xampp\mysql\bin> instead of localhost

[@michax575]

furthermore the default user name is root and the default password is null (nothing)

[@pedrodevsodaghost9282]

Hello, fellow ROBLOXian!

[@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.

[@surfer2011]

the signup - function is not working ... i get "index.php:1 POST localhost/login-system/index.php 500 (Internal Server Error)" once i "register". My System is a Raspi with Raspbian and LAMP server

[@BorgKane]

Excellent video! Does this setup let you in the profile.php even if e-mail is not verified? What is the best way to enforce the e-mail verification before letting users enter the profile.php?

[@elitelifestyle9184]

sir, i have a problem regarding the registration, the code doesnt seem to insert the data in my database. after i clicked the register button it shows the error.php part. and also if you're so kind enough please send me the codes to that temporary database format. [e-mail] thanks in advance man!

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

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

[@johncarver7224]

What is the tool you are using for the mind map?

[@emanandchill]

There are several programs that make mind maps but I think he might be using the program: "Mindjet Mindmanager 2012", because that's what he has on his desktop in another video. That's my guess, but he might have upgraded. The good thing is that many programs are similar on the market.

[@randytech9752]

This is the one he used MapJet www.mindjet.com/webinar/create-organisational-charts-mindmanager/

[@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!

[@Gamesational1]

The video that got me into web development!

[@clevertechie]

Awesome to hear that!

[@devanshisukhija7375]

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

[@cecaniacc]

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

[@GB-gs5mt]

what platform are you using

[@victormbarba1]

Hi Clever Techie, I got your files. Thank you for this video. When I click on the E-mail field or any field, I see "This connection is not secure. Logins enter here can be compromised. I see the Grey Padlock, with a RED line across. I don't see the "Green Padlock" for secure web-sites. Could you please help me to understand why I don't have the green padlock, and how I can have a secure log in. Thank you.

[@noobonnoobcrime6169]

if you are on a remote server you will need to get a SSL certification in order to get that "Green Padlock"

[@yami4663]

Is there a way to manually add accounts to the database? Without using the register function.

[@victorjoyner8387]

I have completed the coding, the database is created on my phpmyadmin. The resister and log in buttons don'e do anything but send it back to the index.php page. What am I doing wrong?

[@randycarroll9833]

Hey Victor, if you move the code: ABOVE the tag. It will work. The problem is the code that redirects to the Profile page is a PHP header which MUST be BEFORE any HTML output. I will work if you make that update.

[@НадеждаТодорова-ц7е]

Heyy, Can you help me. When I hit register i get the following error Undefined variable: mysqli in C:\apache24\htdocs\loginsystem2 ew egister.php on line 12

[@andyclement40]

you're a legend mate

[@norbert3511]

Hi, why I am not getting any verification emails, have tried on multiple emails, but without success. Have also configured mailserver but still nothing. Any tips ???? Thanks in advance

[@dugies9056]

Hey, Can I use this as a free SOURCE CODE in my project? I disign a Quiz for my School so I would like to use this? IT is ok for YOU? LG DuGies

[@VarnexArts]

Lets say I were to use a host for my website and that host does not provide comand line access. So in order to create the database, I would need to login to phpmyadmin and create the database manually. How would I do that since I can not use the script that is provided withing the download that you linked.

[@erichter131]

Sign Up Log In is this a special kind of link? or are the links suppose to be to php files?

[@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?

[@strln5117]

do you have video with new style i mean with pdo???

[@manu111never]

@Clever Techie. When I try to sign in and push the register button its only reloading the index.php without any notification. I think, somehow it's not connecting with the register.php. Can you please help me!

[@rashmi1bhatt]

Hi, check your error log ( probably php_error.log) to find the exact problem. My page was blanking out too because of - headers already sent.... errror. If that's the error you are getting, just add ob_start() in the index.php file after start_session().

[@mohsinjaved185]

Sir i got a problem in your last video for regestration form when ever i click on regester button 2 time it will print same data on database 2 time how do i fix it ?? any Idea SIr ??? @Clever Techie

[@scottmusik]

How do i set up a mail server to get the sign up confirm email to work? Thank you

[@shadenmohammed7089]

at 6: 26 how to make localhost in the cmd?

[@Nautica216]

Hey Techie, how about debuging your code and update the .ZIP file and VIDEO?

[@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!