$result = Db::query("select *,round(6378.138)*2*asin (sqrt(pow(sin((:lat *pi()/180 - lat*pi()/180)/2), 2)+cos(:lat *pi()/180)*cos(lat*pi()/180)*pow(sin((:lng *pi()/180 - lng*pi()/180)/2),2))) as distance from court order by distance asc",
['lat'=>$lat,'lng'=>$lng]
);提示:SQLSTATE[HY093]: Invalid parameter number 最佳答案
