kerunt Posted February 26, 2006 Share Posted February 26, 2006 Hello,I need my code (PHP code which works with the MySQL database, processes info, and stores it back in the DB) to run every hour, and different code to run every 24 hours. What is the best way to achieve this? Is it possible to somehow store this code in the database itself and have it execute it?The only way I can think of for solving this problem is writing an stand alone application (C#) to do what I need, and just keep it running 24/7 - but this isn't very convinient.What's the best way to solve this problem?Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/3616-timed-code-executions-in-mysql/ Share on other sites More sharing options...
wickning1 Posted February 26, 2006 Share Posted February 26, 2006 Generally you set up a cron job, but that's on linux. On WinXP it'd be the scheduler or something. I always write my cron jobs in Perl, I don't know anything about PHP on the command line. Quote Link to comment https://forums.phpfreaks.com/topic/3616-timed-code-executions-in-mysql/#findComment-12542 Share on other sites More sharing options...
fenway Posted February 26, 2006 Share Posted February 26, 2006 Agreed -- although the new release of MySQL (5.1.6, I believe) has a scheduler that should make it into a GA version soon enough. But cron in the way to go. Quote Link to comment https://forums.phpfreaks.com/topic/3616-timed-code-executions-in-mysql/#findComment-12546 Share on other sites More sharing options...
kerunt Posted February 26, 2006 Author Share Posted February 26, 2006 Thanks guys. Quote Link to comment https://forums.phpfreaks.com/topic/3616-timed-code-executions-in-mysql/#findComment-12615 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.