select.php

 $near = "SELECT c.id, c.name, c.email, c.phone, c.logo, c.banner, c.description, cl.lat, cl.lng, 
        ACOS( SIN( RADIANS( cl.lat ) ) * SIN( RADIANS( '$lat' ) ) + COS( RADIANS( cl.lat ) )
        * COS( RADIANS( '$lat' )) * COS( RADIANS( cl.lng ) - RADIANS( '$lng' )) ) * 6380 AS distance
        FROM CLIENT_LOCATION cl
        INNER JOIN CLIENT c
        on cl.client_id = c.id
        WHERE
        ACOS( SIN( RADIANS( cl.lat ) ) * SIN( RADIANS( '$lat' ) ) + COS( RADIANS( cl.lat ) )
        * COS( RADIANS( '$lat' )) * COS( RADIANS( cl.lng ) - RADIANS( '$lng' )) ) * 6380 < 10
        ORDER BY distance ASC";
//        
//        $foodtrucks = $this->db->query($near);
//        
        $foodtrucks = array();
        $stmt = $this->db->prepare($near);
        $stmt->execute(); 
        $foodtrucks = $stmt->fetchAll();
        $foodtrucks = json_encode($foodtrucks);

        //echo json_encode($foodtrucks);
        $response->withJson($foodtrucks);
        $response = $response->withHeader('Content-type', 'application/json');
        $response = $response->withStatus(200);
        return $response;