[Solved] Passing variable to php cron job.

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

[Solved] Passing variable to php cron job.

Postby WorldCom » Sun Aug 12, 2007 2:28 pm

I'm trying to do something that should be so simple.

I want to pass a variable to a php cron job script.
This is the php script:

Syntax: [ Download ] [ Hide ]
#!/usr/bin/php

<?php

require('connect.php');

$id = (int)$_GET['id'];

$game_data = mysql_fetch_array(mysql_query("SELECT game_id FROM game_data WHERE week=id"));

$update = "UPDATE results_data SET status='Closed' WHERE results_id=$game_data[0]";

$update_info = mysql_query($update) or die ('Database Error: ' . mysql_error());

echo "Cron Job ran Successfully";

?>

This works perfectly if put the 'id' in directly and not pass it. However, trying to pass the data gives the 'Input File not found error'. Now, doing some searching I came across a thread that said you can't pass variables in the tradtional sense. eg $_GET So the syntax was to just use a space.

eg. script.php variable1=value

This worked in the fact that I now get a MySQL error because of not reading the 'id' variable.

So how do you read php variables with a space instead of a question mark into the script?

Heres the cron job command line:
Syntax: [ Download ] [ Hide ]
php -q /home/mysite/public_html/cron/update_cron_22.php id=22


Any help appreciated.
Last edited by WorldCom on Sun Aug 12, 2007 3:02 pm, edited 1 time in total.
WorldCom
Forum Commoner
 
Posts: 39
Joined: Sat Jun 24, 2006 8:14 am
Location: Ontario, Canada

Postby VladSun » Sun Aug 12, 2007 2:43 pm

http://www.phpbuilder.com/columns/darrell20000319.php3?page=2

You don't have to do this like GET (i.e. var=value) - instead:



Syntax: [ Download ] [ Hide ]
php -q /home/mysite/public_html/cron/update_cron_22.php 22


And you'll have in $argv[1] value of 22.
User avatar
VladSun
DevNet Master
 
Posts: 4294
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Postby WorldCom » Sun Aug 12, 2007 3:02 pm

That's exactly what I was looking for.
Works great thanks :)
WorldCom
Forum Commoner
 
Posts: 39
Joined: Sat Jun 24, 2006 8:14 am
Location: Ontario, Canada


Return to PHP - Code

Who is online

Users browsing this forum: Google [Bot] and 13 guests