Overbryd
Overbryd
Programming language:PHP
2021-06-04 05:37:00
0
Q:

laravel get distance between two locations

Susan Malkin
Susan Malkin
Code: PHP
2021-05-22 12:00:01 
$stores =  DB::table('stores')        ->join('addresses','addresses.id','stores.address_id')        ->select('addresses.latitude',                   'addresses.longitude','stores.*')        ->selectRaw("{$sqlDistance} AS distance")        ->orderBy('distance')        ->get();
0
michnguyen
michnguyen
Code: PHP
2021-01-20 03:08:12 
$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 ) ) ) )');
0

Tags

Related

New to Communities?

Join the community