示例#1
0
$mysql_server_name = MonitorConf::$dbhost;
$mysql_username = MonitorConf::$dbuser;
$mysql_password = MonitorConf::$dbpass;
$mysql_database = MonitorConf::$dbname;
$now = time();
$start_time = date('Y-m-d H:i', $now - INTERVAL * 60);
$end_time = date('Y-m-d H:i', $now);
$query_db_date = date('Ym', $now);
$conn = mysql_connect($mysql_server_name, $mysql_username, $mysql_password);
if (!$conn) {
    die('Could not connect: ' . mysql_error());
}
$sendmail = new SendMail();
$strsql = "select count(*) as number from weibotc.tc_topnews_" . $query_db_date . "  where UNIX_TIMESTAMP(time) >UNIX_TIMESTAMP(NOW()) - 60 *" . INTERVAL . " and time < DATE_FORMAT(now(),'%Y-%m-%d %H:%i');";
//echo $strsql;
$result = mysql_query($strsql, $conn);
/*
$row_num = mysqli_num_rows($result);

if ($row_num != 1) {
    die("Fetch error!");
}
*/
while ($row = Mysql_fetch_row($result)) {
    if ($row[0] <= WARN_LIMIT) {
        echo "sendmail";
        $sendmail->sendmail_func($start_time, $end_time, $row[0]);
    } else {
        echo "No reach limit!";
    }
}