I am forming the query below:
SELECT *, ACOS( SIN( RADIANS( `latitude` ) ) * SIN( RADIANS('17.4073331') ) + COS( RADIANS( `latitude` ) )* COS( RADIANS('17.4073331')) * COS( RADIANS( `longitude` ) - RADIANS('78.3802307'))) * 6380 AS distance
FROM bbq_branches_by_city
HAVING distance <= 20
I am doing like below in laravel:
DB::table('bbq_branches_by_city')
->select(DB::raw("*, ACOS( SIN( RADIANS( `latitude` ) ) * SIN( RADIANS($lat) ) + COS( RADIANS( `latitude` ) )* COS( RADIANS($lat)) * COS( RADIANS( `longitude` ) - RADIANS($long))) * 6380 AS distance"))
->havingRaw("distance <= 20")
->get();
Can you let me know where I am mistaking?