Cacher is the code snippet organizer for pro developers

<?php	
	$lat = Request::get('lat');
	$lng = Request::get('lng');
	$distancia = 10; // Distancia em kilometros

	$places = DB::select("SELECT * , ( 3956 * ACOS( COS( RADIANS( {$lat} ) ) * COS( RADIANS( latitude ) ) * COS( RADIANS( longitude ) - RADIANS( {$lng} ) ) + SIN( RADIANS( {$lat} ) ) * SIN( RADIANS( latitude ) ) ) ) AS distance FROM places HAVING distance < {$distancia} ORDER BY distance LIMIT 0 , 300");