PHP - Changing a value from a query result using foreach [duplicate]

Question

I have a result from a SQL query stored inside $assignmentsViewList:

Array
(

    [0] => Array
    (
        [assign_id] => 302
        [ClassCount] => 25
    )

    [1] => Array
    (
        [assign_id] => 303
        [ClassCount] => 25
    )

    [2] => Array
    (
        [assign_id] => 325
        [ClassCount] => 25
    )

)

When I use it inside a foreach to change the value of ClassCount:

foreach ($assignmentsViewList as $task) {
    $task['ClassCount'] = 2;
}

It doesn't work. But if I try this:

$assignmentsViewList[0]['ClassCount']=2;

The code works well. But I need it to work inside the foreach loop.

What exactly are you trying to achieve here? Do you want to update all the ClassCount values? Or just one? — Indrasis Datta
– Indrasis Datta, Commented Oct 5, 2016 at 5:23
Please take a look at my answer. It should solve your purpose. — Indrasis Datta
– Indrasis Datta, Commented Oct 5, 2016 at 5:25

Indrasis Datta · Accepted Answer · 2016-10-05 05:23:59Z

2

In order to be able to directly modify array elements within the loop precede $task with &. In that case the value will be assigned by reference.

Reference: PHP foreach()

Try this:

foreach ($assignmentsViewList as &$task) {
    $task['ClassCount'] = 2;   /* It will overwrite all 'ClassCount' values to 2 */
}

answered Oct 5, 2016 at 5:23

Indrasis Datta

8,6182 gold badges18 silver badges32 bronze badges

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

1 Comment

Vince Parker Over a year ago

I have seen this '&' before, but I didn't know that this is needed when modifying. Thank you.

Glorfindel · Accepted Answer · 2022-02-04 09:02:37Z

1

use & .

Its means iterated over references to actual values of array &$task

 foreach ($assignmentsViewList as &$task)
{
  $task['ClassCount'] = 2;  values of array
}

without & means its iterated over copy of array value.so its not overwrite your array.

take a look in documentation

edited Feb 4, 2022 at 9:02

Glorfindel

22.8k13 gold badges97 silver badges124 bronze badges

answered Oct 5, 2016 at 5:36

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

Collectives™ on Stack Overflow

PHP - Changing a value from a query result using foreach [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related