Simple signup and login system with PHP and Mysql database | Full Tutorial | How to & source code

here's how to create a simple signup and login system using PHP for your website. to add some security, watch this video: • PHP Login & signup web...
#PHP #MYSQL
Donate: paypal.me/quickcodechannel
Thank you :)
playlist:
0:00 - Intro
1:00 - Creating a database
3:50 - Creating website pages
5:30 - Index Page designing
8:30 - Login Page design
12:50 - Signup page design
14:00 - PHP coding begins
15:30 - Connect to the database
18:30 - Check login function
23:25 - Code for user signup
28:50 - User id creator function
31:30 - Test user signup
33:40 - Code for user login
37:28 - Test user login
38:28 - Add user welcome
39:28 - Code for user logout
41:00 - Final thoughts
source code:
drive.google.com/file/d/15Zrw...

[@QuickProgramming]

Watch this other video afterwards to learn about login security kzbin.info/www/bejne/pnqyYaOjgrl9bLs

[@hiteshlalwani2258]

Warning: mysqli_connect(): (HY000/1045): ProxySQL Error: Access denied for user 'root'@'2a02:4780:bad:f00d::e' (using password: NO) in /storage/ssd2/531/16866531/public_html/connection.php on line 8 failed to connect!

[@hiteshlalwani2258]

Getting this error bro now what to do

[@mohamedghazali4914]

@@hiteshlalwani2258 does your MySQL has a password? If it's yes write down

[@johnathandesouza5449]

@@mohamedghazali4914 where do I write it?

[@ESE7457]

please can you create another tutorial with profile page and other pages involved and how to upload and download vedios and images on other pages

[@Speed-TV]

Guy just casually creates a LOGIN system with a database then asks us if we've learned anything at the end. True legend.

[@QuickProgramming]

😁😂😂

[@navjotsinghDhanoa]

Day 5 of learning php and i am already able to setup user accounts. Brilliant stuff, thanks very much \m/

[@SugarKane9547]

Thank God I found your video. Most other tutorials jump straight into coding without showing how to actually link Notepad ++ , web pages and database. Your step by step guide has given me a very good foundation to build upon. I couldn't thank you enough. You are a start - God richly bless you.

[@QuickProgramming]

am happy to hear it was helpful. thanks for taking the time to leave some feedback! :)

[@Dearelephant]

Thank you for the tutorial! Unlike my teacher, I love how you are not hiding the mistakes and explain what went wrong.

[@QuickProgramming]

Thanks, I appreciate your feedback😊

[@paullol7146]

Finally someone who presents this in procedural form good job!

[@QuickProgramming]

thanks for the compliment :))

[@reeyanmaknojiya8921]

Thank you so much! This was extremely helpful! I have been dreading this project, but after following this tutorial and setting up everything correctly, I feel confident in completing it soon! Thanks once again!

[@QuickProgramming]

really glad to hear it. all the best and thanks for the feedback :))

[@adinaligaleimane9055]

Cant even describe how much this helped me understand php at last. Big thanks !

[@gregoryjohannes2984]

Absolutely amazing. Thank you very much for not only showing what you did, but explaining it. This helped out

[@QuickProgramming]

thank you for the awesome compliment and you're most welcome :)

[@NenadKralj]

absolutely perfectly said "hank you very much for not only showing what you did, but explaining it." exactly 🙏🏼

[@ed1026]

Thank you. I looked for a video like this for days, with such a good explanation, but couldn't find anything on KZbin. They didn't explain it as well as you did. Until I found you, I just thought THANKS God that I found him. Thanks bro, keep it up 👍.

[@QuickProgramming]

Thank you. Am glad you found it useful. Thanks for the feedback☺️

[@noobgameplay4801]

man you saved me! I was going to drop my web development course! Thanks a lot. Hope that you will do more videos like this...

[@QuickProgramming]

Am pleased to hear that🙂 I'll try and make more videos like this, thanks

[@cruelCase21]

finally a decent and comprehensive video, thank you so much!

[@Jack_Warner]

Just want to say this was a brilliant tutorial and everything worked perfectly.

[@ismailasanni4849]

Where have i been not to have seen this channel all along...this is the kind of class I want to be in. Giving explanation to everything makes one never to forget. You are a genius

[@QuickProgramming]

thank you so much for the awesome compliment :) i appreciate it

