This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Dreamweaver » query database then send results in email with cro

query database then send results in email with cro
Shannon Smith Member Since: 03 Aug 2007 Posts: 1	Posted 28 Mar 2008 07:37:53 Hi Does anyone know of an extension which can acheive some of this..... I am wanting to use a cron job to execute a php script to automatically query a MYSQL database then email the result to a user(s) in a DB. I am suing a LAMP stack. This is for a HR management system which does not have all the functions i need (orange HRM open source if you have heard of it) I have several of these scripts to set up but perhaps the easiest one woulde be querying a databse to find when a emploees details were last updated and if it has not been in the last 60 days then they are sent an email The main issue is i have never written a script like this before and after looking everywhere on the web cant find a good solution. Can someone please help? Hi Does anyone know of an extension which can acheive some of this..... I am wanting to use a cron job to execute a php script to automatically query a MYSQL database then email the result to a user(s) in a DB. I am suing a LAMP stack. This is for a HR management system which does not have all the functions i need (orange HRM open source if you have heard of it) I have several of these scripts to set up but perhaps the easiest one woulde be querying a databse to find when a emploees details were last updated and if it has not been in the last 60 days then they are sent an email The main issue is i have never written a script like this before and after looking everywhere on the web cant find a good solution. Can someone please help?

query database then send results in email with cro

Shannon Smith
Member

Since: 03 Aug 2007
Posts: 1

Posted 28 Mar 2008 07:37:53

Hi

Does anyone know of an extension which can acheive some of this.....

I am wanting to use a cron job to execute a php script to automatically query a MYSQL database then email the result to a user(s) in a DB. I am suing a LAMP stack. This is for a HR management system which does not have all the functions i need (orange HRM open source if you have heard of it) I have several of these scripts to set up but perhaps the easiest one woulde be

querying a databse to find when a emploees details were last updated and if it has not been in the last 60 days then they are sent an email

The main issue is i have never written a script like this before and after looking everywhere on the web cant find a good solution. Can someone please help?

Hi

Does anyone know of an extension which can acheive some of this.....

I am wanting to use a cron job to execute a php script to automatically query a MYSQL database then email the result to a user(s) in a DB. I am suing a LAMP stack. This is for a HR management system which does not have all the functions i need (orange HRM open source if you have heard of it) I have several of these scripts to set up but perhaps the easiest one woulde be

querying a databse to find when a emploees details were last updated and if it has not been in the last 60 days then they are sent an email

The main issue is i have never written a script like this before and after looking everywhere on the web cant find a good solution. Can someone please help?

Alan C
Total freaking Member

Since: 04 May 2006
Posts: 473

Replied 28 Mar 2008 12:15:43

HI
I've not done that but I did set up sendstudio for a client - that uses cron jobs to schedule sending emails, including breaking the list down so it keeps within server limits. The hardest thing was setting up the cron jobs using cpanel, because my hosting provider seemed to have disabled part of the cron setup, so it looked like I had set up the jobs but they never ran. Once that was sorted out things went very well

I'd suggest getting your script working with manual activation then once you are happy with that move onto the cron job.

Do you have the query etc already for checking things like the 60 days? - if not using a unix time based on seconds works very well - sorry if I'm suggesting things you already got sorted <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!