how to count distance from relational table in laravel code example
Example 1: laravel get distance between two locations
$sqlDistance = DB::raw('( 111.045 * acos( cos( radians(' . $data['lat'] . ') ) * cos( radians( addresses.latitude ) ) * cos( radians( addresses.longitude ) - radians(' . $data['lng'] . ') ) + sin( radians(' . $data['lat'] . ') ) * sin( radians( addresses.latitude ) ) ) )');
Example 2: laravel get distance between two locations
$stores = DB::table('stores') ->join('addresses','addresses.id','stores.address_id') ->select('addresses.latitude', 'addresses.longitude','stores.*') ->selectRaw("{$sqlDistance} AS distance") ->orderBy('distance') ->get();