Helpful Information
 
 
Category: Linux Help
Automatic execution of PHP to update MySQL?

Hi :)

I dunno if this is the right place to ask but I think it is :)
I have a PHP script which gets intel from the internet and stores it in a MySQL database. Getting the intel takes quite a while and needs to be done every 6 hours (can be 12 maybe but that's not important). Problem is, since it's a webpage which gathers the intel I have to trigger it automatically.

So my question would be is it possible to run a PHP script automatically? (say everyday at 6am and 6pm?) I've heard something about cron-jobs (?) in Linux but since I don't know that much about linux I have no idea how to use that.. Anybody has some experience with this or knows how can do this in another way?

(The data I collect are 150+ url's from which I analyse the numbers and strings I need and put them in several fields of my table) If I need to be more specific let me know plz!

Thanks!

Search this forum for cron and you'll find plenty of info about cron, at, lynx, wget, php and how to do it...
But yes, it's possible. Create a crontab to call you php page through lynx or wget to have a scheduled update of your db.

//NoXcuz

yeah cron job can do that thing for you.

and try searching forum for cron job and you may find an example. anyways i would move your thread to linux guessing that you are on linux machine.

jd

thanks for the quick replies..
I did search for 'automatic', 'update', 'mysql' but I forgot cron :o

well, actually I'm on a win2k machine myself but I have a webspace on linux somewhere.. wondered whether there was something with php able to do the job

On windows you could use the schedule service with AT to schedule a job like this. But then you can't use lynx or wget (don't think there are any ports to win32), but with PHP as a CGI, you should be able to call the page that does the update.

//NoXcuz










privacy (GDPR)