How to save different array data in cakephp

Question

My array is something different from normal cakephp array. now i want to save this data array using foreach loop.

[Data] => Array
        (
            [type_id] => Array
                (
                    [0] => 4
                    [1] => 5
                    [2] => 4
                    [3] => 3
                )

            [data_id] => Array
                (
                    [0] => 1
                    [1] => 3
                    [2] => 2
                    [3] => 1
                )

            [price] => Array
                (
                    [0] => 12
                    [1] => 213
                    [2] => 212
                    [3] => 23343
                )

            [amount] => Array
                (
                    [0] => 121
                    [1] => 342
                    [2] => 45454
                    [3] => 3243
                )

        )

i just want to a loop of foreach.

drmonkeyninja · Accepted Answer · 2015-06-24 08:07:00Z

2

You want to restructure your array first and then use saveMany() to save the restructured array:-

$data = array();
foreach ($array['ProductCharge'] as $col => $value) {
    foreach ($value as $key => $val) {
        $data[$key]['ProductCharge'][$col] = $val;
    }
}

$this->ProductCharge->saveMany($data);

It is better to use saveMany() than save each record in a foreach loop.

There is possibly a Hash method for restructuring the data without the need for the foreach loops, but can't think which would work as desired.

answered Jun 24, 2015 at 8:07

drmonkeyninja

8,5404 gold badges35 silver badges59 bronze badges

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

1 Comment

Cholthi Paul Ttiopic Over a year ago

surely Hash method magic w'd have done justice here. your answer looks somehow opaque. good one nontheless

Michel · Accepted Answer · 2015-06-24 07:27:38Z

0

I don't know which approach you've tried so far.

But $this->Model->saveMany($arrayVariable) should be just ok to save your data.

answered Jun 24, 2015 at 7:27

Michel

1,1651 gold badge10 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to save different array data in cakephp

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