Laravel returning only single column

Question

In my database I have categories and sizes, they have a table to match them together called category_sizes which looks like:

I want to get an array with all size_id where category_id = 4 so I did:

$catSizes = CategorySize::where('category_id', 4)->value('size_id');
return($catSizes);

But it returns one result only. How can I get an array with all size_ids so I can use it later in a where_in statement.

I also tried pluck but this gives also just one row.

$catSizes = CategorySize::where('category_id', 4)->pluck('size_id');
dd($catSizes);

My CategoySize model

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class CategorySize extends Model
{
    protected $table = 'category_sizes';
}

Alexey Mezenin · Accepted Answer · 2016-05-09 11:17:42Z

2

Try this:

DB::table('category_sizes')->where('category_id', 4)->get('size_id');

Or:

DB::table('category_sizes')->select('size_id')->where('category_id', 4)->get();

answered May 9, 2016 at 11:17

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Pᴇʜ Over a year ago

Just for my interest: Is there a reason why you suggested DB::table instead of using the model?

Alexey Mezenin Over a year ago

@Peh, I guess it's possible to use Eloquent here too (->pivot and ->withPivot methods): laravel.com/docs/5.1/eloquent-relationships#many-to-many - but I couldn't post working Eloquent code without testing (I don't have enough time for this right now, sorry).

Collectives™ on Stack Overflow

Laravel returning only single column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related