laravel Query distances between two coordinates with Eloquent 


        $latitude = $request->latitude;
        $longitude = $request->longitude;
        $distance = 30;

        $users = User::whereHas('userprofile', function($q) use ($latitude, $longitude, $distance)
        {

            $q->where([
            ['latitude',  '!=', $latitude],
            ['longitude', '!=', $longitude]
        ])
            ->whereRaw( DB::raw( "(3959 * acos( cos( radians($latitude) ) * cos( radians( latitude ) )  * 
                          cos( radians( longitude ) - radians($longitude) ) + sin( radians($latitude) ) * sin( 
                          radians( latitude ) ) ) ) < $distance ")
            );


        })->where('role', 2)->where('status', 1)->get();

Comments

Post a Comment

Popular posts from this blog

PHP PDO insert query

$insert_query = "INSERT INTO `comp_voting`(audio_id,competition_id,user_id) VALUES(:audio_id,:competition_id,:user_id)"; $insert_stmt = $conn->prepare($insert_query); $insert_stmt->bindValue(':audio_id', htmlspecialchars(strip_tags($_POST["audio_id"])), PDO::PARAM_INT); $insert_stmt->bindValue(':competition_id', htmlspecialchars(strip_tags($_POST["competition_id"])), PDO::PARAM_INT); $insert_stmt->bindValue(':user_id', htmlspecialchars(strip_tags($_POST["user_id"])), PDO::PARAM_INT); $insert_stmt->execute();
Read more

PHP PDO count row

$get_audios = "SELECT user_id FROM `comp_audios` WHERE user_id = :user_id AND competition_id = :competition_id"; $get_stmt = $conn->prepare($get_audios); $get_stmt->bindValue(':user_id', $_POST["user_id"],PDO::PARAM_INT); $get_stmt->bindValue(':competition_id', $_POST["competition_id"],PDO::PARAM_INT); $get_stmt->execute(); $count= $get_stmt->rowCount();
Read more