Laravel 5.3 Query Not Return Result

Question

I am a writing a query in laravel 5.3 but query not return any data

when i run query in direct in mysql then it's work

query here

return DB::table('friends')
            ->join('users', function ($join) use ($user_id){
                $join->on(function ($joinin) use ($user_id){
                    $joinin->where('friends.user_one_id', '=', 'users.id')
                        ->where('friends.user_one_id', '!=',$user_id);
                })->orwhere(function ($andwhere) use ($user_id){
                    $andwhere->where('friends.user_two_id', '=' ,'users.id')
                     ->where('friends.user_two_id', '!=' ,$user_id);
                });
            })->where('status','=','1')
            ->where(function ($query) use ($user_id){
                $query->where('user_one_id', '=', $user_id)
                    ->orwhere('user_two_id', '=', $user_id);
            })->get();

and it possible that make this query using Eloquent ORM

Is the query builder smart enough to change != to <>

bumperbox
– bumperbox

2016-09-26 04:56:28 +00:00
Commented Sep 26, 2016 at 4:56 — bumperbox
– bumperbox, Commented Sep 26, 2016 at 4:56
Yes. Eloquent is smart enough :)

Filip Koblański
– Filip Koblański

2016-09-26 06:00:02 +00:00
Commented Sep 26, 2016 at 6:00 — Filip Koblański
– Filip Koblański, Commented Sep 26, 2016 at 6:00

Dwight · Accepted Answer · 2016-09-26 06:45:34Z

1

Instead of get(), try appending toSql() instead and inspect the result. This will show you the query that the query builder has built so you can compare it to the raw query you've written, and see if you can narrow down where you went wrong.

Also, that query would work fine in Eloquent, just use Friend::join... instead of DB::table('friends').

answered Sep 26, 2016 at 6:45

Dwight

12.5k6 gold badges53 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel 5.3 Query Not Return Result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related