User registration and email verification with PHP and MySQL database on localhost

[@AwaMelvine]

Part 2: Email Verification: kzbin.info/www/bejne/eV69hISDl9igbaM

[@StoryTimeWithOmaz]

Thank you for the videos. However, It would be better if you can include the source code.

[@maybuss1810]

Everything went well till i try to signup and i kept getting 'Database error: failed to register', it is becoming very frustrating for me. Can you please help sir!

[@diabetico2062]

please help my error Database

[@mosesegboh]

@@maybuss1810 am experiencing thesame problem...'Database error: failed to register'.....i 've checked everything and all seems to be fine....did you manage to solve the problem??

[@K1ndaAv3rage]

moses egboh I’m getting the same thing

[@LyleCrumbstorm]

2 Things: If you're stuck at 53:00 with Database error or submitting to a blank page: 1. Change bind_param from 'ssbss' to 'ssdss' (d instead of b) 2. Change PHP Options in your hosting: Uncheck "mysqli" and check "nd_mysqli" After 10 hours of research this is what solved my problem... at least this one. Now on to the next one!

[@vedranajerkic4387]

Same problem, but now it is working. Thank you :D

[@nabilotexd5836]

OMFG thank you so much bro. You're a legend, I have been trying to solve this problem for 5 hours and changing "b" to "d" solved it. 🙏

[@Jon27111807]

You are a fucking legend

[@thereborne3134]

didnt work sadly

[@splatm4n8]

I am using XAMPP and I don't know where to find the option to switch from mysqli to nd_msqli, can someone help?

[@TrailblazerTalks12]

This is my first time of commenting on a youtube video. This tutorial has really helped me alot. Thanks for the good work AWA.

[@AwaMelvine]

I'm glad it helped you, Adefilia.

[@ilotygames6326]

Congrats man, u finally lost your KZbin commenting virginity

[@photoinshot1355]

Expertly constructed tutorial, very well explained and easy to follow. I cannot overstate how good Awa is at constructing and delivering tutorials. I have followed all three tutorials in this series and all three are of the same high quality. Awa’s explains the what, why and how his code works in very simple and precise language without unnecessary verbiage like so may other so called tutorials do. This makes it easy and enjoyable to learn with Awa because he is a great communicator. Many thanks!

[@-PhilGibson]

I finally got there in the end :). it works perfectly & i love the finer functionality details i.e showing wrong credentials, password required, email already exists etc etc and being logged in on the same account on the same browser but in 2 tabs and then logging out in 1 tab and refreshing the 2nd it then throws you out. Excellent stuff. very much looking forward to getting started on the email verification and forgot password tomorrow. I hope they both work as beautifully as this has. Much appreciated for your efforts @Awa Melvine. Keep up the good work! Thanks

[@oziomadeoracle]

mine is not working properly. Always showing undefined array key. can you help me please?

[@MrRolsen83]

Wow, thank you so much for your time. Thank you for not over complicating this tutorial by trying to explain how every little thing works. Can't wait to learn more!

[@MrMoto]

