Login and Registration Form in PHP and MySQL

#php #mysql #database #xampp
In this tutorial I have shown how to make a complete login registration system using PHP and MySQL. I have explained step by step by following very simple procedure. Also I used all the validation and verification for the forms.
From this tutorial you will be able to learn.
1. How to connect the form with database using XAMPP server.
2. Create the registration and login forms using Bootstrap framework.
3. Create the whole user registration system using PHP and MySQL.
4. How to validate and verify the form data.
5. How to design form using Bootstrap Framework
Here is the GitHub link of the project files :
github.com/iro...
Perhaps this will catch your attention:
Step-by-Step Tutorial on Constructing a Simple CMS with PHP and MySQL
• 🚀 How to Build a Basic...
If you want to know how to upload images to database please watch this tutorial:
• How to Upload Images i...
Enjoyed this video? Don't forget to hit that 'Subscribe' button and turn on the notification bell 🔔 so you never miss an update from us. Your support means the world to us, and it helps us create more content you love. Thank you for being a part of our community!
Website
auztuts.com/
You can join this Facebook group to discuss problems and ask your questions.
/ 930382041470136
You can also follow me on Facebook , Twitter and LinkedIn
Facebook:
/ auz.tutorials
Twitter:
/ aktar_uz_zaman_
LinkedIn:
/ md-aktaruzzaman-a16205134

[@auztuts]

Please use type password for the "Repeat Password" field. Somehow I forgot to mention it 🙂

[@auztuts]

@@user-zz7rw9qv9v Sure, my contact info is in the description.

[@user-zz7rw9qv9v]

‏Why does the password in the database not appear the same as the one I entered when entering the timer, it appears encrypted

[@auztuts]

Yes , you can communicate with me. The contact information is in the description.

[@furqanqadeer17]

Where?

[@sprinter5901]

​@@user-zz7rw9qv9vHe told the reason for it in the video itself.
If some hacker gets access to database then he can access all the readable password and email, which he can use for ill practices.
So to avoid that encrypted password is stored so even if hacker gets the encrypted password he won't be able to login with that.
Remember
For 12345 - hash1 is generated
If hacker uses hash1 in the form as password a different hash2 will be generated

[@tharakasandaruwanmanohara6950]

This is the best tutorial on youtube if someone wants to understand the Login and Registration Form in PHP and MySQL

[@auztuts]

Thank you!

[@user-pc9oi8ck7z]

I have been doing follow this video it is not working

[@OppieT30]

This could have been done in Object Oriented Programming (OOP).

[@Vasilis-grk]

I’ve watched so many tutorials, but this one is by far the best. Thank you for sharing your knowledge.

[@auztuts]

You are welcome! It means a lot.

[@safwa5577]

a true guider deserve more veiws and subscriber May Allah give you more success in every field of life

[@auztuts]

Thank you for the wish!

[@soohong_26]

This tutorial legit is a life saver would recommend and keep up the work man 👍

[@auztuts]

Thank you!

[@joshuachristopher9288]

This video is pure gold. Explained everything clearly from start to finish. THANK YOU!!!

[@auztuts]

You are welcome! I am happy that it helped you.

[@durgaprasadmajji9458]

Thank you so much sir i completed my project because of you

[@auztuts]

You are welcome

[@user-ng7ts4hg5u]

you can not imagine how grateful i am that you made this tutorial, you helped me so much on how to properly write php, thank you so much for this! you deserve so way more followers than you already have ♥

[@auztuts]

Thank you! It means a lot to me.

[@AmyEnthub]

i followed you because of this video, this is the best understandable video in internet
you have save me from long time error
thank u

[@auztuts]

Thank you! I am glad that , my tutorial helped you.

[@AmyEnthub]

@@auztuts please can wamp and xamp work with the same data update, cos i hv tried so many times to implement the same code using wamp server buh not working
Please how can I solve it, am in stock😩!!

[@auztuts]

Hi@@AmyEnthub, what issue you are facing? It should work on WAMP server too. Can you give me the specific error please? Does the localhost url works fine? Did you start the server before testing?

[@AmyEnthub]

@@auztuts the server is on, I checked it several times,
To connect to the database, when I was done with the connection, I did print the post method so it can give me the array but it isn't working, including the connection 🤦🤦

[@yassminahailala145]

thank you so much you save my final project exam

[@auztuts]

You are welcome!

