If you use a shared-hosting web service, it may be more difficult to run a PHP script through Cron (Crontab).\u00a0 If your script uses MySQL calls for example, your hosting provider may not provide access to the MySQL library when your script runs through Cron.\u00a0 Here’s a\u00a0method that works just as well.<\/p>\n
<\/p>\n
Normally you might have a cron entry like this:<\/p>\n
But if the script contains calls to MySQL, you might get the error message:<\/p>\n In this case your hosting provider does not offer MySQL access when your script is executed through Cron.\u00a0 You can try placing the following code as the first line in your script file:<\/p>\n and then change your cron entry to:<\/p>\n But you might get the error:<\/p>\n Perhaps you can figure out the correct directory to specify for the PHP interpretter.\u00a0 A simpler method is to use cURL.\u00a0 This utility executes your script as if it were retrieved via an Internet browser.\u00a0 Remove the<\/p>\n line from your script and change your Cron entry to:<\/p>\n You’ll probably want to do a<\/p>\n on myscript.php so the outside world cannot read or execute it.\u00a0 The -s parameter tells cURL to run in silent mode.\u00a0 Otherwise you’ll get an e-mail with a progress indicator every time the script runs.<\/p>\n","protected":false},"excerpt":{"rendered":" If you use a shared-hosting web service, it may be more difficult to run a PHP script through Cron (Crontab).\u00a0 If your script uses MySQL calls for example, your hosting provider may not provide access to the MySQL library when your script runs through Cron.\u00a0 Here’s a\u00a0method that works just as well.<\/p>\n","protected":false},"author":65,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-software"],"_links":{"self":[{"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":0,"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"wp:attachment":[{"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/home.iseeancestors.com\/blog\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}10,0,*,*,*,\/usr\/bin\/php \/path\/to\/myscript.php<\/code><\/p>\nPHP Fatal error: Call to undefined function mysql_connect()<\/code><\/p>\n#!\/usr\/bin\/php -q<\/code><\/p>\n10,0,*,*,*,\/path\/to\/myscript.php<\/code><\/p>\n\/usr\/bin\/php: bad interpreter: No such file or directory<\/code><\/p>\n#!\/usr\/bin\/php -q<\/code><\/p>\n10,0,*,*,*,\/usr\/bin\/curl -s http:\/\/www.example.com\/myscript.php<\/code><\/p>\nchmod 760<\/code><\/p>\n