How to convert following sql query to laravel query buillder?

Hi @ssquare

I'm afraid you need to go through that top to bottom first:

https://laravel.com/docs/master/eloquent

Hope it helps!

Hi @ssquare

Try to Raw Expressions query builder. https://laravel.com/docs/5.8/queries

Hope it helps!

@aurawindsurfing I don't find your answer helpful in any direction. Do you think that some people just rush without any sort of searching or going through documentation? You get the notification and rush to check the answers and get reply why don't you google yourself? What is that?

Anyway in case if you are looking for any more attempt how I tried this with a raw query before. Please refer to the question.

@mahaveer I have tried raw queries already but I could not get what I am doing wrong.

@ssquare accourding to your updated code, your having should be removed from the ->select() clause, to a ->having() clause:

        $query  = DB::table('branch')
            ->select(
                'id',
                'name',
                \DB::raw('( 3959 * acos ( cos ( radians(?) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(?) ) + sin ( radians(?) ) * sin( radians( latitude ) ) ) ) as distance')
            )
            ->having("distance", "<", $request->distance)
            ->orderBy('distance', 'asc')
            ->offset(0)
            ->limit(20);

        $data = $query->get();

@kima As you suggested, I tried with your answers but it showing Invalid parameter number

As there are parameters for latitude, longitude as well I tried with following:

$query  = \DB::table('branch')
            ->select(
                'id',
                'name',
                \DB::raw('( 3959 * acos ( cos ( radians(?) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(?) ) + sin ( radians(?) ) * sin( radians( latitude ) ) ) ) as distance',[$latitude, $longitude, $latitude])
            )
            ->having("distance", "<", $request->distance)
            ->orderBy('distance', 'asc')
            ->offset(0)
            ->limit(20);

        $data = $query->get();

But still, it's saying invalid parameter number.

@SSQUARE - Well I understood that you want to turn that into eloquent and run your query that way.

DB::raw has no $bindings parameter. please try this:

 $query  = DB::table('branch')
            ->select(['id', 'name'])
            ->selectRaw("( 3959 * acos ( cos ( radians(?) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(?) ) + sin ( radians(?) ) * sin( radians( latitude ) ) ) ) as distance", [$latitude, $longitude, $latitude])
            ->having("distance", "<", $request->distance)
            ->orderBy('distance', 'asc')
            ->offset(0)
            ->limit(20);

        $data = $query->get();