[@GKPedia1]

I'm so happy you are here for us to guide php Jazak Allah Kher Allah bless you

[@auztuts]

Thank you Man! May Allah bless you as well.

[@dipeshgohil323]

Thanks, this was extremely helpful to get started in my project

[@auztuts]

Welcome Dipesh. Keep in touch.

[@jairudenbeda1834]

One of the best tutorial for registration form. Thankyou so much sir for this tutorial.

[@auztuts]

You are welcome!

[@korgibari8013]

Thank you very much for your turorial!!!! Actually I have never commented under someone’s video, but you literally rescued me. I had been struggling how to make authorization in my project and there wasn’t any working and easy tutorials, but your tutorial is the best it helped me so much 😌

[@auztuts]

Hi, thank you for your comment. I am happy that my tutorial helped you 🙂

[@zane5121]

Thank you for this source code, it helps to my Project this College days.

[@auztuts]

You are welcome!

[@DreamMaster16]

THIS IS VERY INFORMATIVE VIDEO THANK YOU SO MUCH SIR FOR UPLOADING THIS

[@auztuts]

Thanks lot!

[@DreamMaster16]

🥰welcome🥰@@auztuts

[@aniketraj9420]

I got this video when I needed it the most... Thank you so much for such explanation. 🙂 It was too good. Keep growing.

[@auztuts]

You are welcome 🙂

[@prosper5003]

Thank you for this tuturial, exactly what I wanted.

[@auztuts]

Great to hear! You are welcome!

[@sprinter5901]

Explained all the details and examples step by step.
Thank you

[@auztuts]

You are welcome :)

[@osiris1071]

this tutorial deserves a solid like

[@auztuts]

Thank you!

[@aminebahlaouane3604]

your explanation is so good that this seems so easy. thank you

[@auztuts]

You are welcome

[@jsmithtraveller]

Thank You for your tutorial I had been stuck on error validation but your tutorial made it clear for me. Cheers

[@auztuts]

Great to hear!

[@abdessamad494]

thank you very much very sir, good tutorial easy to understand and explained very well

[@auztuts]

You are welcome

[@Jayy_dabest]

slowly and easy to understand! love your work sir.

[@auztuts]

Glad to hear. Thanks

[@rbesilbenart]

Amazing the work you have done , I have watched the video and used for my final year project. Thank you. Earned a subscription bro.

[@auztuts]

I am happy that , my tutorial helped you. Thank you for subscribing.

[@auztuts]

Github link of the code is added in the description. You will need to add the database to make it working correctly. Please watch the tutorial first to last to understand the procedure.

[@blackswordman8140]

How do i add them correctly please explain

[@VortexPV]

Thank you very much sir this will help a lot ❤

[@auztuts]

You are welcome.

[@chrismpa4382]

I appreciate you and this video so much. Please can someone keep in touch for mentorship/guidance when necessary ? Please 🙏

[@auztuts]

If you need any help you can comment it here

[@user-we6ci7sl5m]

Great tutorial and responsive person. Only success in the future, thank you🙂

[@auztuts]

Thank you!

[@SoldierMike11]

I liked the video, it is good to follow good practices. It would be great if you could create a tutorial for friendly routes, following good practices. Or also an ORM tutorial, greetings.

[@auztuts]

Sure, hopefully I will do it. Thank you!

[@cyranas9157]

Great Tutorial! For those who still encounter password does not match take note of the length/value of password, its better to set it to 255 like what is indicated on this tutorial.

[@auztuts]

Thank you!

[@nevbabas]

Awesome tutorial. Great teacher. Making mistakes so viewers can understand better. Will not learn enough if we don't see the mistakes.
By the way, how to do normal user and admin account? Thank you

[@auztuts]

Hi, this tutorial includes only admin part. Hopefully I will come up with another tutorial.

[@mansoorbijarani8822]

As many persons were facing an issue of password not matching so here is solution for them. In login.php don't use variable name $password use any other name like $pass then it will work properly

[@abaniljohnmichaelguda2232]

It works, thank you😎

[@muhammadsuleman5084]

Brooooo really thankful to you I was struggling about an half hour really bro thanks alot❤

[@abhskarki3909]

I changed the $password in login.php to $pass but I still get password doesn't match

[@muhammadsuleman5084]

@@abhskarki3909 bro i can't tell the exact reason without seeing actual code but my many fellows get same error even though after changing password to pass

