473,387 Members | 1,812 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Subscription mailing list

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
1 1751
*** 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Dariusz | last post by:
I am a newbie to PHP, and newer still to MySQL. I have nearly finished writing (offline for use online) a PHP script that deals with people adding and deleting themselves off a mailing list...
4
by: Thom McGrath | last post by:
I'm writing a simple mailing list program, and I would like to know what the suggested method of sending a large number of emails to a list of addresses. (sounds like spam, no?) It's perfectly...
3
by: Dave Moore | last post by:
Hi All, Is it possible to implement a mailing list using PHP?. I know I could maintain a list of emails addresses in a db and send mail to them through my website, but how can I get true mailing...
0
by: Brian van den Broek | last post by:
Hi all, There have been a few posts over the last month or so expressing a bit of exasperation with the "rising tide of newbie's". (Or, more accurately, the rising tide of questions from...
0
by: James Litten | last post by:
Here's an example of using ASP, CDO and a Microsoft Access database to create a double opt in mailing list for subscribers. It lets the user subscribe and then sends them a confirmation email with...
6
by: Francois Suter | last post by:
To all French speakers on the list, I am pleased to announce the start of a PostgreSQL general mailing list in French. Its name is pgsql-fr-generale. I hope many of you will join it so that we...
4
by: Andy M | last post by:
ALERT There is a person by the name of Mike Cox who's trying to turn this mailing list into a Big-8 newsgroup. Many of you know that this and most of the other postresql mailing lists are...
1
by: philmaz | last post by:
What I am trying to do is create a form that people can use to enter their email address to sign up for a mailing list. Once they enter their email address, I want the script to open up a txt file...
1
by: 9jaman | last post by:
Can anyone help me find a solution to this problem.I need a desktop-based software or system for news alert service.I want to start a news alert subscription service based on recharge cards. The...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.