Find Nearest Location By Latitude and Longitude in Laravel 6

March 7, 2020 XpertPhp Comments 0 Comment

In this article, we can display the Nearest Location using the google map of Latitude and Longitude in laravel 6.

If you want to display a specific place according to a nearby place then you can display the Nearest Location using the below following example.

SQL Query

6371 * acos(cos(radians(" . $lat . ")) 

        * cos(radians(orders.latitude)) 

        * cos(radians(orders.longitude) - radians(" . $lon . ")) 

        + sin(radians(" .$lat. ")) 

        * sin(radians(orders.latitude))) AS distance

6371 * acos(cos(radians(" . $lat . "))

* cos(radians(orders.latitude))

* cos(radians(orders.longitude) - radians(" . $lon . "))

+ sin(radians(" .$lat. "))

* sin(radians(orders.latitude))) AS distance

Example

$lat = YOUR_CURRENT_LATTITUDE;
$lon = YOUR_CURRENT_LONGITUDE;
   
DB::table("orders")
    ->select("orders.id"
        ,DB::raw("6371 * acos(cos(radians(" . $lat . ")) 
        * cos(radians(orders.latitude)) 
        * cos(radians(orders.longitude) - radians(" . $lon . ")) 
        + sin(radians(" .$lat. ")) 
        * sin(radians(orders.latitude))) AS distance"))
        ->groupBy("orders.id")
        ->get();

$lat = YOUR_CURRENT_LATTITUDE;

$lon = YOUR_CURRENT_LONGITUDE;

DB::table("orders")

->select("orders.id"

,DB::raw("6371 * acos(cos(radians(" . $lat . "))

* cos(radians(orders.latitude))

* cos(radians(orders.longitude) - radians(" . $lon . "))

+ sin(radians(" .$lat. "))

* sin(radians(orders.latitude))) AS distance"))

->groupBy("orders.id")

->get();

Please follow and like us:

Related posts: