Page 1 of 1

How to automatically update mysql table through php?

Posted: Tue Apr 03, 2012 5:00 am
by nirosha
How to automatically update a mysql table by a specific date using php?
Eg: Calculate loan interest by every 1st of the month and update relevant mysql table automatically without any user interaction. Is this possible using php?

Re: How to automatically update mysql table through php?

Posted: Tue Apr 03, 2012 5:44 am
by Celauran
Write the update script in PHP, schedule its execution in cron.

Re: How to automatically update mysql table through php?

Posted: Tue Apr 03, 2012 10:07 pm
by nirosha
Celauran wrote:Write the update script in PHP, schedule its execution in cron.
thanks a lot for your quick reply. I'll check on that. I am totally new to cron jobs.