How To Create E-mail Subscription List On A Website

Welcome. Please Login, Register, Or Activate! 
type your username and password to login
Date: November 22, 2009, 01:17 PM
430762 members and 297898 Topics
Latest Member: physco
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Webmasters (Moderators: OmniPotens, yawa-ti-de)  |  How To Create E-mail Subscription List On A Website
Pages: (1) Go Down Send this topic Notify of replies
Author Topic: How To Create E-mail Subscription List On A Website  (Read 112 views)
Mbeki
How To Create E-mail Subscription List On A Website
« on: October 28, 2009, 03:45 PM »

Please can anyone guide me on how to create an e-mail subscribe and Unsubscribe link on my website. I want to be sending e-mail to people and want them to unsubscribe at will.
Thanks
yawa-ti-de (f)
Re: How To Create E-mail Subscription List On A Website
« #1 on: October 28, 2009, 05:42 PM »

Here's a quick and dirty way, assuming you hv the emails stored in a database:

1) Your unsubscribe link cd look like so: www.mbeki.com/emails.php?id=(id column of email in database)&unsubscribe=y

2) When the person clicks the link, of course taking care of sanitizing the input (for example, ensure that id is a number, etc), you store the id and unsubscribe values.

3) You then run an update on the email table, setting unsubscribe to Y where id = the id of the user

That should do it.  good luck!
Mbeki
Re: How To Create E-mail Subscription List On A Website
« #2 on: October 28, 2009, 08:17 PM »

I actually configured the e-mail with MS Outlook. What database are you talking about. i seem to be confused here.
yawa-ti-de (f)
Re: How To Create E-mail Subscription List On A Website
« #3 on: October 28, 2009, 08:38 PM »

hmmm, now I am confused to.  Not good  Cool

You mentioned a website at first, not any configuring with outlook.  Outlook can't unsubscribe you at all.  At best, you can create rules for redirecting certain emails to certain folders.  To actually get your name off of a list involves purging your record from a database, hence my response.

hmmm, i am still confused, then again, it takes very little to get me confused  Tongue
Sam Milla (m)
Re: How To Create E-mail Subscription List On A Website
« #4 on: October 28, 2009, 11:20 PM »

 Grin Grin

yawa you are doing a great job.

its like teaching Physics in Nursery school sometimes. weldone
yawa-ti-de (f)
Re: How To Create E-mail Subscription List On A Website
« #5 on: October 29, 2009, 12:55 AM »

Thanks  Smiley

Quote
its like teaching Physics in Nursery school sometimes
Is this good or bad?  Tongue
onye_ngbu (m)
Re: How To Create E-mail Subscription List On A Website
« #6 on: October 29, 2009, 10:36 AM »

Quote from: yawa-ti-de on October 29, 2009, 12:55 AM
Thanks Smiley
Is this good or bad?  Tongue

I think its child abuse. Grin  Grin
OmniPotens (m)
Re: How To Create E-mail Subscription List On A Website
« #7 on: October 29, 2009, 05:14 PM »

It is not child abuse at all. Because you know doesn't mean that others must know and it is not the way you learn that others do. I've seen people that I even give the actual codes to their problems and they still don't get it to work until I code the entire page up for them and upload online. Sometimes you don't blame them but that depends on the task in question and they person too concerned. He might be ready to learn but the atmosphere might be too tensed for him. When all is condusive, that moment I think all tutorials will be well understood and integrated.
emaginate
Re: How To Create E-mail Subscription List On A Website
« #8 on: October 29, 2009, 05:59 PM »

try using phplist,its free and open source and can easily be installed on your existing website
onye_ngbu (m)
Re: How To Create E-mail Subscription List On A Website
« #9 on: October 29, 2009, 06:55 PM »

Quote from: emaginate on October 29, 2009, 05:59 PM
try using phplist,its free and open source and can easily be installed on your existing website
Now that sounds less like child abuse Grin
yawa-ti-de (f)
Re: How To Create E-mail Subscription List On A Website
« #10 on: October 29, 2009, 07:36 PM »

Question(s):

Assuming these email addresses are collected via a form, so the poster should then maintain 2 databases/tables, copying from one to the other?  Isn't this double work?
bug24 (m)
Re: How To Create E-mail Subscription List On A Website
« #11 on: October 29, 2009, 08:24 PM »

lol @ onye_ngbu,  which one be child abuse again?
hostmot (f)
Re: How To Create E-mail Subscription List On A Website
« #12 on: October 29, 2009, 08:57 PM »

I think Mbeki is trying to connect his Microsoft Outlook list with that on his website.

That cannot be done as far as I know (but anything can be possible these days since the web came around).

You would have to choose between manual creation on outlook and automatic subscription on your website.

For automatic subscription, try yawa-ti-de's logic or phplist as someone suggested. If its too tough for you, hire a coder.

Olawunmi,
Hostmot Sales Rep. (www.hostmot.com)
 Wich Service? Yahoo?  Adsense For Feeds  Re: Cheapest It Tools In Lagos  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 


Sections: Autos/Cars (2) Jobs/Vacancies (2) (3) Career Talk Education General(2) Politics Romance Computers Phones Travel
Sports Fashion Health Religion Celebrities TV/Movies (2) Music/Radio (2) Books Webmasters Programming

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa. See also: Nairalist Classified Ads
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.