Jump to content


Photo

programming newsletter


  • Please log in to reply
30 replies to this topic

#1 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 06:20 PM

I am about to start a site creation for someone, he is wanting a newsletter on his site, where he can put what he needs to into it, and have it send to whoever he needs. Is it better to use a 3rd party script or create one from scratch, the project is for 500 for a site creation, recreating his old site, about 5-8 pages, and that's it, this is a challenge because the site is about something I know nothing about, but I have past content to go on, it's just the newsletter is what is making me wonder.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 25 May 2006 - 06:28 PM

Probably just as easy to write it yourself, but then again, if you need to ask the question, maybe its better to just download some existing script.

#3 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 07:09 PM

I know php programming very well, but I am unfamiliar with the act of programming a newsletter. A place where people sign up, and have it add it to a list, and automatically send a list to a bunch of people when the site own gets ready, looking at other newsletters all I see for the form action goes to a php script that mails it to the site owner, what do they do with the email after that. Programming is funer than grabbing a renegade 3rd party script for everything.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#4 litebearer

litebearer
  • Members
  • PipPipPip
  • Advanced Member
  • 2,357 posts
  • Locationwhite lake michigan

Posted 25 May 2006 - 08:10 PM

Perhaps something rather simplistic...

1. Form to subscribe to newletter (take data and add to database - might consider using a validate email so as to ensure subscriber is who they claim to be - use a 'valid' field in you table - 0 when first adding data, 1 when they validate --- and back to zero if they UNSUBSCRIbe)

2. UNSUBSCRIBE option on the site.

3. Policy regarding how email addresses will be handled by your client (not sold or given away etc) available on the site.

4. Check with host as to their policy regarding mass emails (ie what quantity and in frequency does mass mail constitute spam on their part)

5. Depending upon how client intends to create the newsletter, could either email link to current letter (html version); or have client publish newsletter in pdf format and either attaching it to an email OR provide link to view/download the pdf file.

Just some suggestions.


Lite...

all the brothers were valiant!

[br][br]The truely intelligent people are not those who create the dots; rather they are they ones with the ability to connect the dots into a coherent picture

#5 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 08:29 PM

That sounds good, how do I set up the situation where they can email the person back. I know how to create mail scripts, but I have to put in the information for it to mail, and I know how to process/validate forms of any manner/size. But what I am trying to figure out how to do, is set it up to where the emails can get sent out, or do I just gather the emails, and then have him send the emails through his email address, these are the details I am trying to work out, but what you said was very helpful I will keep all of that in mind when I start building it.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#6 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 09:06 PM

I have been looking around and I saw something like Mailing List Managers, is this something I can program myself, or something I have to find in a script, how do I create my own mailing list manager.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#7 rab

rab
  • Members
  • PipPipPip
  • Advanced Member
  • 155 posts

Posted 25 May 2006 - 09:21 PM

Create a database with colummes for user_name, email, subscribed. Then do something like this...

<?
$query = mysql_query("SELECT * FROM newsletter WHERE subscribed = 1") or die();
$news_query = mysql_query("SELECT * FROM news") or die();

while($info = mysql_fetch_array($query))
{
     --- build email headers ---
     while($news = mysql_fetch_array($news_query))
     {  
          --- get news info ----
     } 
}
 -blah --

Go along the basis of that


#8 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 09:26 PM

That's not the part I am confused about, I guess I misworded the question.
What I need to know is how to get it to where my client can email people
I know how to collect the information about the mailers, but I am confused about how to set it up to where the client can actively create and send a newsletter out to all the people.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#9 nogray

nogray
  • Members
  • PipPipPip
  • Advanced Member
  • 930 posts
  • LocationSan Francisco CA

Posted 25 May 2006 - 09:33 PM

