laravel groupby with array

Question

i have post with category

 $response=Post::groupBy('post_category','id')->get();

The above query will return all posts with category in the order of category.

Now i need to group all post inside category. Now i have one possible solution is i need to loop response and inside loop i have to check for category and create array. Is there a option to make it in a query something like groupconcat.?

My question is: Is it possible to create an array of category so key of an array is category_name and inside of category all post?

Updated

Post table

id | post_name | post_description | category_name | etc..

Here category name is not using any other table since its predefined values like news, sports, cricket something like... When i am inserting news, sports, political in categoryname.

@vision you want something like a pivot table on category_name? — madalinivascu
– madalinivascu, Commented Oct 10, 2017 at 11:57
somethink similar as you said without pivot table.i just want to club baes on category .otherwise i have to loop it and create an array. similar to has many — scott
– scott, Commented Oct 10, 2017 at 11:59

Praveen Tamil · Accepted Answer · 2017-10-10 12:02:07Z

4

The following code will return the key, value pair of post with unique category_name

$response = Post::get()->groupBy('category_name');
/*
    [
        'category_1' => [
            ['category_name' => 'category_1', 'post_name' => 'Chair'],
            ['category_name' => 'category_1', 'post_name' => 'Bookcase'],
        ],
        'category_2' => [
            ['category_name' => 'category_2', 'post_name' => 'Desk'],
        ],
    ]
*/

answered Oct 10, 2017 at 12:02

Praveen Tamil

1,16611 silver badges22 bronze badges

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

Comments

aaron0207 · Accepted Answer · 2017-10-10 14:16:25Z

4

You can't do it with a query, SQL group by will keep only one post for category so your query is incorrect. What you are looking for is:

$response = Post::get();
$response = $response->groupBy('post_category');

It will return a collection of arrays keyed by 'post_category' and containing all post from this category.

edited Oct 10, 2017 at 14:16

answered Oct 10, 2017 at 12:03

aaron0207

2,3531 gold badge20 silver badges25 bronze badges

Collectives™ on Stack Overflow

laravel groupby with array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related