Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $salons = Salon::select('salons.*')
- ->selectRaw('( 3959 * acos( cos( radians(?) ) *
- cos( radians( lat ) )
- * cos( radians( lng ) - radians(?)
- ) + sin( radians(?) ) *
- sin( radians( lat ) ) )
- ) AS distance', [$lat, $lng, $lat])
- ->havingRaw("distance < 25")
- ->where("category_Id" , "=" , $id)
- ->get();
Add Comment
Please, Sign In to add comment