谈天说地程序交流 SEO 子枫CMS 发布问题

mysql通过经纬度按距离排序

 164

子枫 [Rainy] 2022-10-10

$latitude = input('latitude','');
$longitude = input('longitude','');
if($longitude!='' && $latitude!='' ){
$_jl_str = 'ROUND(
                6378.138  2  ASIN(
                    SQRT(
                        POW(
                            SIN(
                                (
                                    '.$latitude.'  PI() / 180 - latitude  PI() / 180
                                ) / 2
                            ),
                            2
                        ) + COS('.$latitude.'  PI() / 180)  COS(latitude  PI() / 180)  POW(
                            SIN(
                                (
                                    '.$longitude.'  PI() / 180 - longitude  PI() / 180
                                ) / 2
                            ),
                            2
                        )
                    )
                ) * 1000
            ) AS juli';
$order = 'juli ASC';
}else{
$_jl_str = 'id as _id';
$order = 'sort desc,id desc';
}
$where[] =  ['store_name','<>',''];
$where[] =  ['store_status','=','启用'];
$where[] =  ['is_delete','=','0'];
$list = ZFTB2('store_repairstore')->field('*,'.$_jl_str)->where($where)->order($order)->select();