[@aleksandarduncevic9548]

Can someone explain why is this happening, I had this problem and solved it by changing the name of the variable?

[@kugita6638]

thank you so much! very well explained in detail tutorial! keep up the good work!

[@auztuts]

You are welcome :)

[@Stevenbensonofficial]

At least your doing a great job other tutorials are full of errors

[@auztuts]

Thank you! Its my pleasure

[@user-th1sf1hn4f]

tq soo much sir this video use for me ..

[@auztuts]

You are welcome

[@itsmemikyi]

thank you for your wonderful video, my fellow friend dijon also said that this video is very good, thank you once again

[@auztuts]

You are welcome. I am happy that it was helpful for you.

[@BooBoo-sl7lw]

This is the best code...thanks sir 😊

[@auztuts]

Enjoy. You are welcome!

[@chinonsoamos7797]

Nice video
Please Sir I don't know how to include phpmailer in the script.
Please help to include phpmailer please sir 🙏🙏

[@auztuts]

HI, I will try to make a video for that. Thank you!

[@nimnamedia7944]

Thank You so mutch sir...!

[@nimnamedia7944]

Liked.
Commented.
Subscribed.

[@auztuts]

You are welcome

[@auztuts]

Thank you!

[@luismercado9910]

If you have a search engine tutorial for local search into mysql , pls let me thanks so much - you are great.

[@auztuts]

Great suggestion! I will try

[@abuchadifares359]

good detailed explanation Tnx broo🎖🏆

[@auztuts]

Thank you! Keep in touch.

[@mohapimohoto7354]

Man you really saved my life

[@auztuts]

I am glad that it helped.

[@mohapimohoto7354]

Can we please have an updated one which let's the user sign up or login using gmail/Microsoft

[@venkateshshanigarapu6673]

Awesome, do some django projects also😊

[@auztuts]

Thank you! Sure, I will.

[@preethavishvalingam5037]

thank you so much its work well

[@auztuts]

You are welcome

[@jake_2001]

Thank you very much! I watched the whole video and you explained it very well as well.

[@auztuts]

You are most welcome 🙂

[@kagisomogotsi3865]

This is very helpful and beginner friendly👍🏿, however I keep getting a "FATAL ERROR" on line 7 of the database file

[@auztuts]

Hi, can you send me the error massage you see?

[@pawantembhurne6828]

superb session bro...🙏🙏🙏🙏🙏🙏👍👍👍👍👍👍

[@auztuts]

Thank you! Keep in touch 🙂

[@kinematics3375]

Thanks bro, other videos were not working but yours are working!

[@auztuts]

Thank you!

[@manojkumar.n6685]

Thanks a lot, very helpful and good.

[@auztuts]

Thank you!

[@coredatallc5671]

This is an excellent tutorial. What I liked about it was the error trapping logic...pushing the errors into an array, and then accessing them is very efficient code logic. Do this in PDO and the db calls as stored procedures would be an excellent tutorial for the future. How may I contribute to your success with a donation?

[@auztuts]

Thank you very much for your such a kind reply. I will make a tutorial with PDO. I am not taking any donations for now. But please keep in touch and help me grow my channel.

[@lien3245]

you are amazing bro! thankyou alot!

[@auztuts]

You are welcome. Keep in touch.

[@fredzkieviola]

Very helpful thank you

[@auztuts]

You're welcome!

[@azuboof]

Onek sundor detailed video

[@auztuts]

Thank you!

[@mojito9695]

Best ever video sir❤️ good explaination thanks

[@auztuts]

Thank you!

[@geraldera3825]

Thank you sir

[@auztuts]

Welcome

[@nazmulhuda121]

really....outstanding

[@auztuts]

Thank you!

[@gurleenkaur4151]

Thank you for your video. It really helped me a lot.

[@auztuts]

You are welcome

[@gurleenkaur4151]

@@auztuts Do u also know how can i access dom element of a html file to another html file's input box ?
like i want my book's price shown in the purchase form when i am going to buy it..

[@user-sd7yu3xi9j]

Awesome explanation bro

[@auztuts]

Thank you!

[@luismercado9910]

its working, now thank you.

[@auztuts]

Great!

[@jsmithtraveller]

Thank you Aus, brilliant tutorial

[@auztuts]

Very welcome

[@klirmio21]

Thank you for this very good and thorough tutorial!

[@auztuts]

