PHP MySQL Login Tutorial - Check if Username Exists

In another PHP MySQL login tutorial I'll teach you how to check if the users username exists already before it's created. This will stop multiple users from having the same username.

[OdinMKD]

BROTHER U JUST SAVED MY LIFE, thank you very much, i watched most of urs tutorials and i have learned php and mysql like never before !

[rajesh]

Can u please help me as I have an error saying Call to undefined function mysql_connect () in login. Php on line 6

[absolutelyangel]

Nice one, we need more people like you. Thank you

[AbdellahRamadan]

Thanks very much for this tut! it helped me solved a problem that disturbed me for more than 2 hours.

[hongomjoshua]

Thanks alot. it worked smart and have been of help to me. God bless u

[alexanderbulko]

Thanks. Was looking for something like the mysql_num_rows. :)

[KistlakRajapakshaSevenNet]

100% Perfectly Worked Bro !! :D
Thank U Very Much Bro !! :D

[martinluik]

Thank you for this! Easily explained and simple...

[dhananjayprajapati]

hii we used this local server then working properly but send the host then not working perfect header.

[shaikshafi]

Thanks very much...have been looking for the soltion.

[danielpettus]

I keep getting the duplicate entry method and it doesn't get to the check rows part, what should I do? please help lol. Duplicate entry 'rudolph' for key 'username'

[chocolatestealer]

How do i check if user ID exist or not ? Need help please. So far I did this

public function isUserIDValid($user_id){

return filter_var($user_id, FILTER_VALIDATE_REGEXP);
but i'm getting "filter_var(): 'regexp' option missing" in and also invalid ID. How do I solve this problem ? TQ

[fasihsheikh]

hey man you are going good. but what about the database after inserting the same name which is "admin". i wanted to show your database at that time.

[rajs]

Excellent bro!! It is working fine!! expecting more such good videos.

[stephanyjubill]

How can I call the Firstname from one page to other page using $_SESSION? I just want to display "Welcome".$_SESSION['Name']

[RaineZahra]

Thanks a bunch for this. I'm having some trouble though. On my website can simply enter anything you'd like into the login field and it will 'log you in.' How would I heck to see if the login, password and email match an entry in the database and deny the user access if they don't have an account? Maybe you already covered that and I just missed it.

[Anita]

thanks for sharing ur code really helped me a lot....:)

[patrickmoren]

Salamat HAHAH! Nakatulong ka ng malaki

[lourencemabasa]

simple, straight and forward thanks for the work!!

[Nemanja]

Can you help me this query("SELECT * FROM users WHERE username='$name' ");
returns zero rows, although there is that user in database.So i always get 0 rows but i should get atleast 1.