#!/usr/bin/php -q
<?php
$config = include(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'configs' . DIRECTORY_SEPARATOR . 'database.php');//数据库配置
//数据库连接
function getDBConn($dbname = "api")
{
$config = include(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'configs' . DIRECTORY_SEPARATOR . 'database.php');
$dbh = new PDO('mysql:host=localhost;port=3306;dbname=' . $dbname . '', $config['default']['username'], $config['default']['password']);
$dbh->query("SET NAMES UTF8");
return $dbh;
}
$db = getDBConn($dbname = "api");
$time = time() - 10;
$list = $db->query("select * from arrange where status= 0 and uptime<=" . $time . " limit 5")->fetchAll(PDO::FETCH_ASSOC);
$data1 = array();
foreach ($list as $list_key => $list_value) {
$task = explode("-", $list_value['task']);
unset($list_value['status']);
$data1[$task['1']][] = $list_value;
}
脚本可触发脚本执行脚本
#!/usr/bin/php -q
<?php
$cmd = "/usr/bin/php -q in.php";
pclose(popen($cmd.' > /dev/null &', 'r'));// 触发autocall.php脚本
//脚本名+空格+参数+空格+参数
$cmd = "/usr/bin/php ".MODULE_PATH."controller".DS."common".DS."getdata.php ".$getdata_link." ".$gettime
pclose(popen($cmd.' > /dev/null &', 'r'));// 触发脚本
getdata.php
$argv[0]为触发getdata.php的脚本名
$url=$argv[1];// 获取数据地址;
$interval=$argv[2];// 时间间隔;