public function test(){
$lon = $_POST['LON']; $lat = $_POST['LAT'];
if ($_POST['time_val']) {
$insertTime = date('Y-m-d H:i:00',strtotime($_POST['time_val'].'-3 minutes'));
}else{
$insertTime = date('Y-m-d H:i:00',strtotime('-3 minutes'));
}
/*--------------------mysqli连接数据库,以便调用存储过程---------------------------*/
$con = mysqli_connect('数据库地址','root','root','kssy_db','3306');
//判断是否连接成功
if(!$con){
echo "数据库失败!";
}
$sql = "CALL getWindBack(0,".$lon.",".$lat.",'".$insertTime."',".$lon.",".$lat.",'".$insertTime."',1,@rLON,@rLAT);";
//调用存储过程
$res = mysqli_query($con,$sql);
//释放资源
mysqli_free_result($res);
//关闭mysqli数据库连接
mysqli_close($con);
/*--------------------------调用存储过程结束-----------------------*/
//再次查询,获取MySQL数据库数据
$list = M('dq_wind_insert_trail')->field(true)->where("LON=".$lon." and LAT=".$lat." and INSERT_TIME='".$insertTime."'")->select();
}