[@hiteshlalwani2258]

Warning: mysqli_connect(): (HY000/1045): ProxySQL Error: Access denied for user 'root'@'2a02:4780:bad:f00d::e' (using password: NO) in /storage/ssd2/531/16866531/public_html/connection.php on line 8 failed to connect! Getting this error bro

[@mizgurl1028]

oh my god, thank you so much!!! especially for showing how to set everything up b4 the code and for explaining it. I had no idea how to use php but i wanted to try to learn it to impress my teacher as we only know html, css, and a very brief introduction to js and this video has saved me so many days of work. I'm not kidding you don't understand how grateful I am for finding this video. THANK YOUUUUUUU!!!!!

[@QuickProgramming]

Am happy to hear it. You're most welcome and thanks for taking the time to leave some feedback😊

[@stevevazquez5997]

I'm glad I found this. Thanks for the whole explanation!

[@QuickProgramming]

most welcome

[@francisagada5810]

nobody can teach PHP like you do. Most tutorials I've seen are outdated. May you find what you're looking for. I am a self taught computer software engineer... much love, straight from Nigeria

[@invasivegmail1732]

You're absolutely brilliant! Thank you so much for sharing your expertise with us. You make it all look so easy.

[@QuickProgramming]

Thanks for the compliment and feedback, I appreciate it. And you're most welcome☺️😊

[@xiellesky5527]

thank you for this great boon! I was panicking on what I should do for a project and I'm just a beginner with php. Thank you for your help!

[@QuickProgramming]

Awesome! you're most welcome. i wish you all the best in becoming a pro in PHP :)

[@FruzzelLP]

Just the right thing I needed for my Web programming class!

[@QuickProgramming]

awesome!

[@muhahahahaha8986]

Only experts could do this thing, it's tricky a little but you make me from knowing nothing from php to know better of it!

[@drakhellfallen6365]

Thanks for the tutorials! easy to understand and a brilliant way of explaining things to the point where even beginners can easily follow.

[@QuickProgramming]

thank you, much appreciation for the awesome feedback

[@peterellis731]

Excellent Tutorial, just started building webpages, The functionality of forms is generally missing from many tutorials. This explained much thank you!

[@QuickProgramming]

Great to hear! thanks a million for your feedback :)

[@akhilshivnani7701]

Mindblowing tutorial! I wasn't able to find anything better than this! Thankyou so much!

[@QuickProgramming]

thank you, am really glad it was super useful :)

[@kylehawks2966]

Omg...Thank you 1 month I've been trying to figure that out and You did it thank you!!!!!!

[@ikhwankamaruzaman5111]

Hey, I just wanted to let you know that I have used your code in my studies and it does help me. Thank you so much.

[@QuickProgramming]

Awesome! am Happy to hear that!

[@anatoliedunai2937]

simple and understandable! Thank you!

[@QuickProgramming]

Thanks and you're most welcome😊

[@ethanali33]

This is by far the best help I’ve ever gotten from a video on web dev!! Thank you so much you are a life saver! Definitely getting a sub from me

[@ontheskyblue]

Great job, thanks a lot. It made the interference of html, php and MySQL more clear to me.

[@faridisayev1570]

Best tutorial I've ever seen! Infinite times better than Daniel's!!! Waiting for more videos!!!

[@QuickProgramming]

thanks so much. i appreciate the feedback!

[@dennifecaballero7626]

This one really helps me in my final project, thank you sir!!!

[@QuickProgramming]

Glad to hear that!

[@Hellnation13]

thank you so much for this, it was exactly what I was looking for. I struggled with ending the correct lines and sometimes placing spaces where they did or did not belong but I was able to compare your code to mine to fix these errors. I really appreciate it !

[@QuickProgramming]

You're most welcome and am glad I could help🙂

[@ekoneko6958]

Best teacher of coding for sure. Easy to understand and follow. Thank you!!

[@QuickProgramming]

awesome! thanks for the feedback :)

[@mohamedghazali4914]

You deserve Billion Subscribes, Thank You, you did it well, i appreciate that.

[@QuickProgramming]

you're most welcome and thanks a million for the compliment :D

[@jaafaromar8570]

If you just follow what he did, and never missed any spelling and statement, you'll probably get and have the same result as what is intended in this video. Thank you, bro!

[@darkclouds98]

I followed but when i sign up a new user and password, my database didnt show any result .

