CakePHP Hash Combine group array by value

Question

I have an associative array of data, from which need to group with associative array value.

$data = Array
(
    [0] => Array
    (
        [App] => Array
        (
            [id] => 12
            [user_id] => 121
            [skill] => Baking Cakes
        )
        [Project] => Array
        (
            [id] => 12
            [name] => P1
        )
        [User] => Array
        (
            [id] => 121
            [name] => Gwoo the Kungwoo
            [created] => 2007-05-01 10:31:01
        )
    ),
    [1] => Array
    (
        [App] => Array
        (
            [id] => 15
            [user_id] => 121
            [skill] => Baking Cakes
        )
        [Project] => Array
        (
            [id] => 13
            [name] => P2
        )
        [User] => Array
        (
            [id] => 121
            [name] => Gwoo the Kungwoo
            [created] => 2007-05-01 10:31:01
        )
    )
)

Is it possible to group above array using User.id using Hash utility? Like this:

Array
(
    [121] = Array
    (
        [0] => Array
        (
            [App] => Array
            (
                [id] => 12
                [user_id] => 121
                [skill] => Baking Cakes
            )
            [Project] => Array
            (
                [id] => 12
                [name] => P1
            )
            [User] => Array
            (
                [id] => 121
                [name] => Gwoo the Kungwoo
                [created] => 2007-05-01 10:31:01
            )
        ),
        [1] => Array
        (
            [App] => Array
            (
                [id] => 15
                [user_id] => 121
                [skill] => Baking Cakes
            )
            [Project] => Array
            (
                [id] => 13
                [name] => P2
            )
            [User] => Array
            (
                [id] => 121
                [name] => Gwoo the Kungwoo
                [created] => 2007-05-01 10:31:01
            )
        )
    )
)

I tried with few methods Hash::combine(), Hash::extract but couldn't achieve it. Can someone have an idea.

Thanks in advance!

you can make this array using foreach loop.

Md. Sahadat Hossain
– Md. Sahadat Hossain

2016-02-20 10:54:56 +00:00
Commented Feb 20, 2016 at 10:54 — Md. Sahadat Hossain
– Md. Sahadat Hossain, Commented Feb 20, 2016 at 10:54

Inigo Flores · Accepted Answer · 2016-02-20 11:43:26Z

1

The following line will produce an array similar to what you need:

$result=Hash::combine($data, '{n}.App.id', '{n}','{n}.User.id');

With the exception that the nested numerical index holds the number stored in App.id instead of a sequential numerical index.

This will work if App.id is unique in your result set. Alternatively, you can use Project.id as $keyPath.

Reference:

Hash::combine()

answered Feb 20, 2016 at 11:43

Inigo Flores

4,4591 gold badge17 silver badges37 bronze badges

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

1 Comment

geoidesic Over a year ago

You're just one step away - how to get this to use indexed instead of associative?

geoidesic · Accepted Answer · 2020-09-03 16:26:18Z

0

To improve @Inigo Flores answer, you can get indexed instead of associative by setting the second parameter to null:

$result=Hash::combine($data, null, '{n}','{n}.User.id');

answered Sep 3, 2020 at 16:26

geoidesic

5,1435 gold badges45 silver badges61 bronze badges

Collectives™ on Stack Overflow

CakePHP Hash Combine group array by value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related