[RESOLVED] Cron job fwrite() issue

hotet

In my web solution I have a code segment that looks as following, it gets some data and tries to write it to a txt file. This is executed by a cron job.

	$filename = "myfile.txt";
if(is_writable($filename)) {

if (!$handle = fopen($filename, 'w')) {
	 print "Cannot open file ($filename)";
	 exit;
}
$result_on = mysql_query("SELECT <query>")or die(mysql_error());
$var1 = mysql_num_rows($result_on);

$result_top = mysql_query("SELECT <query>")or die(mysql_error());
$var2 = mysql_result($result_top,0);

$content = $var1 . " " . $var2;

if (fwrite($handle, $content) === FALSE) {
   echo "Cannot write to file ($filename)";
   exit;
}
fclose($handle);
}

The problem is that the writing process never occurs, even tho no error is generated. What is even more strange is that when I manually browse the file, the writing process occurs as intended.

My crontab looks like this:

* * * * * /usr/bin/php -q /var/www/html/v2/cron.php

rsmith

It looks to me that you check to see if the results of your fwrite() are false but don't actually tell your script to echo or write anything. Instead you check to see if the file is writable, if it is, run a set of queries, but don't echo the results of the queries or fwrite() anything to the file.

hotet

rsmith wrote:
It looks to me that you check to see if the results of your fwrite() are false but don't actually tell your script to echo or write anything. Instead you check to see if the file is writable, if it is, run a set of queries, but don't echo the results of the queries or fwrite() anything to the file.

if (fwrite($handle, $content) === FALSE) {
       echo "Cannot write to file ($filename)";
       exit;
}

I assume it's this you are refering to. What it do is it performs the fwrite() and checks the return value at the same time. As I wrote in the original post, the code it self works when I browse the page manually.

The problem is, also as stated in the original post, the file writing does not accur when executed by the cron job, even tho no errors are reported.

Also, both the cron file and the target file both have chmod 777.

snapbackz

Make sure you use the full path to your file....

$filename = "home/yourpath/public_html/myfile.txt";

Not sure if it'll help but I had a problem with cron not executing and the full path solved it. 🙂

hotet

snapbackz wrote:
Make sure you use the full path to your file....
$filename = "home/yourpath/public_html/myfile.txt";
Not sure if it'll help but I had a problem with cron not executing and the full path solved it. 🙂

Thanks! It did the trick! I'll mark this as resolved!