Jump to content


Photo

"Cron" & MySQL Help


  • Please log in to reply
3 replies to this topic

#1 dayzeday

dayzeday
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 01 May 2006 - 03:46 PM

I am needing to retreave a file from another website and insert the text into my database (MYSQL). I know that I need to use "CRON" to do this but I have no clue where to start. Can any one help me with this or point me to a tutorial.

Thanks

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 01 May 2006 - 04:09 PM

You only need a CRON per se if this a regular, schedule pull. Otherwise, a one-off script can handle this easily.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 dayzeday

dayzeday
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 01 May 2006 - 09:01 PM

[!--quoteo(post=370301:date=May 1 2006, 11:09 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 1 2006, 11:09 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
You only need a CRON per se if this a regular, schedule pull. Otherwise, a one-off script can handle this easily.
[/quote]

I am not sure what you are talking about. I have not used CRON yet. Which I now I need to learn it but i have yet to have time. It seems I get forced in to learning things when I have to. Maybe you can direct me to good tutorital or explain what u mean a little more. I do catch on pretty fast.

FYI: yes, i will be retrieving the file on a regular base at the same date and time each day or week.

Thanks

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 May 2006 - 06:50 PM

There are many tutorials on using CRON jobs -- the problem is that using PHP with CRON is, for some unknown reason, very complicated. I can't think of any good tutorials off-hand, though. Basically, your script does whatever it would normally do, and the CRON is simply a scheduling agent.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users