Find Nearest Location By Latitude and Longitude in Laravel 6

In this article, how can you Find Nearest Location By Latitude and Longitude in Laravel 6? so we will give you a simple example of how to get geolocation in laravel(latitude and longitude laravel).

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

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();