You are welcome

[@sofiahumble3216]

thx very cool tutorial

[@auztuts]

You are welcome

[@SigmaMindset-hw3ql]

nice tutorial

[@auztuts]

Thank you!

[@bmf_onlineedu1649]

this is fantastic!!!! something i had been searching for.

[@auztuts]

Thank you! Keep in touch.

[@atharvakumbhar21]

Thanks For That Tutorial 👍❤

[@auztuts]

You are welcome!

[@alighrabi3571]

thnk u very useful

[@auztuts]

Welcome 😊

[@usermira438]

thank u soo muuuuuuch sir

[@auztuts]

You are welcome

[@jayce5720]

​@@auztutssir my codes error password doesnt match

[@harshmehta4956]

superb man thanks

[@auztuts]

You are welcome

[@tresha1235]

thank you so much

[@auztuts]

You are welcome

[@felipeneduro4862]

nice video bro but what you use in 34:20, is also vulnerable to SQL injection, it not retrieves the result in plain text but if you use correctly IF, SUBSTR and SLEEP statements you can be able to leak information from the database so it's a point to take into account.

[@felipeneduro4862]

how can I fix it bro?

[@JunieVM]

Thanks a lot.

[@auztuts]

You are welcome

[@mugilvanand3016]

Wonderful session 🔥
Thanks lot

[@auztuts]

You are welcome

[@user-gh3rs9co2f]

thank you brother

[@auztuts]

Welcome

[@NORMAISARAHBINTIMOHDISMAILUPM]

you save my life, thankyou

[@auztuts]

You are welcome!

[@OppieT30]

You should make another one using PHP OOP programming. If you don't know how to do that you can learn. You can modify this to be OOP.

[@auztuts]

Ok, I will try.

[@rodmaniswild]

Thank you!

[@auztuts]

You're welcome!

[@deepakbattula7953]

Thank you bro✍👍👍👍

[@auztuts]

You are welcome

[@MULTIVERSOF]

love u mate

[@auztuts]

Thank you!

[@nhathuy7225]

Thank you very much !!!!

[@auztuts]

You are welcome

[@ipapaid]

Thanks, i have supported you by not skip

[@Islamic_Hadees95]

Thank you so much for helping me

[@auztuts]

You are welcome 🙂

[@RaushanYadav-rh4xb]

Golden 56 minutes ❤😊

[@auztuts]

Thank you!

[@OppieT30]

You could have put Then you wouldn't need the if (empty($fullname) part.

[@auztuts]

Anybody can remove that required attribute using inspect tool of the browser so that is very vulnerable.

[@user-th1sf1hn4f]

its working sir tq

[@snqmlbrn]

thank you so much!!!

[@auztuts]

You are welcome

[@jsmithtraveller]

Thankyou

[@demodata-e5o]

Nice Tutorial

[@auztuts]

Thank you!

[@chaitanyaraju1752]

Can't say anything more than thankyou...

[@auztuts]

You are welcome

[@hamzanakan629]

Thanks for this tutorial, could you add email verification also?

[@auztuts]

Sure, In future hopefully

[@sammetamaheshbabu]

thanks bro, i learn a lot ❤❤

[@auztuts]

You are welcome

[@jackionendino4293]

Youre amazing bro, thanks alot thats a very concise explaination. Keep up❤️

[@auztuts]

Thank you! Keep in touch

[@typicalvideos-t5i]

You are amazing sir!!

[@auztuts]

Thank you"

[@Web2DesignTutorials]

Great tutorial bro. Keep it up :)

[@auztuts]

Thank you! Stay in touch.

[@gamerzone6574]

Best youtube video

[@auztuts]

Glad that it helped you.

[@yasingunaydiin]

Great video man! Thank you.

[@auztuts]

You are welcome!

[@user-wd1bn9gn3y]

Thank uuuuuuu🫡🫡🫡🫡

[@auztuts]

You are welcome

[@dharshi.29]

thank you bro u saved me !!

[@auztuts]

You are welcome 🙂

[@hajarwissar8498]

very helpful ❤

[@auztuts]

Thank you!

[@mojito9695]

Sir can we get video on html form data base that when we fill it will show in html website table only!!

[@auztuts]

th-cam.com/video/Ydogcs6ImLw/w-d-xo.html
This is my other tutorial that explains how to insert data and then shows data in html table. It also explains how to edit and delete data.