public static function rsine($coordinates)
{
return '(6371 * acos(cos(radians(' . $coordinates['latitude'] . '))
* cos(radians(`lat`))
* cos(radians(`lng`)
- radians(' . $coordinates['longitude'] . '))
+ sin(radians(' . $coordinates['latitude'] . '))
* sin(radians(`lat`))))';
}
输出:
“message”:“sqlstate[42000]:语法错误或访问冲突:1064您的SQL语法有错误;请查看与您的MySQL服务器版本相对应的手册,以获得在”*,(6371*acos(cos(radians(28.392200))附近使用的正确语法\n*cos(radians(
lat
))\ n*cos(ra'在第1行(sql:select*from
users
其中存在(select*,*,(6371*acos(cos(radians(28.392200))\n*cos(radians(
土地增值
))\ n*cos(弧度(
lng
)\ n-弧度(77.320801))\n+sin(弧度(28.392200))\n*sin(弧度(
土地增值
))))作为距离
locations
在哪里?
用户
.
location_id
=
位置
.
id
和(6371*acos(cos(radians(28.392200))\n*cos(radians)(
土地增值
))\ n*cos(弧度(
液化天然气
)\ n-弧度(77.320801))\n+sin(弧度(28.392200))\n*sin(弧度(
土地增值
))))<8.04672订购人
distance
asc)和
用户
.
deleted_at
为空)”,
