|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
||||
|
||||
|
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! |
|
#2
|
||||
|
||||
|
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
__________________
UN*X is sexy! who | grep -i blonde | date; cd ~; unzip; touch; strip; finger; mount; gasp; yes; uptime; umount; sleep |
|
#3
|
||||
|
||||
|
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
__________________
_____________________________ d.k.jariwala (JD) ~ simple thought, simple act ~ I blog @ http://jdk.phpkid.org |
|
#4
|
||||
|
||||
|
thanks for the quick replies..
I did search for 'automatic', 'update', 'mysql' but I forgot cron ![]() 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 |
|
#5
|
||||
|
||||
|
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 |
![]() |
| Viewing: Dev Shed Forums > Operating Systems > Linux Help > Automatic execution of PHP to update MySQL? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|