[@nikeshpatel1503]

@@darkclouds98 same here

[@nikeshpatel1503]

@@darkclouds98 Even I use his sample codes, still not inserting it into the Database..

[@oniviper]

For those of you having trouble, check your data table as seen here 3:14. Look at date and make sure that under the default column that it says current_timestamp(). If it doesn't, make the necessary change.

[@The2a2b]

​@@oniviper thanks it worked for me

[@aishwarya.m9481]

Thank you so much from last 1 week i am searching for this and not found exact solution today finally i completed my work ❤️

[@JoshuaMwepu]

i really love this video finally i have created my project am happy

[@lonewolf24765]

thank you so much! Very helpful.

[@QuickProgramming]

Glad it was helpful! you're most welcome

[@ingrooo]

I LOVE YOU!!!

[@jane7128]

Thank you thank you thank you, I'm happy I found this channel of yours. It helps me for my school project. I hope you will continue to do this kind of content. God bless you❤️ @Quick Programming

[@girlmath-abolisher]

you're a lifesaver !! this was so useful and informative and thoughtfully explained ! thank you~

[@QuickProgramming]

glad to hear it, thanks for the feedback

[@vuyisazotwa9464]

Hey bro I noticed something missing in the login code from the functions code, $user_data is comparing password which is not in the $results, but thank you very much bro cause its an easy fix please make more content

[@QuickProgramming]

thank you, i will :) but i dont understand on that error you mentioned. there is no password check in the functions code. its simply checking if the id in the session exists in the database as a user. password is not required since the user is already logged in at that point

[@Mr123456a89]

How can I fix that?

[@fujikohaze2976]

him: as simple as that me: *it looks easy but I dont understand as shit*...so ill just type it for my school activity anyways this save my ass, luckily I found this hidden gem

[@QuickProgramming]

hahaha i can relate. well, good luck with your school project :) am glad this helped

[@AH-cf9cv]

There are so many videos on login but u r one of the best.every one can easily understand your code.Thanks

[@QuickProgramming]

Thanks, I really appreciate your feedback❤️

[@Tyralamune]

Thank you for the tutorial. I'm a student that who wants to learn php & mysql. I watched a lot of videos till I find this brilliant tutorial. Thanks very much!

[@QuickProgramming]

Am glad to have been of help, you're most welcome🙂 and thanks for the feedback

[@ameenshah1164]

DATA IS NOT GETTING INSERTED INTO THE DATABASE ////////((((((((((SOLVED)))))))))))))))) while creating the database at 3:00 the default value of date should be selected as 'current time stamp'. somehow that part is not included in the video. PLs add the same.

[@ConsiderYourselfAgain]

Thanks man, it helped

[@trungdu9354]

Thanks I was looking at the code and was like i not seeing anything wrong >.< Thanks

[@Heidardevelopment-eq7wj]

actually i have a assignment that should i done that. this is an amazing tutorial thnks

[@imlexi1295]

Thank you so much for putting the source code in the description (and for free too!!) cus I made a singular typo (I missed ONE underscore) and it messed up the entire website. But since you linked the source code I was able to compare my code and yours and see where I screwed up which was so much easier than scanning through the whole video again. Thank you so much!!

[@QuickProgramming]

you're most welcome and thanks for the feedback. if you can, watch this other video as well to add some basic security to your website. thanks again kzbin.info/www/bejne/pnqyYaOjgrl9bLs

[@SuperMario9078]

No one: Google: 14:33

[@sh44ko58]

$feedback = 'Amazing'; echo "$feedback"; :D

[@QuickProgramming]

😂😂thanks

[@acchikeii382]

thank you so much. you remind me of my senior that always help me in programming.

[@QuickProgramming]

Thanks, am humbled by that reference😁😁

[@tioss6687]

Thank you sir ! I don't know how could I thanks please keep it up your are worth me than gold. Thank you very much god bless you budusarani!

[@LM-rn6ph]

The best coding tutorial video I've ever watched honestly, thank you so much.

[@QuickProgramming]

Thank you for this wonderful review, and You're very welcome!

[@lvonhentacles9621]

Thank you for the source code and the video. You have no idea how important you just became to my life

[@QuickProgramming]

Am very glad to hear it, you're most welcome😊😊

[@bankman5235]

This clip will keep me here every time ❤

[@patrickmalumephiri1456]

