使用SQL Server 2012发送电子邮件vaidate [英] Email vaidate on using SQL Server 2012

问题描述

您好，

我有一个登录网页，我想检查网络上是否存在客户输入的电子邮件地址。这我想用SQL Server 2012做。我可以这样做，怎么样？

可以帮帮我一个人吗？



谢谢！

Hello,
I have a web page for login and i want to check if the email address that was typed by the client exist or not on the net. This i want to do using SQL Server 2012. Can i do this, and how?
Can help me somebody, please?

Thanks!

推荐答案

从我的观点来看，检查不可能直接但是相同你可以做其他方式如下...



检查是否唯一的方法



1 。地址有效

2.邮箱正常工作

3.邮件由店主发给



是发送包含链接和唯一令牌的确认电子邮件。接收者将点击链接并确认他收到了电子邮件。



总结：



1.生成一个唯一的ID并将其与散列提供的电子邮件地址一起存储

2.发送电子邮件到地址，并附上验证应用程序的URL

3。当点击URL时，您的应用程序将检查唯一ID是否与您生成的内容相对应并发送给用户



我希望这对您有所帮助。



干杯

Hi,

Well from my point of view that check is not possible directly but same you can do other way round as below...

The only way to check if

1. the address is valid
2. the mailbox is working
3. the email was given by the owner

is to send a confirmation email with a link and a unique token. The recipient will then click on the link and confirm that the he got the email.

Summarized:

1. Generate a unique ID and store it along with the hashed supplied email address
2. Send an email to the address with a URL to your validation application
3. When the URL is clicked your application will check if the unique ID corresponds to what you generated and sent to the user

I hope this will help you.

Cheers

这篇关于使用SQL Server 2012发送电子邮件vaidate的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！