无法从cron运行php脚本

Question

I am running LAMP system on ubuntu 14.04. I have an rss feed using php which runs every 1 hour and MySQL stores data. My php file used to run perfectly using php in cron some 15 days but its not working anymore

My cron is as below

0 * * * *  /usr/bin/php /var/www/html/rss.php >/dev/null

My php script is working perfectly from browser(firefox/chrome)

When I run the php script using wget in cron it works fine

0 * * * *  wget http://www.mywebsite.com/rss.php >/dev/null

Answer 1

Your script is using relatives pathes.

When you open this script in a browser it tries to find files in /var/www/html/.

When you do it in the cron it tries to find files in /.

Put this in the beginning of your script:

define('ROOT', dirname(__FILE__) . DIRECTORY_SEPARATOR);

Now change every relative include or opener:

include ROOT . "db.php"

...

    if (($handle = fopen(ROOT . "tbcatlist.csv", "r")) !== FALSE)