This is one of a few You Tube Tutors who are very clear in explaining

[@QuickProgramming]

Thanks♥️ zikomo kwambili

[@patrickmalumephiri1456]

@@QuickProgramming kkk ndiathu omwe kodi? Zilibwino kwambiri, and I meant what I said. You have a way of simplifying difficult stuff and make them sound so easy

[@patrickmalumephiri1456]

@@QuickProgramming Hey do you have a video on how to fetch data from the database to display in an Html page?

[@nabonghoisaac2539]

This is wonderful, you have been straight forward to the point.

[@QuickProgramming]

Thanks for the feedback and you're very welcome :)

[@33shei]

A great tutorial, it really helped me understand how to make a login function. Thank you so much.

[@QuickProgramming]

you're most welcome

[@dennisawuah7585]

😂After 1000 years of search Very lucky to find this! This shall come into clutch for my project😁thank you very much

[@QuickProgramming]

glad to hear it and thanks for the compliment, and ofcourse good luck on that project :)

[@pysco11]

This is wonderfully done Sir! I can't thank you enough. Would love now to see how to take it from your localhost to your remote server. But thank you so much!

[@QuickProgramming]

great, thanks. i'll make a tutorial on that soon

[@antonymusyoka1063]

Thank you. I salute you . Experts are never afraid to share.

[@ampmedia3239]

finally a video with code that works. thank you so much!

[@QuickProgramming]

you're most welcome :)

[@mrkabu-caisha3358]

this is the greatest and simplest programming guide tutorial ever , glad, U did well. and it correctly worked thank you so so much

[@QuickProgramming]

am really happy to hear that and thanks a lot for the compliment :)

[@kikix5565]

thank you so much i was looking this video so long and finally i found someone who made my day thx

[@QuickProgramming]

awesome 😊 you're most welcome and thanks for the feedback!

[@celestusnyalugwe7943]

What an amazing Tutorial!! You make everything seem so simple, it actually is, but not that simple 😂😂😅 THANK YOU SO MUCH!!

[@QuickProgramming]

you're most welcome and thanks for your feedback :))

[@briann.4731]

thanks this helped me alot in my project

[@olivierp761]

Dude thank you sooooo much. YOU ARE A LEGEND. TYSM

[@QuickProgramming]

Thanks for the compliment. Glad I could help! :)

[@songlyrics3696]

Thank you so much ! I have never seen video like yours!!!

[@QuickProgramming]

You're welcome! am glad it helped

[@waterblox-robloxrevival]

Bro, THIS MADE MY DAY BETTER!

[@jaydgrath]

You the real OG.!! Thanks a lot for such a precise and informative tutorial.

[@QuickProgramming]

Thanks and you're most welcome❤️

[@fovu959]

THANK YOU SO MUCH ALL THE TUTORIAL I CHEKED BEFORE (LIKE 15) DIDN'T WORKED AND UR'S DID I LOVE YA' CHEERS!

[@QuickProgramming]

That's awesome, am glad to have helped. You're most welcome😊☺️

[@QuickProgramming]

That's awesome, am glad to have helped. You're most welcome😊☺️

[@gohxuanyou5381]

Thank you ! such a life saver!

[@krolee7973]

Thank you so much. This is the best tutorial that i ever learn before

[@QuickProgramming]

You're most welcome. Am glad it helped

[@t4ris]

This has helped me so much and got me into using php in all of my projects. Thank you so much!!

[@QuickProgramming]

You're so welcome! am glad to hear it. Good luck with all your projects. If you have more time you can also watch this one to upgrade your skills kzbin.info/www/bejne/o3yadJyAmr6Cras

[@jonnynasz]

You are genius mate, I enjoyed this tutorial, it gave confident

[@suryasantoshreddy6835]

Thank you so much it worked!!

[@ronaldjohn54]

Im going to develop a website but my knowledge in PHP is not enough.. Im so thankful for this video. I hope you will upload more and more soon to help us😊😊

[@QuickProgramming]

More to come! you can check out the playlists i have to improve your knowledge some more

[@paulhughes8907]

Nice Video. Concise, one video, straightforward. Perfect, well done.

[@user-kw6rb5zz2n]

Thank you very much for the clear and detailed explanation!!! You saved my time and nerves🙌

[@QuickProgramming]

Great to hear! you're most welcome :)

[@focuslinkstech]