Wonderful tutorial, I learned a lot. There are two important things you might want to address: first, the registration code doesn't check for duplicate usernames, only duplicate e-mails. Second, it would be very wise to limit the username to letters and numbers so that someone doesn't sign up as ..., for example. One minor point: in bind_param, 'b' is for 'blob', not 'boolean'; use 'i' (for 'integer) instead.

[@musicbyrish]

@Phil Did same issue bro... Any solution

[@musicbyrish]

@Phil Did thankx man for send m this mailing video.. but what about login issue I'm getting the error password_verify..

[@marky_studio]

@@musicbyrish you already solve this problem ? Here is my error message when I tried to log in Trying to access array offset on value of type null in --- As of now I didn't solve yet this problem. If you do. Let me know. And I will post my solution once I figure out ☺️

[@musicbyrish]

@@marky_studio yes i resolved the issue.. but I have to check your code .. so that i'll tell you further...

[@marky_studio]

@@musicbyrish thank you bro I already solved my issued. Hehe it's in my database I accedentally set my password 🔑 as INT instead of varchar

[@vilip-yh2hg]

please make the code available for download

[@chinmobile]

Great tutorial. I followed all 3 parts. I learned lot from your lessons. I had little knowledge on php before, but i learned bit more on php with help of yours. I need more lessons on php.. please ...Thanks a lot for your time and effort!!!

[@User-is2kf]

hey man do you have the source code?

[@toni5390]

i just watched your video and i must give you full credit. Thanks a whole lot Awa for the detailed lecture and efficiency in teaching this.

[@felixespinosa7853]

This tutorial is so detailed! This really helps me for our project in system architecture. I don't know PHP that much but Awa explained every block of codes and its purpose so I am able to catch up. I really appreciate every explanations, thank you!

[@AwaMelvine]

Thank you so much for taking the time to write these kind words!

[@VipapkStudiosOfficial]

You're the best! An video with your voice is awesome! The background noise isn't annoying at all! I love the birds in the background! ^^

[@ilxZfps]

Brilliantly constructed and so very helpful! Thank you for producing such great content! I had no issue understanding what you were creating as you explained it very well, even though I have little experience and ability when it comes down to coding.

[@martiinamankwah6240]

Thank you so much Awa, I've completed the video tutorial and it went perfectly well. God bless you abundantly

[@kevinmahlangu4219]

You're an incredible developer and teacher. Thank you so much. 🙏

[@SANKHA2023]

Thank you sooooooooooo much. I can't express in words how much you helped me. This login page is awesome

[@nibeditajena1042]

Thank you so much for your knowledge sharing.This helps me a lot in my projects doing in company.

[@andrewnadeau824]

Awa - this is great. Thanks for the detailed walk-through. Are you planning on a follow-up video with email verification and password reset?

[@AwaMelvine]

I am currently working on it. I was caught up in a few commitments if not I would have published the email verification part by now. But it won't be much longer. I will publish it in the next two days at most. Thanks for watching!

[@Foodstershub]

@@AwaMelvine can you please send the completed code to [e-mail] ?

[@faceshare5458]

@@Foodstershub my friend has the code because he followed all parts and he posted it on github

[@faceshare5458]

@@Foodstershub write my friend on instagram, answer his questions and you will get the link from him because i dont know the link

[@faceshare5458]

@@Foodstershub this is his insta: instagram.com/bb_joker__/

[@ugifredrick8342]

Awa - Honestly I must say am proud of the way you in detail explain your codes, also your method of short cuts👍...I love ur work bro👍😘

[@garlandpoolfredpool]

Thank you Awa! I learn very well from you! Keep them coming! Liked and subscribed...

[@arshaqdusmohamud8051]

You have helped me a lot for my assignment!!! THANKS A LOT AWA!!!!!! YOU'RE THE G

[@youssradebbali7726]

Hi arshaq .. please can you send me code source because i have a probleme in login page🙏🙏🌹🙋‍♀️

[@arshaqdusmohamud8051]

@@youssradebbali7726 heyy, actually i do not the codes anymore, i cleaned my pc 😭very sorry for that, i hope you can get the help you need 🙏🏼🙏🏼

[@youssradebbali7726]

@@arshaqdusmohamud8051 thank uu.. the probleme was solved🤗❤ If you need source code I can give it to you

[@artin0905]

@@youssradebbali7726 can you please give me source code?

[@youssradebbali7726]

@@artin0905 hi artin 🙋‍♀️ok no problem can u send me your email

[@nikshailapp]

there are no password forget option

[@ramseyisanerd8993]

Check out part 3 of the series

[@JustinTheVlogger]

Thank you! You helped me a lot, now I know the algorithm and how to make login, register form! God bless and please continue your work!

[@AwaMelvine]

Thank you too my friend. I'm glad you found them helpful

[@JustinTheVlogger]

@@AwaMelvine Yes, and I am your subscriber now. :)

[@RahulYadav-fx7ky]

great tutorial i have ever seen for php!!!!!! please keep it up...

[@yuurinikiforov4970]

Sir thank you so much for your help you are great and helped me a lot with my school projects!

[@RamkumarPariharflutist]

It helped me a lot. Huge love from India ❤️

[@loeb9102]

Thanks best video to check & correct errors..very helpful👍

[@ITtrainingchannel]

Success just finished it and works perfect

[@Ctenid]

Thank you very much Awa!

[@oscarmartinlive]

You have no idea how you've helped me with this video. I really look forward to showing appreciation materially. I sent you a message on Twitter. But of course, :)

