Problem with getting data from query in Laravel

Question

I have two tables

field_values (with some data)

id  field_id  value  label          sort
1       1       1     Men            1
2       1       2     Women          2
3       2       3     Relationship   1
4       2       4     Chat           2
5       2       5     Friendship     3

user_interests (with some data)

user_id  field_id  value_id
   1        1         1
   1        2         4
   1        2         5

I am trying to write a query where I will get user with id 1 and have field_id 2 and to be able to echo in my blade value_id 4 and 5 but not to echo those ids but to echo value of 'label' column that corresponds to value_id form user_interests table in this case 4,5 thus Chat, Friendship from field_values table in this example. Here is what I tried but I get array of six elements which are Relationship, Chat, Friendship x2. Any help is appreciated.

query:

public static function queryFunction($userId)
{
    $results = DB::table('user_interests as uin')
        ->select(DB::raw("
            fv.*,
            uin.field_id, uin.value_id
        "))
        ->join('field_values as fv', 'fv.field_id', '=', 'uin.field_id')
        ->where('uin.field_id', 2)
        ->where('uin.user_id', $userId)
        ->get();

        dd($results);

    return $results;
}

Autista_z · Accepted Answer · 2020-04-15 14:59:01Z

1

What about 2 clear steps, without join:

$user_interests = DB::table('user_interests')->select('value_id')->where('field_id', 2)->where('user_id', $userId)->get();

From this take values as array ($user_interests_values) and than

$results = DB::table('field_values')->whereIn('value', $user_interests_values)->get();

answered Apr 15, 2020 at 14:59

Autista_z

2,53118 silver badges25 bronze badges

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

5 Comments

rose Over a year ago

now when I dump $results I get error Object of class stdClass could not be converted to string

Autista_z Over a year ago

Which object? How did you get $user_interests_values array?

rose Over a year ago

Oh that is probably mistake. I passed $user_interests to whereIn in $results. What should I do with $user_interests_values variable/array?

Autista_z Over a year ago

$user_interests_values = $user_interests->pluck('value_id')->toArray(); (or $user_interests_values = collect($user_interests)->pluck('value_id')->toArray(); if pluck is not working on non model eloquent return, I dont remember)

rose Over a year ago

Works like a charm. Thank you very much!

Collectives™ on Stack Overflow

Problem with getting data from query in Laravel

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related