PHP Tutorials: jQuery: Check if a username is available without refreshing

[mjohnson0321]

THANK YOU!!! Awesome script and video!!

[kudafoolhu]

thanks :)

[champack2003]

Amazing & very comprehensive tutorial among thousand tut, its that what i was looking for . thax a lot & carry on...........

[to123156]

you should make a site where you can download all this 

[ANURAGSTAR]

nice video thnxxx.......

[MsMaxmax121]

good teaching

i liked how you made it and thank u

[MsMaxmax121]

good teaching



[youngbmale]

Alex would it be better to test the length before doing the query? Would this reduce the server load? Each key stroke being a query seem a lot if there are a lot of people connecting?

[MrKuntalstar]

thank you alex for ur awesome videos :) 

[rohitbellary]

username : form.username.value or username :  $('#username_input').val() is not working.....

[materally]

I wrote this code but it did not work..

If you have that problem, here the solution:

Because:

"username: form.username.value"

This row is not working.

Change this row this:

username: $('#username_input').val()

And it is going to work :)

Nice job Alex! ;)

[AndyKersy]

@phpacademy Just to let you know mate. I'm not sure if it's a problem just happening to me, but, if you have the 'DOCTYPE html' stuff in your header, the 'html' part stops this code from working.

However, I love the tutorial, it's really got me wanting to learn Javascript, which has always been my biggest hate to web development because it looks so confusing when you look at websites source codes.

[dudesnamehere]

any idea why this would be working on linux based systems (mac/android) and not on a Windows (XP or Vista machine)? I am hosting this on a linux server. I am new at this and looking for help.

[nicozarris16]

where to download the jqiery.js ?



[saikirakiva]

I am not sure why the check.php file doesn't load. Can someone please help me? Thanks!

[saikirakiva]

@saikirakiva Actually found out why. Miss a letter..haha..

[Zuberguber105]

what's the difference, ability wise, from jquery and ajax?

[marte197a]

people width undifined index just put in

check.php if(isset($_POST['username'])){

//add the rest of your code here

}

[tuanvietND]

Notice: Undefined index: username , Why,plz?

[rapblack2]

Good tutorial i was looking for some like that a long tie thx you so much good tutorial.

[anticlimax18]

$username = $_POST['xyz'];

Gives me ERROR

xyz Undefined

WHY?

[balanweb]

Man!! you doing a job that is greatly and hugely needed. I will make sure i spread the words around.

God bless - and keep on keeping on!!

[balanweb]

Alex, we have never met and perhaps we will never meet who knows. I am in USA. But,I must say, you have help me a great deal. I never thought I could have built a website from scratch. I have paid thousands of dollars to developers. Man!! you doing a job that is greatly and hugely needed. I will make sure i spread the words around.

God bless - and keep on keeping on!!

[ricsurfpro]

my falt i correct it and its working thanks !!

[ricsurfpro]

I hav a question i made it here and its ok but i need to insert things in my database

and wen i use action="insert.php" at form jquery do not work.

[TheOriginalVZdemon]

all php programmers i invite you to come and visit vzforumz.webs.com the newly found programming community.

[BugsVHumans]

Your work continues to inspire me. You're a great teacher. Please donate to Alex! I know I did.

[Hattlen]

with this code if a username with spaces after will be different to the same username without spaces

could you thumb up this comment so it gets recognised !!!

Thanks

[harleybalo]

You are a life saver alex!!!

[ChrisSnip]

Excellent, once again alex!

[ahmedihmeid]

Thanks, Great tutorial.

[MrFreshShizzle]

GR88888888888888888 Tutorial ... very well explained / broken down .. keep up the good work

[RomanovichCS]

great tutorial, but does not work on firefox :/

[harleybalo]

@RomanovichCS

It does work on my fireworks.

[ti07shadow]

I had it working but after typing the rest of the code. even after removing the new code after the displaying data from the check.php file it just stopped working?

[nicksalad]

All cool, but is not so much performance friendly when you have a big database if you are going to make a connection everytime the user presses a key, it should be on blur imo, and adding a wait period after checking would be useful as well. With a database of almost a million users like mine, it would kill the server, specially if those bad intentioned users play with it.

[DronElektron]

Thx man, this is very helpfull!

[reigngel]

form.username.value can be replaced by $(this).val()

Since you're already using JQUERY then why do you still mix it with DOM? JQUERY can do everything in shortcuts.

[guilohead]

Very good tutorial..

I tried in firefox and it dosen't work!

The error message is "undefined formlogin"

However, when I'm login in my website (with php) it works.

Why? Do you have any idea?

[extjac]

not working on firefox...any idea?

[mclaarson]

Very good tutorial, a very powerful tool too

[buhajus]

you are the best !

[phpacademy]

@buhajus I'm not the best, but I try! Thank you.

[bohterham]

@phpacademy

no you are :D

[SlobodanV1984]

@phpacademy Yes you are man. Great job you're doing. I've learned everything I know about php from you :-)

[stheodosiadis]

@phpacademy YOU ARE THE BEST. DON'T SAY I AM NOT THE BEST!

[buhajus]

you are the best !

[fastenterprises]

A hash mark "#" doesn't mean DIV, it means ID.

[JoWebsites]

Hey alex, i love your videos,

I just downloaded camtesia and im having trouble with the sound quality.

besides downloading it, do you do anything special to it to record ur videos?

How do you get such good sound quality?

[seretsu545212]

I have a question is it possible to use alert message if the username is unavailable?

[wizzy9906]

Thanks, this really helped me understand Jquery, wow it is amazing simple to implent.

