How to automatically update mysql table through php?

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
nirosha
Forum Newbie
Posts: 5
Joined: Mon Feb 20, 2012 10:56 pm

How to automatically update mysql table through php?

Post 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?
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How to automatically update mysql table through php?

Post by Celauran »

Write the update script in PHP, schedule its execution in cron.
nirosha
Forum Newbie
Posts: 5
Joined: Mon Feb 20, 2012 10:56 pm

Re: How to automatically update mysql table through php?

Post 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.
Post Reply