php Cron Jobs

Post Reply
User avatar
Saman
Lieutenant Colonel
Lieutenant Colonel
Posts: 828
Joined: Fri Jul 31, 2009 10:32 pm
Location: Mount Lavinia

php Cron Jobs

Post by Saman » Thu Aug 05, 2010 12:44 am

Manipulate strings of data. Query an assortment of databases. Send multi-part mail messages. Parse XML.

We’ve all heard of the many powerful and efficient uses for PHP as a Web language. But you can combine PHP with other tools to achieve a range of different results. One of those tools is Cron.

What is Cron?
Cron is very simply a Linux module that allows you to run commands at predetermined times or intervals. In Windows, it’s called Scheduled Tasks. The name Cron is in fact derived from the same word from which we get the word chronology, which means order of time.

Using Cron, a developer can automate such tasks as mailing ezines that might be better sent during an off-hour, automatically updating stats, or the regeneration of static pages from dynamic sources. Systems administrators and Web hosts might want to generate quota reports on their clients, complete automatic credit card billing, or similar tasks. Cron has something for everyone!

The PHP Script
Before we can even think of running a program, we will need a script to run. This script could be anything, but for the sake of this tutorial, let’s deal with a little mailing script. Imagine, for instance, you’re a stockholder of McDonald’s. You eat there every day -- breakfast, lunch, and dinner. You even make sure to have a McDonald’s employee wipe your seat before you sit down to enjoy your Super Sized Happy Meal, because, after all, you’re a stockholder!

So you write a script that checks the Dow Jones report every day after the closing bell rings at 4:00 pm. Because you’re a busy person and can’t afford to take a moment away from your PHP coding, you want to have this figure emailed to you. Let’s call this variable $mcdonalds. It will be fed to your mail script from a file called checkstock.php.

This is what this file (mailstock.php) might look like:

Code: Select all

<?php 
// mailstock.php 
include('checkstock.php'); 
mail('[email protected]','McDonalds Stock','Stock Price: '.$mcdonalds,'From:[email protected]'); 
?>
As this is simply an illustrative example, the details of checkstock.php are beyond the scope of this discussion.

Breaking Cron Down
Now, let’s try to set up the automated running of mailstock.php. If you are a systems administrator, you’ll be able to interface directly with Cron. On a standard Redhat setup, jobs are executed from /etc/crontab at predetermined intervals. We set thee intervals from within four directories that sort the jobs into hourly, daily, weekly, and monthly intervals.

Sometimes, however, you may want to execute a script overnight, on a weekend, or at some other time at which the server is not likely to be under a great deal of strain. This is where the crontab program comes into play. This executable is actually a go-between that exists between the users, who do not have permissions over the Cron folders and files, and the system that’s needed to run the Cron jobs.

Many hosts provide a GUI to administer the Cron jobs. This can simplify the setting up of Cron jobs, however, in the interests of understanding the nuts and bolts of this process, in this tutorial we’ll look at cron jobs from the command line perspective. We will approach this from the point of view of a normal user, but the process is essentially identical for System Administrators as well.

The easiest way to use crontab is via the crontab command.

Code: Select all

# crontab –e 
This command ‘edits’ the crontab. Upon employing this command, you will be able to enter the commands that you wish to run. My version of Linux uses the text editor vi. You can find information on using vi here.

The syntax of this file is very important – if you get it wrong, your crontab will not function properly. The syntax of the file should be as follows:

Code: Select all

minutes hours day_of_month month day_of_week command
All the variables, with the exception of the command itself, are numerical constants. In addition to an asterisk (*), which is a wildcard that allows any value, the ranges permitted for each field are as follows:
  • Minutes: 0-59
  • Hours: 0-23
  • Day_of_month: 1-31
  • Month: 1-12
  • Weekday: 0-6
We can also include multiple values for each entry, simply by separating each value with a comma.

command can be any shell command and, as we will see momentarily, can also be used to execute a Web document such as a PHP file.

So, if we want to run a script every Tuesday morning at 8:15 AM, our mycronjob file will contain the following content on a single line:

Code: Select all

15 8 * * 2 /path/to/scriptname

Getting PHP and Cron to Work Together
This all seems simple enough, right? Not so fast! If you try to run a PHP script in this manner, nothing will happen (barring very special configurations that have PHP compiled as an executable, as opposed to an Apache module). The reason is that, in order for PHP to be parsed, it needs to be passed through Apache. In other words, the page needs to be called via a browser or other means of retrieving Web content.

For our purposes, I’ll assume that your server configuration includes wget, as is the case with most default configurations. To test your configuration, log in to shell. If you’re using an RPM-based system (e.g. Redhat or Mandrake), type the following:

Code: Select all

# wget --help
If you are greeted with a wget package identification, it is installed in your system.

You could execute the PHP by invoking wget on the URL to the page, like so:

Code: Select all

# wget http://www.example.com/file.php
Now, let’s go back to the mailstock.php file we created in the first part of this article. We saved it in our document root, so it should be accessible via the Internet. Remember that we wanted it to run at 4PM Eastern time, and send you your precious closing bell report? Since I’m located in the Eastern timezone, we can go ahead and set up our crontab to use 4:00, but if you live elsewhere, you might have to compensate for the time difference when setting this value.

This is what my crontab will look like:

Code: Select all

0 4 * * 1,2,3,4,5 wget http://www.example.com/mailstock.php
Adding the Command to Cron
Okay, so we have a text file. Now what? Now we have to add the text file bearing the crontab to the list of scheduled items. To do that, we simply need to invoke the crontab command.

Code: Select all

# crontab stockcron
Summary
There are literally tons of things that can be done with PHP, and as many that can be performed with Cron. Hopefully this gives you a brief overview of some of the possibilities.

You can actually combine more elaborate PHP schemes into a single cron job simply by executing them via a single PHP file. As I mentioned before, it’s even possible to bypass wget by using PHP as a shell scripting language. This would require PHP to be compiled as a standalone binary, and that would bring with it a number of risks, but it can (and has!) been done.

The bottom line is that anything you can accomplish with PHP, you can likely automate with Cron. Happy coding!

Originally published at SitePoint.
Post Reply

Return to “PHP & MySQL”