try this [a href=\"http://tincan.co.uk/phplist\" target=\"_blank\"]http://tincan.co.uk/phplist[/a]

NoGray.com


#10 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 09:41 PM

This is helpful for something to look at, and if I get too bogged I will switch to this, but I want to get better at programming, now i am far from a beginning, I just need to learn how to put this together. I was finally pointed in advice earlier from someone on the components I need to program to send an email massly, but there is one thing I don't understand, how do I get my client access to where he can send the email, I could put a page on the server, that is password protected where he could send out bunches of emails.
But what I don't get though is I have never seen another site do that, to where they have a place where the client logged in to send the emails.
What is the best idea for me to set something up so he can get the emails to send.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#11 rab

rab
  • Members
  • PipPipPip
  • Advanced Member
  • 155 posts

Posted 25 May 2006 - 09:47 PM

I dont get why you want to make a news letter where the client sends letters

#12 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 09:50 PM

I mean my client.
Here is the thing, someone wanted me to build a site, no problem, they wanted a newsletter, to where people could sign up for the newsletter, this entails getting email address saved to a database, easy. But then I get down to trying to figure out, there has to be a way for my client, the one who will be owning the site, to be able to email all the people that sign up for the list. I have looked at other peoples websites and never saw anyone with an area on there websites for them to send emails to people on there mailing list, I am wondering how this is done, or how I set something up.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#13 rab

rab
  • Members
  • PipPipPip
  • Advanced Member
  • 155 posts

Posted 25 May 2006 - 09:51 PM

[!--quoteo(post=377128:date=May 25 2006, 05:21 PM:name=rab)--][div class=\'quotetop\']QUOTE(rab @ May 25 2006, 05:21 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Create a database with colummes for user_name, email, subscribed. Then do something like this...

<?
$query = mysql_query("SELECT * FROM newsletter WHERE subscribed = 1") or die();
$news_query = mysql_query("SELECT * FROM news") or die();

while($info = mysql_fetch_array($query))
{
     --- build email headers ---
     while($news = mysql_fetch_array($news_query))
     {  
          --- get news info ----
     } 
}
 -blah --

Go along the basis of that
[/quote]


#14 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 10:01 PM

By looking at that, it tells me that it is pulling the emails from the database, then
send the email, I understand all that, it's just about the issue of getting the client access to that, My client, the one the site is being built for doesn't understand php. I need to figure out where HE can send the email from. How do I set that up, I thought about a form, where he can just type out the newsletter, click submit and it sends it to all of them, but I have never seen another site do that before, unless they don't link it to the main site, do you understand what I mean.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#15 litebearer

litebearer
  • Members
  • PipPipPip
  • Advanced Member
  • 2,357 posts
  • Locationwhite lake michigan

Posted 25 May 2006 - 10:23 PM

Design it so the client only has to do 1 thing - create the newsletter. Then simply use a cron or taskscheduler to check the file date of the newsletter. Have the script compare that date with a corresponding field in the database ie lastsent. If the file date is newer than lastsent have the script AUTOMATICALLY send the emails; being sure to update lastsent to the date of the new newsletter.

all the brothers were valiant!

[br][br]The truely intelligent people are not those who create the dots; rather they are they ones with the ability to connect the dots into a coherent picture

#16 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 25 May 2006 - 10:24 PM

Make a newsletter admin page (where he must login too) with a form for him to put the email in and a send button. Done.

#17 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 10:25 PM

That is a little over my head, I am confused about the part where you stated.
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Design it so the client only has to do 1 thing - create the newsletter[/quote]
How do I get him to create the newsletter.
That is the part that is confusing me.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#18 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 25 May 2006 - 10:27 PM

What part dont you understand? There must be thousands of cms's that do this.

#19 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 25 May 2006 - 10:28 PM

PERFECT that was what I was wondering. So this should be the whole process.
I have a form, with 1 text field and submit button, this gathers the emails.
Or actually 2 buttons, subscribe unsubscribe, if they subscribe it adds the email to the database, if they unsubscribe it it takes it out.
Then I have it database that information.
Then I create another form, to where he puts in all the information he wants to send in the email and hits send, then I have to send an email to everyone in the database from there.
That is perfect, 2 more questions and I am ready to start.
1. Do I create the newsletter admin page on his server, but just don't link it to his site, and give him the url, like that, because I have never seen anything like that linked to a site before.

2. How would I accomodate the form to be able to accept pictures. He wanted to have like a picture of his book at top, then some information regarding the book, in his first newsletter, then whatever else in future ones.

edit- I meant I didn't understand what lite said, that specific part, was a little deep.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.


#20 litebearer

litebearer
  • Members
  • PipPipPip
  • Advanced Member
  • 2,357 posts
  • Locationwhite lake michigan

Posted 25 May 2006 - 10:29 PM

Ok, let us presume he has word or somesuch word processor (there are a ton of free ones availbale). All he does is sit at his computer and type up his newsletter, insert pics and graphics as he goes. THEN he uses one of the FREE pdf creators to create the pdf file. That done he simply uses a button YOU create that allows him to upload the new newletter. The rest is done with smoke and mirrors - magic - prestadigitation

all the brothers were valiant!

[br][br]The truely intelligent people are not those who create the dots; rather they are they ones with the ability to connect the dots into a coherent picture




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users