$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!"; } }