Laravel 5.7: Database query returning no values

Question

I'm trying to retrieve a group of post IDs from my likes table where the user ID is equal to the ID stored in the Auth Session.

So far I have tested retrieving data in multiple ways, if I select all the likes from the table it works fine, the auth ID retrieved from the session is the same as the one stored in the likes table so should produce a match and return data.

Here's the code I'm currently working with:

    public function index()
    {

    $userid = Auth::id();

    $userLikes = likes::all()->pluck('post_id')->where('user_id', $userid);

    dd($userLikes);

    }

The columns names within the table are as follows:

id
created_at
updated_at
user_id
post_id

I have tried this method of writing the query however am experiencing the same issue, no errors and no data.

DB::table('likes')->pluck('post_id')->where('user_id', $userid)->toArray();

I am looking to have an array of post ids for the posts liked by the logged in user so that it can be passed into the view.

Thanks in Advance

Brian Lee · Accepted Answer · 2018-12-29 01:47:19Z

1

If you've created User, Post, and Like models with the appropriate relationships, you can do the following:

$ids = auth()->user()->likes->pluck('post_id')->toArray();

The model's would have relations defined as:

// User.php
public function likes()
{
    return $this->hasMany(Like::class);
}

public function posts()
{
    return $this->hasMany(Post::class);
}

// Like.php
public function user()
{
    return $this->belongsTo(User::class);
}    

public function post()
{
    return $this->belongsTo(Post::class);
}   

// Post.php
public function user()
{
    return $this->belongsTo(User::class);
}

public function likes()
{
    return $this->hasMany(Like::class);
}

Alternatively, using the query builder:

DB::table('likes')->where('user_id', auth()->id())->get('post_id')->toArray();

edited Dec 29, 2018 at 1:47

answered Dec 29, 2018 at 1:42

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Laravel 5.7: Database query returning no values

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