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
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)