how to check if the email is already in database in PHP/HTML/MYSQL/

Question

0.00/5 (No votes)

See more:

sample scenario

when i put the email address in the textbox it will automatically write email already exists

how to do that?

just need simple and basic answers thank you

Posted 9-Aug-12 18:46pm

newbie011292

Updated 9-Aug-12 19:04pm

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-08-09T19:03:00

Solution 2

Use AJAX. OnBlur or OnKeyDown, based on when you want, fire an AJAX call to server and check if the written text/email already exists or not. Based on the response received, display the content.

You can use traditional XMLHttpRequest or jQuery Ajax. Pick that you are suitable with.

Posted 9-Aug-12 19:03pm

Sandeep Mewara

Comments

newbie011292 10-Aug-12 1:08am

do you have sample code sir? just need basic and simple sorry sir im very newbie to this

Espen Harlinn 19-Aug-12 9:24am

Good advice :-D

reena_c · Answer 2 · 2012-08-09T18:57:00

Solution 1

ontextchange event of textbox call c# function that check email id present or not in a table

Posted 9-Aug-12 18:57pm

reena_c

Comments

newbie011292 10-Aug-12 1:02am

oh sir sorry this is not c#, this is php, html mysql thank you ;)

newbie011292 10-Aug-12 1:03am

sorrry my question is not specific