By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,041 Members | 1,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,041 IT Pros & Developers. It's quick & easy.

Subscription mailing list

P: n/a
Hi All

Im building my first php site and what im looking for is a simple
tutuorial / example of a form which allows users to enter their email
address, which is stored in my Mysql db.

Also need to know how to go about mailing everyone who subscribes to
my news letter.

I know its probably quite simple, but i'd like to check for duplicate
email addresses, verify email addresses (dont know if that possible)
and allow them to un-subcribe.

Thanks in advance.
Robert, Inverness
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
*** robert wrote/escribió (6 Nov 2003 08:39:29 -0800):
but i'd like to check for duplicate email addresses
You can either make e-mail database field a unique key or, simply, perform
a SELECT query before inserting new addresses in order to check whether
user is already subscribed.
verify email addresses (dont know if that possible)
Add the address to a temporary table with a unique random id (like
kyzaxa3epada3ixy). Then send a message with instructions to activate the
account: "Visit http://www.site.com/activate.php?id=kyzaxa3epada3ixy".
In activate.php, check code exists, add data to final table and remove
temporary entry.
and allow them to un-subcribe.


It's almost the same as subscribing, just replace "INSERT" with "DELETE"
;-)

--
--
-- Álvaro G. Vicario - Burgos, Spain
--
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.