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/ironman-zaman/logi...
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

[@soohong_26]

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

[@auztuts]

Thank you!

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

[@user-we6ci7sl5m]

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

[@auztuts]

Thank you!

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

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

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

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

[@Jayy_dabest]

slowly and easy to understand! love your work sir.

[@auztuts]

Glad to hear. Thanks

[@kinematics3375]

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

[@auztuts]

Thank you!

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

[@bmf_onlineedu1649]

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

[@auztuts]

Thank you! Keep in touch.

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

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

[@jake_2001]

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

[@auztuts]

You are most welcome 🙂

[@durgaprasadmajji9458]

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

[@auztuts]

You are welcome

[@osiris1071]

this tutorial deserves a solid like

[@auztuts]

Thank you!

[@sprinter5901]

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

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

[@yassminahailala145]

thank you so much you save my final project exam

[@auztuts]

You are welcome!

[@mojito9695]

Best ever video sir❤️ good explaination thanks

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

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

[@pawantembhurne6828]

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

[@auztuts]

Thank you! Keep in touch 🙂

[@dipeshgohil323]

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

[@auztuts]

Welcome Dipesh. Keep in touch.

[@prosper5003]

Thank you for this tuturial, exactly what I wanted.

[@auztuts]

Great to hear! You are welcome!

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

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

[@kugita6638]

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

[@auztuts]

You are welcome :)

[@aminebahlaouane3604]

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

[@auztuts]

You are welcome

[@jsmithtraveller]

Thank you Aus, brilliant tutorial

[@auztuts]

Very welcome

[@nazmulhuda121]

really....outstanding

[@auztuts]

Thank you!

[@user-th1sf1hn4f]

its working sir tq

[@mugilvanand3016]

Wonderful session 🔥 Thanks lot

[@auztuts]

You are welcome

[@azuboof]

Onek sundor detailed video

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

[@manojkumar.n6685]

Thanks a lot, very helpful and good.

[@auztuts]

Thank you!

[@BooBoo-sl7lw]

This is the best code...thanks sir 😊

[@auztuts]

Enjoy. You are welcome!

[@Web2DesignTutorials]

Great tutorial bro. Keep it up :)

[@auztuts]

Thank you! Stay in touch.

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

[@jackionendino4293]

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

[@auztuts]

Thank you! Keep in touch

[@SigmaMindset-hw3ql]

nice tutorial

[@auztuts]

Thank you!

[@luismercado9910]

its working, now thank you.

[@auztuts]

Great!

[@user-sd7yu3xi9j]

Awesome explanation bro

[@auztuts]

Thank you!

[@nofear4797]

You are amazing sir!!

[@auztuts]

Thank you"

[@NORMAISARAHBINTIMOHDISMAILUPM]

you save my life, thankyou

[@auztuts]

You are welcome!

[@zane5121]

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

[@auztuts]

You are welcome!

[@lien3245]

you are amazing bro! thankyou alot!

[@auztuts]

You are welcome. Keep in touch.

[@VortexPV]

Thank you very much sir this will help a lot ❤

[@auztuts]

You are welcome.

[@abuchadifares359]

good detailed explanation Tnx broo🎖🏆

[@auztuts]

Thank you! Keep in touch.

[@hajarwissar8498]

very helpful ❤

[@auztuts]

Thank you!

[@preethavishvalingam5037]

thank you so much its work well

[@auztuts]

You are 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?

[@harshmehta4956]

superb man thanks

[@auztuts]

You are welcome

[@sofiahumble3216]

thx very cool tutorial

[@auztuts]

You are welcome

[@geraldera3825]

Thank you sir

[@auztuts]

Welcome

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

tq soo much sir this video use for me ..

[@auztuts]

You are welcome

[@abdessamad494]

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

[@auztuts]

You are welcome

[@nuwansurangakodikara1016]

excellent explanations thankyou !

[@auztuts]

Glad it was helpful!

[@iqraishtiaq8412]

Amazing 😍 Thank you So Much

[@auztuts]

You are welcome

[@DreamMaster16]

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

[@auztuts]

Thanks lot!

[@DreamMaster16]

🥰welcome🥰@@auztuts

[@cosminboglis5160]

Thanks! It helped me

[@auztuts]

You are welcome!

[@alighrabi3571]

thnk u very useful

[@auztuts]

Welcome 😊

[@nimnamedia7944]

Thank You so mutch sir...!

[@nimnamedia7944]

Liked. Commented. Subscribed.

[@auztuts]

You are welcome

[@auztuts]

Thank you!

[@sammetamaheshbabu]

thanks bro, i learn a lot ❤❤

[@auztuts]

You are welcome

[@usermira438]

thank u soo muuuuuuch sir

[@auztuts]

You are welcome

[@jayce5720]

​@@auztutssir my codes error password doesnt match

[@deepakbattula7953]

Thank you bro✍👍👍👍

[@auztuts]

You are welcome

[@MULTIVERSOF]

love u mate

[@auztuts]

Thank you!

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

[@nhathuy7225]

Thank you very much !!!!

[@auztuts]

You are welcome

[@jeffotiende4792]

👏👏👏👏👏

[@rhapsodyentrina5021]

thank you so much

[@auztuts]

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!

[@JunieVM]

Thanks a lot.

[@auztuts]

You are welcome

[@LAKSHMI39]

Thank you sir,

[@auztuts]

Welcome!

[@rodmaniswild]

Thank you!

[@auztuts]

You're welcome!

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

[@fredzkieviola]

Very helpful thank you

[@auztuts]

You're welcome!

[@snqmlbrn]

thank you so much!!!

[@auztuts]

You are welcome

[@Coder-kl6pd]

Thank you❤❤❤

[@auztuts]

Welcome

[@5KFubi]

Thank you so much

[@auztuts]

You are welcome!

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

[@jsmithtraveller]

Thankyou

[@klirmio21]

Thank you for this very good and thorough tutorial!

[@auztuts]

You are welcome

[@user-gh3rs9co2f]

thank you brother

[@auztuts]

Welcome

[@onlinejobskenya]

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

[@auztuts]

Thank you! Its my pleasure

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

[@BinsNicki]

Thx Bro

[@auztuts]

No problem

[@sahilranjan3066]

Thank you

[@auztuts]

You're welcome

[@iLuvHardStyle]

I have a question.. if you create user profile page and want to be able to change your data there like bday, city etc. do you just add that data in same table in sql or you need separate table for reg and profile edit?

[@RaushanYadav-rh4xb]

Golden 56 minutes ❤😊

[@auztuts]

Thank you!

[@That_gmaing]

❤❤❤❤

[@venkateshshanigarapu6673]

Awesome, do some django projects also😊

[@auztuts]

Thank you! Sure, I will.

[@alriskynamikaze]

can i upload this type of login and registration to something like replit? and how do you make a home page after logging in? sorry for bad english im newbie at web developing

[@hamzanakan629]

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

[@auztuts]

Sure, In future hopefully

[@AwesomeCaden73]

Do you mind if we use a modified version of the tutorial code in our own projects? I opted to follow along during the tutorial and made a lot of changes as I went. I’m hoping to use what I’ve made as a quick-and-dirty authentication service for a school project.

[@auztuts]

Sure, No problem. You can use it

[@audryremedio9914]

thank u

[@auztuts]

You're welcome!

[@sithumbandara7199]

🥰🥰🥰