[@senkottuvelan]

You are awesome. Hats off to you. ☺️

[@f.l.y2677]

Error on= fatal error: Call to undefined function random_bytes() line 50 Pls help

[@raymundvellila8464]

Thank you for this wonderful tut. keep it up!

[@emon_hoque]

Thankyou so much! This was really helpful to me. I appreciate it!

[@bihiraaggrey7028]

Surely we have to credit Awa for the great awesome skills, #Much likes for me and Him please!

[@AwaMelvine]

Thanks a lot, Bihira Aggrey.

[@arifjawad3787]

this was soo helpful . i was looking for this kind of tutorial and i totally learned a lot from this 3 video. thank you ...

[@AwaMelvine]

Thanks for watching, Arif.

[@nbjr3670]

Great job, I liked it. I would like to know if you have video tutorial of that your article about account management in php

[@codingtutorialpoint]

very very good. so much doubt is clear by this video.

[@benjieburillo5863]

thank you for your awesome tutorial bro :)

[@AwaMelvine]

Thank you too for watching!

[@camilleleost8312]

Thank you for your tutorial it is very well explained ! Keep on coding :)

[@masegomsomi]

This was really helpful!Thank you :)

[@MohammedAshraf]

I thank you from my heart

[@awaxxtechnologies9322]

Thank you very much for this bro. Very Useful

[@tjamtsho823]

This tutorial is very helpful. Thank you Mr. Melvine

[@AwaMelvine]

Thank you for watching!

[@ahmadyusuf5222]

I'm really happy I stumbled upon your page a few weeks ago... Your tutorial has really help me to build my backend skill. I would love it if you can give me an insight on error handling (a situation where the login and sign up form appears on the same page, if I enter wrong login details it will redirect me to the sign-up form)

[@ugifredrick8342]

Thank you for this sir👍... Pls sir, help make a functional PHP search bar, to search and play videos or musics from mysql database🙏🙏🙏

[@floki6939]

Man...God Bless. You're a life saver. Thank you soo much

[@User-is2kf]

hey man do you have the source code? getting errors

[@floki6939]

@@User-is2kf you mean the form validation messages? If passwords are right and such?

[@User-is2kf]

@@floki6939 yeah the source code

[@floki6939]

@@User-is2kf On around 15th minute, it's there. Some few lines. kzbin.info/www/bejne/iZnFeaqXnt6CptU

[@User-is2kf]

@@floki6939 no i meant fhe download link for the whole file.

[@Neguskk]

Amazing that this is free Thank you 10x Champ

[@clementwoo8011]

I followed the video of coding step-by-step, it was working fine until time stamp 1:09:16 of the video. Where no error message at the top when clicking the "Login" button without filling in the username and password. Need help and guidance, any reply would be grateful.

[@clementwoo8011]

Never mind! Solved my own mistake.

[@dark4evermgk115]

Have you posted the code anywhere? I have an error and I can't possibly find it

[@srikarkv1]

I need the code as well

[@JustinTheVlogger]

@@srikarkv1 Register | MJ Castillo Vlogs REGISTER Username:

[@srikarkv1]

MJ Castillo Vlogs hey can you provide the complete code please

[@srikarkv1]

MJ Castillo Vlogs like all php files

[@JustinTheVlogger]

Mr. Melvin Awa has no codes for copying, all you need to do is to understand what he is telling about.

[@Haider-ol7jr]

Hello sir thanks so much for the tutorial! I want to do this at 52:11 but idk how to make it could u maybe write an example? I would be so grateful!

[@kavithaks5544]

Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:\xampp\htdocs\SSP\Controllers\authController.php:59 Stack trace: #0 C:\xampp\htdocs\SSP\Signup.php(1): require_once() #1 {main} thrown in C:\xampp\htdocs\SSP\Controllers\authController.php on line 59 getting this error Please help

[@amazingdammy1987]

Good job, Awa. But, I keep having problem with registration page saying "The two password do not match" what should I do?

[@CrypticSin]

For some reason it logs me in when i signup for an account but when i try to log in it doesnt let me.

[@nandani4241]

its too much good thank you so much to share this it very helpfull

[@fa307]

Such an amazing video, thank u!

[@designallday5454]

thank you so much sir...it really help

