Complete User Registration system using PHP and MySQL database

In this video, we build a system in which users can register their accounts on our system by providing their username, email, and password and have it stored in a MySQL database. Later on, after signing up, users can log into the application providing their username and password.

- Unique Email Validation
- Email verification via email on localhost
- Use of prepared SQL statement to make the system more secure
- Enhanced password encryption
- Password reset (coming soon...)

This video is a re-upload. YouTube took down my video because of mistaken copyright claims. I reached out to the claimant and she admitted YouTube had inadvertently taken down my video alongside other videos she had reported for copyright infringement. She, however, refused to appeal to YouTube to reinstate my video for fear that YouTube might simultaneously reinstate the other videos that violated her copyrights. Nevertheless, she assured me that she wouldn't protest if I re-uploaded the video since it did not violate her copyright.
For some reason, when I reached out to YouTube with a counter-notification, YouTube refused to assist me in reinstating my video even after it had been vindicated.
I am therefore going to re-uploading since the copyright claimant has vindicated the video and given me green lights to upload the video.

[kirankunwar]

Prolly visited 100s of channels before I found you. You're the best tutor of all. Thanks man!!!

[lhadycamillesaligo]

Out of all the tutorial video that I watch, your video is a much more helpful it's informative and easy to follow. I really learned a lot and continue what you are doing, God bless you :) Thank you!!

[justforFUN-wcoc]

great video everything works fine except that i cannot make the .content class look like form in the css file. no matter what i write a changes won't affect the content class in index.php.
can someone help me?

Update: nevermind its just Firefox Developer edition being trash..works fine in Microsoft Edge

[lilyjordan]

Thank you so much for this video, it is a lifesaver.
I have created the registration form but for my website I have added a drop-down list which allows users to select their diet and from this when the user logs in after verification it shows them the corresponding meal plan page for the diet they clicked (if that makes any sense) but I am unsure how to do so. Can you please help.

[bazimtsweni]

Get yourself a microphone my friend so you can explain more, but nonetheless this is very good work you did here 👏🏾👏🏾👏🏾..

[kshitijpawar]

I've downloaded the source code, but the problem is it just registers one user i.e., the next registration is not updated in the database, therefore the 2nd user cannot log in.

[Samurai-]

@Awa Melvine i have this problem idk why i ve been writing exact same code but when i click on register button its like this

Fatal error: Uncaught ArgumentCountError: mysqli_real_escape_string() expects exactly 2 arguments, 1 given in Stack trace: #0 mysqli_real_escape_string('') #1 #2 {main} thrown in on line 12

[jesuissyazryl]

How to tackle undefined index of the email, password_1, password_2? I cannot log in once registered. It keeps on appearing the required message.

[stockhutzo]

Even worse than the previous one, you're using a deprecated MySQL API and *MD5 FOR HASHING* shame on you, you're teaching bad coding practices, actively spreading ignorance.

[turkishdramas]

Can you please provide me with the source code? My index.php is not working no matter how many times i have cross checked.

[jhintlemann]

27:38 I have the error there Fatal error: Uncaught Error: Call to undefined function mysqli_ram_rows(). Can somebody help me pls?

[aditii]

YOU ARE A This video was immensely helpful, can't thank you enough.

[nerd]

om gosh u haven't activated windows yet, i can gift u one, cause u help me a lot

[nikkieforov]

Thank you! It's very helpful. You save my life T^T

[sin_wraith]

can anyone tell me why the mysql real escape string is counted as error unlike the one on the video especially: 11:50

[segigamehd]

My error messages arent showing can you help me

[robertberniemanlangit]

Not Found
The requested URL was not found on this server.
Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/8.1.2 Server at localhost Port 80

can anyone help pleasee?

[aronforever]

please learn to code better before you start making tutorials for others, mysql_real_escape_string is deprecated, use parameterized queries. MD5 is also deprecated, use salted SHA256. Upgrade to PHP 7, it's much faster.




"Although MD5 was initially designed to be used as a cryptographic hash function, it has been found to suffer from extensive vulnerabilities. It can still be used as a checksum to verify data integrity, but only against unintentional corruption. It remains suitable for other non-cryptographic purposes, for example for determining the partition for a particular key in a partitioned database.[3]"

[matejfons]

Parse error: syntax error, unexpected 'endforeach' (T_ENDFOREACH), expecting end of file in on line 6 idk what should i do with this, i have the same code as you

[aniey]

can anyone help me? i have problem at 16:22 in video .. i have check but i couldn't find any missing code..i have resfresh many time and enter register button but that red warning text doesn't appear.. please help me :(