doutiaosu2310 2017-12-31 12:44
浏览 59
已采纳

Cron作业没有运行php脚本

I have created a cron job in my cpanel using command below:

/usr/bin/php -q /home/user/public_html/folder/subfolder/sync.php

The content of syns.php is almost like this. It works without error when I run it with the domain like domain.com/folder/subfolder/sync.php but I can not see the expected result when the cron job supposed to run which means cron job is not running the script. So can anyone tell me what might be the problem?

<?php

$dir = str_replace("public_html","", $_SERVER["DOCUMENT_ROOT"]);
$dir = $dir . "configuration.php";

if (file_exists($dir)) 
{
    require_once($dir);
    sync();
} 
else
{
    // echo ("Can't find the access data.");
}

function sync()
{
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
    if(mysqli_connect_errno())
    {
        // echo ("Failed to connect the database.");
        exit();
    }
    else
    {
        if(mysqli_ping($connection))
        {
            $query = "SELECT OR UPDATE WHATEAVER FROM TABLE;";
            $result = mysqli_multi_query($connection, $query);
            if($result)
            {
                // Do stuff
            }
            else
            {
                // echo("Failed to excute the query.");
            }
        }
        else
        {
            // echo("Failed to ping the connection.");
        }
    }
    mysqli_close($connection);
}

?>
  • 写回答

1条回答 默认 最新

  • duanqin9631 2017-12-31 12:52
    关注

    $_SERVER['DOCUMENT_ROOT'] is created by your webserver (e.g. Apache) before calling PHP. If you're running your script via a cronjob, you're bypassing your webserver and the DOCUMENT_ROOT will not exist.

    You should determine the location of your configuration file in another way. One way is to use PHP's built-in constants for file locations, like __FILE__ or __DIR__:

    $dir = __DIR__ . "/configuration.php";
    

    __DIR__ refers to the folder containing the current file, so this will become /home/user/public_html/folder/subfolder/configuration.php.

    From what you're doing with $_SERVER['DOCUMENT_ROOT'] I assume your configuration file is one folder up from public_html, so you could do something like this:

    $dir = __DIR__ . "/../../../configuration.php";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Arduino,利用modbus的RS485协议,进行对外置的温湿度传感器进行数据读取
  • ¥15 vhdl+MODELSIM
  • ¥20 simulink中怎么使用solve函数?
  • ¥30 dspbuilder中使用signalcompiler时报错Error during compilation: Fitter failed,求解决办法
  • ¥15 gwas 分析-数据质控之过滤稀有突变中出现的问题
  • ¥15 没有注册类 (异常来自 HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
  • ¥15 知识蒸馏实战博客问题
  • ¥15 用PLC设计纸袋糊底机送料系统
  • ¥15 simulink仿真中dtc控制永磁同步电机如何控制开关频率
  • ¥15 用C语言输入方程怎么