mysql 根据经纬度计算距离并排序

最新推荐文章于 2023-09-14 15:56:03 发布

Y-J-Le

最新推荐文章于 2023-09-14 15:56:03 发布

阅读量736

点赞数

文章标签： mysql php

本文链接：https://blog.csdn.net/Yangjiale521/article/details/108063964

版权

PHP 同时被 2 个专栏收录

19 篇文章 0 订阅

订阅专栏

Mysql

3 篇文章 0 订阅

订阅专栏

$lat=39.950273;
$lng=116.550167;

$sql="
        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
                        )
                    )
                ) * 1000
            ) AS juli
        FROM
            ".tablename('tablename表名')."
        ORDER BY
            juli ASC
    ";
    
    $list=pdo_fetchall($sql);