[@Letsbehealthy437]

when i click on logout it showes this on the link section(localhost/user-verification/index.php?Logout=1) and it doesnt log out

[@senkottuvelan]

Thanks for the 💓. Can you help me out in a form that must be filled from the leftout point where the user can continue filling the form after another login.

[@reqiuemformydreams]

13:01 15:50 importing font 30:52 if statement for signup button 41:46 where i left off 12/23

[@reqiuemformydreams]

good job u hot (winks)

[@tlwilkinson]

Very good guides. Thanks.

[@oussamaibnidrys3692]

Trying to access array offset on value of type null in ? this is my problem on file login

[@The_OnlyWarrior]

52:48 (ignore It)

[@munteanionut3993]

thanks, man! You a true G!

[@howchess7631]

Fantastic video! Can we use it?

[@ismailhossain2059]

Can I get source code, Please?

[@K1ndaAv3rage]

Thank you very much awa, I just have a couple problems and was wondering if there was a way you could help me fix them, thanks again

[@jodoinscott]

58:30 "unsert". I paused the video to look it up. I thought it was a play on words: what's the opposite of insert? unsert! Haha. "Remove" is usually what is used.

[@AwaMelvine]

😂😂😂Very funny, Scott

[@XSYSequipmentservice]

Dear Sir, how can I use the CSS style sheet from stackpath in my code as style.css file as in you previous tutorials?

[@iameddieeuk5450]

If it's not working then in the form tag, remove the 'action="signup.php"' part

[@user-heke0621]

Excuse me, I completely followed your video to edit my Signup.php at 53:07, but it always display “Database error：failed to register" please teach me how to solve my problem😭Thanks!

[@thereborne3134]

me too

[@pushapakkumar866]

you can also be put only required in input to avoid that PHP code

[@mohammadmoheddinnajjar9131]

Hello, I have a question, would you please like to help me please?? thank you for the nice video it helped me a lot!!!

[@ShirishChavan333]

Nice video. Thank you.

[@agapaykalinaw9361]

Hello awa! I just want to ask why my database does not receive data from the registration form?

[@okellojohnsilas]

This has surely helped me

[@AwaMelvine]

Glad it helped you. Thanks for watching!

[@MegasXLR]

Shouldn't username be UNIQUE as well? Since it's possible to login via email or username.

[@jabe-tv]

Hallow, I am getting an error "Database error: Failed to register" please help

[@emiliobianchi3652]

After writing all the codes. only my hashed password appeared in the database. then any subsequent registration attempt kept saying email already exist , even as i was attempting different emails

[@cubedev4838]

Can u make website like udemy? No one created yet in this utube. If u created it u be the first 1. Your channel become more amazing!!

[@6191jaken]

If we are coming from the "How to create a blog PHP and MySQL database" series, do we need to watch all the videos in this series? That is, does that series seamlessly transition into this series?

[@Khalid_series]

Can you do a video for adding a book with respect to an image. As my page is currently html without any field with a button. And while clicking to button the corresponding book gets added to database.

[@raquelvillanuevadelmoral5413]

In the login file: I have some issues when you are checking the number of errors is 0 errors if(count($errors) === 0){ ... When I push "Login" button to check de errors display in red, my file got stucked and I don't know why. I'm using PDO btw and I've also tried with rowCount() but it didn't work either. Could you help me, please??

[@HunriX]

Please help me. :( I have this error-message: Parse error: syntax error, unexpected '$errors' (T_VARIABLE)

[@jeffreyyago1291]

same as me

[@ilxZfps]

@@jeffreyyago1291 I had this same issue but managed to fix it. Hopefully you guys found a fix but if not, my error was I hadn't included a ';' at the end of the line of code above it :)

[@adebofarrell5504]

@@ilxZfps Please i keep getting this error tried to solve it and it keeps fraustrating me please are the scripts where the error is found session_start(); require 'db.php' $errors = array(); $username = ""; $email = ""; Please can you specify exactly where to correct this, Thanks in advance.

[@ilxZfps]

@@adebofarrell5504 you need a ; after line 2 so: "require 'db.php';" :) if its a syntax issue then theres an issue with the language of ur code so u might have mispelt something or missed ; etc... in future look for that :)

[@adebofarrell5504]

@@ilxZfps Thanks so much really appreciated

