Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

setting a Cron job to Email users from database monthly

I'm looking for a way to email users within a database using PHP. I have never had to do this before so I new to this.

Any help would be greatly appreciated.

Ta Adam
0
Geektank
Asked:
Geektank
1 Solution
 
Radek BaranowskiFull-stack Java DeveloperCommented:
what do you have at hand ? own machine with php and mysql ? rented cloud server? hosting offering giving you access to php and mysql ?

basically what you need to do is to build php app which will contain
- code to query database for emails
- code to invoke sendmail() properly (or other php mailing function, which is available on your server) in some kind of loop going over the email set acquired from the database
- cron job set up accordingly to run your code once a month. if you have your own machine you can set up standard cron/windows scheduler job, if you are using some kind of hosting, you also should have access to cron setup, ehre you will give the name of the function or URL to invoke once a month to trigger your above function

that's a rought sketch, I know, but I'm not sure what do you have and whagt you can use, also what is you php level :)

cheers, hope this helps!
0
 
Ray PaseurCommented:
This article has some "getting started" resources for anyone new to PHP and MySQL.
http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now