Skip to main content
Missing Code
Missing Code
Inspiring
April 7, 2011
Answered

Creating an e-mail reminder system

  • April 7, 2011
  • 1 reply
  • 615 views

I need to build a system/file to send e-mail reminders from the web server to clients when their payment date is near. I aim to use PHP/MySQL on either Hostmonster or GoDaddy, if possible, to accomplish this.

My question is how do I go about programming something that will automatically work from the host web server. I only need it to activate once a day and send e-mail reminders to anyone who needs to be reminded.

Thanks.

This topic has been closed for replies.
Correct answer
Then use cron on your host to execute the script daily.

Um... that will automatically run. Google search of cron should give you more information regarding the process.

1 reply

A
Anonymous
April 7, 2011

Assuming you have rudimentary knowledge of programming and MySQL, simply add column in database for order date, then run a query to SELECT whatever FROM table WHERE order_date < NOW() - INTERVAL 1 MONTH

Change interval to whatever you want. Then After the query is run use the mail() function to send the mail. Pretty straight forward programming going on here. Then use cron on your host to execute the script daily.

Lon_Winters
Lon_Winters
Inspiring
April 7, 2011

I'm not sure if this is a requirement of the OP, but will that automatically run or does it have to be manually run from a form submit or something?

Missing Code
Missing CodeAuthor
Inspiring
April 7, 2011
Then use cron on your host to execute the script daily.

Um... that will automatically run. Google search of cron should give you more information regarding the process.


I used to think running scripts on the server was some mysterious process, but thanks for clearing it up! You really saved me.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices