php 调用飞信接口实现cacti的监控通知

<?php
include_once \'conn.php\';
$sql=\"select id,hostname,status_fail_date,status_rec_date from `cacti`.`host`;\";
$query=mysql_query($sql) or die(mysql_error());
$nums=mysql_num_rows($query);
if($nums!=0){
while($rs=mysql_fetch_array($query)){
if(strtotime($rs[\'status_fail_date\'])>strtotime($rs[\'status_rec_date\'])){
$sql1=\"update `cacti`.`host` set `status_now`=\'0\' where `host`.`id`=\".$rs[\'id\'];
$query1=mysql_query($sql1);//判断交换状态宕机更改数据库ststus_now值为0
}
if(strtotime($rs[\'status_fail_date\'])<=strtotime($rs[\'status_rec_date\'])){
$sql2=\"update `cacti`.`host` set `status_now`=\'1\' where `host`.`id`=\".$rs[\'id\'];
$query2=mysql_query($sql2);//判断交换状态正常更改数据库ststus_default值为1
}
}
}
?>

//该片段来自于http://outofmemory.cn