如何检查电子邮件ID是否存在 [英] How to check whether email id exist or not

问题描述

亲爱的先生，
我想检查输入的电子邮件ID是否存在.

谢谢
Ankita Mali

Dear Sir,
I want to check whether the ,entered email id exist or not .

thank you
Ankita Mali

推荐答案

我要检查输入的电子邮件ID是否存在
何时何地?你尝试了什么? :doh:

我猜您想让某个功能检查您的应用程序中是否已存在emailid.为此，您需要使用电子邮件ID执行查询，并查看count是否大于零.如果是这样，它存在.

I want to check whether the ,entered email id exist or not
When, where? What have you tried? :doh:

I guess you want a feature to check if emailid already exists or not in your application. For that, you need to execute a query with the email id and see if count is greater than zero. If so, it exists.

SELECT COUNT(*) FROM EmailTable WHERE storedEmailIDs = '[e-mail]'

1.您不应该这样做.相反，当用户输入电子邮件地址时，通知用户该验证邮件将以相同的ID发送，并且在此之前，不允许他在网站上进行任何操作.

2.如果您指的是验证电子邮件地址，它可以是有效的电子邮件，则可以从网络上提供的大量正则表达式中使用.

3.如果您的网站像Gmail一样向用户提供了电子邮件地址，则您必须具有一个表来存储已采用的地址.当用户输入一个表单并提交该表单时，请检查该表单是否存在于数据库中，并返回适当的消息(如果该表单已经存在).

您可能已经注意到在问问题时进行描述的重要性.如果可以，请更新当前问题，并在下次尝试描述您的问题. :)

1. You should not do this. Instead, inform the user when he enters the email address that verification mail will be sent on the same id and till then do not allow him to do anything on the website.

2. If you are referring to validating email address that it can be a valid email, you are use from a large list on regular expression available on the web.

3. If your website provides the email addresses to the users, like Gmail does, then you must be having a table to store already taken addresses. When the user enters one and submits the form, check if it exists in the database and return appropriate message if it already exists.

You may have noticed the importance of being descriptive while asking the question by now. If you can, update the current question and try to describe your problem next time. :)

检查您的电子邮件信息，例如字符串比较

check your email-ides like the string comparison

这篇关于如何检查电子邮件ID是否存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！