E-mail documents page design

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
bubberz
Forum Newbie
Posts: 14
Joined: Wed Jul 13, 2005 12:05 pm

E-mail documents page design

Post by bubberz »

I'm new to PHP, and am assigned a project to allow users to click checkboxes for which documents they want e-mailed to them monthly.

There are five documents they can choose from, and I was thinking the database would be 6 columns:
1. E-mail address as PK
2. 5 other columns representing the 5 documents as a bit type

What I don't know is how to start with getting a SPROC on mySQL for scheduled e-mailing, or if this is even available.

We've chosen a hosting site, so I'm wondering if there's anything I need to check with them first to see if this is possible.

Any suggestions are welcome!
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

for scheduled processes, you'll want to have a look at running a cron job.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
bubberz
Forum Newbie
Posts: 14
Joined: Wed Jul 13, 2005 12:05 pm

cron job?

Post by bubberz »

Thanks scrotaye!

What's a cron job?
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

a program that will run a specified script at specified time intervals without your interaction
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
bubberz
Forum Newbie
Posts: 14
Joined: Wed Jul 13, 2005 12:05 pm

Post by bubberz »

Great..thanks!

I'll look into it!
Post Reply