6. Sign Up Form and Email Activation PHP MySQL JavaScript Programming Tutorial

Learn to program a user sign up form and corresponding email activation script. We use HTML, CSS and JavaScript for user interfacing. The server side scripting is PHP connected to a MySQL database. Real time field restricting, user must view terms of use, real time username checking and more. Ajax is in use for all server side data transmissions. User must activate their account through email in order to interact on the site. The email activation process verifies and confirms that they have given you their real email address.

[epmedeiros]

For those having "signup_success" problem, here is the solution:
1-Clear the head of the signup.php file, the par take that all off.
2-if(ajaxReturn(ajax) == true) {
var txt = ajax.responseText.trim();
if(txt != "signup_success"){ status.innerHTML = = "block"; }

Done. the problems is, PHP put some blank spaces, after some times before the responseText.

Very good tutorial Adam, Thank You very much!

[SlyArtDesigns]

I think anyone willing to share free knowledge at this superior level is truly a godsend among men. This includes "the boring guy" from php academy, and the young buck from the new boston, and although I hold adam head and shoulders above them all, I truly admire each and every one of them, and find neither of them boring. I never copy the code. I follow the videos using the pause button religiously. Sometimes I find myself pulling out my hair plugs in long sessions of trying to find a missing quotation, or exclamation point, but finding the solution independently proves quite rewarding. However, this time, I'm truly stumped. I'm getting a blank activation page and I see many others are having the same issue. Any solutions...anyone?

[eyecee]

Did somebody say 5 mins, I'd say in less than 2 minute. The fastest response I've received on the web when it's not a live chat. Thanks Naveen.

[AndyCostelic]

Hi Adam Khoury  I really want to say big THANK YOU! I owe you a pint.
Your channel and your website literally get's me through uni hahaha.
Great Job! Thanks again. Hope I'll be able to help people like you are helping all of us
cheers Andy! Greetings from Scotland

[OgechiEbere]

This video is one year old...Hurray!!! It helped me much!!!

[josamuyi]

This is by far the best videos I've ever seen on YouTube...
Thanks Adam.

[Kishi]

Mr Adam You are great and you given us the real knowledge, i wish u long life and ability to give us more

[tauqeerawan]

Now in the age of HTML5, you can simply use <placeholder> attribute, so there is no need to use emptyElement function to remove anything from input fields.

[oldguyable]

yes this is best code I've found no wonder people scared of it complicated but very good code I learnt alot

[todd]

Thank you for this series! I am learning tons from you and thought I should give a word of appreciation! Thanks!

[aaronr]

Stuck at 54:18. Signup.php will not inject data to the users table, but it does for useroptions. I got the email to fire off and the activation url is carrying the correct variables to activation.php, also I ran a test and successfully wrote to the users table. I removed all hashing and checked for data mismatch as suggested. Several hours trying to debug to no avail so far.

[getrekt]

brother i was banging my head off the ground trying to figure out why ur code wouldn't write to phpmyadmin believe it was the simplest solution. you forgot to add name id string to the form elements. phew that took all day to figure out (im a beginner) im glad i figured it out though :D

[andrewmorris]

Thanks Naveen for all your help with this, I was stuck for days not knowing what to do!

and thanks Adam for the great tutorial

[oldschooled]

Naveen Ram is a GREAT GUY!
Adam isnt so bad either ;)

[frankyfrank]

You did not explain how to externalize the large list? Can you, thanks. 8:47

[djphaelix]

Yup, check to make sure that your db column names match exactly what you are trying to submit to. I am using the tutorials as a framework for something else so I changed what I called some things (rookie mistake lol) and that stopped everything. Also Adam is right, if you want to use the higher end password crypt() method there is lots of stuff online to help you, I got that working too. Hope this helps.

[LJDisparity]

Adam, you are the best tutorial video author I have ever come across! Amazing stuff :)

[oldschooled]

Php admin says user is activated, but when i attempt to sign in after activation is says "that user does not exist or is not yet activated, press back" ?

[zleereed]

@21:30... I print ajax.responseText and it IS signup_success, but the != always says it isn't! Why? I trace it right after and it says it is! :( What am I doing wrong?

[LindenMikus]

thanks adam, I used the logic in this vid to create an awesome registration form but instead of using php I used java server pages and connected them with java servlets using ajax in google's app engine hosted for free! its great