Forum DB laravel - How to create a query that brings all the values from a column and that has another column equal to the a value (the auth user)

posted 8 years ago

How to create a query that brings all the values from a column and that has another column equal to the a value (the auth user)

I tryed

$user = Auth::user()->id;
$taskDistArray = DB::table('user_task')->select(DB::raw('task_id'))->where('user_id','$user')->get()->toArray();

but it doesn't show anything when i dd($taskDistArray)

Last updated 2 years ago.

replied 8 years ago

$taskDistArray = DB::table('user_task')->select('task_id')->where('user_id',$user)->get();

Last updated 8 years ago.

sabina2nistor sabina2nistor Joined 15 Jan 2017

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community