[@romeobernabe2790]

Hi thanks for this....how about through sim card notifications/verification? thanks much

[@Hussein-Farraj]

Hello I am having trouble registering the emails. Everything seems to be working but I keep getting a register error. Could you help?

[@thereborne3134]

I keep getting : database error: failed to register. Can someone please help? I've been searching for hours seems like it doesnt 'if ($stmt->execute())' at the end. im not sure if the video is too old or.

[@MrMoto]

Check your SQL statement carefully. Does it correspond with your database structure?

[@shotsofkc]

got the same error have you figured it out? pls tell me thanks

[@MrMoto]

So in a case like this, simplify and isolate the problem. Set up a database table with only a single field (in addition to id), change your SQL statement accordingly, and get that working. Build up from there.

[@shotsofkc]

Timothy Mott thankyou!!!

[@splatm4n8]

TheReborne, I actually figured it out. I don't know if you also did this but I had but the following statement above "if($stmt->execute())" : "$stmt->execute();". Once I deleted that statement it worked exactly and it redirected me to the email verification page. I read your comments all over this comment section and figured that you might have had the same problem so I present the answer to you!

[@OppieT30]

Apparently the line in authController.php as of php 7 you need to change the line that says: $stmt->bind_param('ssbss', $username, $email, $verified, $token, $password); to $stmt->bind_param('ssiss', $username, $email, $verified, $token, $password); Otherwise it gives a error: Incorrect integer value: '' for column `user-verification`.`users`.`verified` at row 1. This is just for your information.

[@almasazizan6498]

Hi awa melvin , do you have code calender in php ? like a memo calendar to user check appointment

[@AwaMelvine]

Hi Almas Azizan, I don't have such a tutorial yet.

[@arsenharutjunjan5900]

Do you use javascript in this tutorial? If so please mention it for the viewers. Thank you.

[@woutflorian]

I am stuck on this part 52:45 When I try to submit I get the following errors; Warning: Undefined variable $conn in C:\xampp\htdocs\user-verification\controllers\authController.php on line 35 Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\user-verification\controllers\authController.php:35 Stack trace: #0 C:\xampp\htdocs\user-verification\signup.php(1): require_once() #1 {main} thrown in C:\xampp\htdocs\user-verification\controllers\authController.php on line 35 Any idea why?

[@kalingirisridhar]

Sir I have a doubt on it please help me inside login page I have created one page after I have adding two no and the result is generated the generated results we will store in database for particular person so what should I do

[@deanmulilo731]

i need some help with the signup page showing how can you help me despite everything looking ok?

[@AmatekTeekay]

Thanks a lot bro. Will it be OK to show you the project I am working on?

[@mohammadkazeminavaei5733]

very useful , thank you bro

[@chome4]

Links sent via email asking you to click to verify only appear as links if you give a gmail email address. If you use hotmail or yahoo mail, the 'link' will be text only.

[@tukuyoma]

awa please how do i echo a particular error...i tried but it not work i want to echo the error in the input field..can you help please

[@mohamedhasan7292]

i am having the same problem bro

[@mohamedhasan7292]

it worked for me now, the isset signup-btn was misspelt and also the fILTER_VALIDATE_EMAIL

[@akinkunmikehinde8664]

I did exactly how you explained in the video but I'm getting little error like password Conf not defined and I input yo correct password is not going through, kindly help out

[@CindersofOld]

So I've been having trouble with getting my php login page to actually show in my browser what I've done. It works if it's HTML, but not PHP. Every time I try and view the PHP it just showed the browser page as all script. I've had issues with installing my PHP extensions for my VS code, but I thought I had that fixed now since I'm not getting errors... I have no idea what to do at this point. :/

[@gi_or_gi]

use xampp

[@hazemkawas669]

i m experiencing the problem...' Database error: failed to register'..... I've checked everything and all seems to be fine, do u know what could the reason??

[@AwaMelvine]

You probably made a mistake when creating your table. Or you made a mistake with your query. Can I see your query?

[@tidrel7497]

I keep on getting errors on my token. $token = bin2hex(random_bytes(50)); Fatal error: Call to undefined function random_bytes() in /Applications/XAMPP/xamppfiles/htdocs/USER-VERIFICATION/controllers/authController.php on line 51