Linux Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsOperating SystemsLinux Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 23rd, 2001, 08:26 AM
Mirax's Avatar
Mirax Mirax is offline
Senior Member
Dev Shed Intermediate (1500 - 1999 posts)
 
Join Date: Jun 2000
Location: Enschede, The Netherlands
Posts: 1,527 Mirax User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 55 m 57 sec
Reputation Power: 15
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!

Reply With Quote
  #2  
Old October 23rd, 2001, 08:31 AM
NoXcuz's Avatar
NoXcuz NoXcuz is offline
Wiking
Dev Shed Expert (3500 - 3999 posts)
 
Join Date: Sep 2000
Location: Sweden
Posts: 3,608 NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 8 h 44 m 46 sec
Reputation Power: 25
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

Reply With Quote
  #3  
Old October 23rd, 2001, 08:34 AM
jdk's Avatar
jdk jdk is offline
phpkid ~~~~~~ :o)
Dev Shed Frequenter (2500 - 2999 posts)
 
Join Date: Nov 2000
Location: NJ, USA
Posts: 2,534 jdk User rank is Lance Corporal (50 - 100 Reputation Level)jdk User rank is Lance Corporal (50 - 100 Reputation Level)jdk User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 11 m 11 sec
Reputation Power: 15
Send a message via Yahoo to jdk
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

Reply With Quote
  #4  
Old October 23rd, 2001, 08:41 AM
Mirax's Avatar
Mirax Mirax is offline
Senior Member
Dev Shed Intermediate (1500 - 1999 posts)
 
Join Date: Jun 2000
Location: Enschede, The Netherlands
Posts: 1,527 Mirax User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 55 m 57 sec
Reputation Power: 15
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

Reply With Quote
  #5  
Old October 23rd, 2001, 09:13 AM
NoXcuz's Avatar
NoXcuz NoXcuz is offline
Wiking
Dev Shed Expert (3500 - 3999 posts)
 
Join Date: Sep 2000
Location: Sweden
Posts: 3,608 NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level)NoXcuz User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 8 h 44 m 46 sec
Reputation Power: 25
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsOperating SystemsLinux Help > Automatic execution of PHP to update MySQL?

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap