Subscription mailing list

[robert]

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

[Alvaro G Vicario]

*** 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
--