[SaiyanJin85]

you could use $(this).val() instead of form.username.value to take the value

[mylescomputer]

Thanks, great tutorial :)

[JonnyJC93]

thanks , great video. really really much easier than you'd think. :)

[BugsVHumans]

Can you make an autocomplete tutorial? Thanks!

[joeydisessa]

Hello Alex , I have been watching your videos for a while and I must say you do a great job explaining while you te4ach PhP. Much appreciated. I'm not sure if you have a tutorial; on this already but i wasnt able to find it. Would you mind doing a simple video for passing XML using CURL in PhP? Thanks

[MrEcaz]

Brilliant!

Best tutorial ever, both explanatory and "project-wise"!

I mainly need the jQuery part for a letter counter but this will surely come in handy!

Keep it up!

[glfunkyspyspy]

alex , how you get the jquery.js file? i know on google but got a bunch of them.

[phpacademy]

@glfunkyspyspy jquery.com

[latlov]

@glfunkyspyspy from jquery.com click on download. you'll get this file jquery-1.4.2.min.js but you can save it as jquery.js

[amosngweien1]

@latlov ty

[eddilink]

thank you teaching

[xatic1]

Awesome tutorial! Still, it would be awesome to see how you can put data etc in the DB etc :D

[budesliga22]

alex u are great!

[shayat123456]

great tutorial!, code you please put the sorce code on your forum?

[mesuhas2010]

Thanks Alex

[willzurmacht]

Thank you!! very very helpful :)

[fastsol]

Very good! I have tried to turn several people to your channel in hopes of helping them. It's awesome to see that when a suggestion is made about a tutorial you actually do listen to us and go forth. Thanks again!

[rluximon]

great

[Timzy921]

:) Thanks for the tutorial

[machine1112]

where did you learned jQuery from is there any book or online course ?

[phpacademy]

@machine1112 I learnt it from Google. I've only been using it for a few days. Practice practice, and you'll get the hang of how easy it is to use.

[shaunno2009]

@phpacademy its one of the easiest languages to use I think

[gonzo191]

@phpacademy nice tutorial Alex but you can use $(function(){ ... }); instead of $(document).ready(function(){ ... }); it way shorter and equivalent as well

[JonnyJC93]

@gonzo191 its best to do a document check so that the jquery code isnt executed before the page is loaded. e.g. how can you animate a table if the table isnt on the page yet ?

[itsbrad212]

@machine1112 Many tutorials on the jquery.com website :D

[gonzo191]

@machine1112 you can learn it at jquery's site jquery.com or just google it

[SuperSimar1]

would it be possible to get the source code?

[classensoft]

good tut but in the check.php i would write else if ($check_num_rows>=1) because if there are two names with same beginging then there will be nothing. like: database: phpacademy phpacadami user insert: phpacade => there will be nothing tell me if i'm wrong

[katt157]

@classensoft The mysql db require it to the WHERE data to be exactly the in db one.

[stanisic1979]

great tutorial, thanks Alex.

[leavemealone300435]

is there a way for jquery to call a function in a php file called login.class.php. so i just want to have everything in one file but different functions.

[SuperSimar1]

your awesome.

[klassictechtutorials]

Wow, extremely useful! Thanks.

[9081178]

also, could you please explain the difference between Ajax and jQuery?

[vlogger3000]

@9081178 They are completely seperate things.

Ajax: When you combine HTML and Javascript to work in harmony. Pretty much 95% of Javascript is done this way so the term is redundant IMO. Same thing as DHTML.

jQuery: a Javascript library filled with essential functions. Hands down the most useful library for Javascript.

[9081178]

@vlogger3000 hmmm.... thanks.... :)

[cheatonly2win]

@vlogger3000 "When you combine HTML and Javascript to work in harmony." No..? It's nothing related to that.

[9081178]

hey Alex, you're no longer taking care of the video length. Please divide the videos in parts if possible. Its difficult to download such a big file at once. thanks.

[phpacademy]

@9081178 Sorry about that. In future I'll try and divide them up.

[MovieTrailersYay]

@phpacademy I actually prefer it. This way we know how long to expect the video to be.

[wideload123]

@9081178 why is shorter videos better ?

[DY357LX]

@9081178 I prefer the full-length video's. No more looking for parts 2+3 of the relevant tutorials.

Keep them this way please Alex, it's much better and more organized.

[leavemealone300435]

@DY357LX me too.

[cheatonly2win]

@9081178 No.. That's one benefit of being a youtube partner, being able to upload videos longer than 10 minutes.

[shaunno2009]

@9081178 just leave it for 5 - 10mins then come back to it. I have no problem with it being a long video but I have a good connection speed.

[9081178]

@shaunno2009 well, downloading is the main issue, here in Pakistan, load shedding is a big issue, the video is in the download process and the power goes out, and i have to download the whole thing again. i know its easier to watch the whole video at once, but download it is a main issue.

[shaunno2009]

@9081178 I see very understandable I know how annoying it is when then power goes off when your in the middle of something :P.

[9081178]

@shaunno2009 yeah dude, it sure is annoying.

[olukabruno]

I thought that only happens here in uganda...

[nuwaus]

@9081178 Don't you think all in one video is easy enough?

[9081178]

@nuwaus well, downloading is the main issue, here in Pakistan, load shedding is a big issue, the video is in the download process and the power goes out, and i have to download the whole thing again. i know its easier to watch the whole video at once, but download it is a main issue.

[Oblivionator8000]

3rd!



[cooldude3010]

YAY FIRST :D

[detroid89]

@cooldude3010 lol