in fact this the best tutorial i have ever seen with clear explanation more power to your elbow sir i really appreciate

[@QuickProgramming]

you're most welcome! i appreciate your feedback too :)

[@hongevon7321]

good sharing and easy to understand .

[@junjie5042]

Thank you so much! This video helped me a lot on my modules. Keep it up and God Bless.

[@QuickProgramming]

you're most welcome

[@fmsron162]

Thank you soo much for this video I was soo useful for us

[@7X2TT]

what a great video and easy to follow, thanks and keep up the great work

[@vedantkadu7e986]

Bro Thank You So Much !!!! from last 15 days I'm finding a perfect video like thins and finally I got it , After watching half video only I Subscribed and liked I'm New in coding I didn't knew anything about php . You helped me alotttttttttttttttt Thank you so muchhhhhhhhh!!!!!!!!

[@QuickProgramming]

Glad it helped after a long search :)) you're most welcome

[@UNKNOWN-xe5mu]

you are the man, thanx man, you saved me, i understand php alot better now

[@QuickProgramming]

very glad to hear it :)

[@myhelshik5844]

Thank you for your effort! The tutorial is really amazing and easy to follow.

[@QuickProgramming]

Thanks, am glad it helped🙂

[@nearall]

i watch 20 videosfinally i make login logout system thank you for this video

[@QuickProgramming]

awesome! you're most welcome and thanks for leaving some feedback :)

[@nearall]

@@QuickProgramming sir please make a video on email verification for website

[@QuickProgramming]

@@nearall i will, very soon

[@johnblazevirtudazo6112]

Im having a hard time understanding php. This is brilliant thankyou so much!

[@QuickProgramming]

thanks and am glad to hear it. if you'd like, you can check my beginner tutorial on the links below and also how to make your own music website. you may learn some more stuff from there :) beginner php: kzbin.info/www/bejne/ZnSpgqCZp7Vlmqc music website: kzbin.info/www/bejne/rpC6aqmXq82Xb68

[@Gabriel-dk8go]

Bro thank you so much, even my teacher couldn't help me with my project. Thanks a lot

[@QuickProgramming]

You are most welcome

[@o.g_.__]

Thanks, worked properly.. Earlier I was getting errors , page not found, or some other error after submitting

[@areallyboredindividual8766]

You have rescued my grades for this semester. Thank you!

[@QuickProgramming]

Nice😁 you're most welcome

[@areallyboredindividual8766]

@@QuickProgramming One thing I'm wondering though, is the step to generate user IDs necessary if you handle primary keys in the database via auto_increment?

[@QuickProgramming]

@@areallyboredindividual8766 if i see id=50 in your profile url, i can then change it to id=51 and get the profile of whoever signup after you. then i can test for 1d=500 just to see how many profiles are on the site. even better, i can make an automated bot to go through all the profiles on the website and collect data. thats why its a bad idea to use the primary key in the url

[@areallyboredindividual8766]

@@QuickProgramming I have a situation where I've followed everything to the letter for registration and made sure it matched up with my database, yet nothing is being sent to the database when I register.

[@QuickProgramming]

@@areallyboredindividual8766 echo your query and then copy it from the page and paste it in the SQL tab in phpmyadmin. Click on your database first. If there's something wrong with the query, it will give you a specific error

[@sraanv5875]

that was really really helpful , thank you❤️

[@FrostDeDay]

Thanks man, i really appreciate this i couldn't fine any other video that went through the steps like you did, thanks 🙏 👍 🙌

[@QuickProgramming]

You're very welcome! thanks for the feedback :)

[@TzarinaPaula]

It worked for me. Thank you so much!

[@QuickProgramming]

you're most welcome Tzarina. thanks for taking the time to leave some feedback :)

[@reemaagrawal9234]

Thank you so much for this video!!! A big thanks to you!

[@QuickProgramming]

You're very welcome! am glad it was helpful

[@richardrodgers7406]

I just wanted to show my appreciation and say thank you for the content.

[@QuickProgramming]

Thanks Richard, that means alot😊

[@alvertcruz]

Thank you, I'm grateful that I saw your video

[@QuickProgramming]

awesome, you're most welcome :)

[@muddy11112]

Great Tutorial thank you!

[@krunalpatel5681]

best video for login-signup connection ever ...thank you

[@QuickProgramming]

You're welcome!