Modify multidimensional array value from searching by key = value

Question

I have an array here:

$records = array(
    array(
        'id' => 2,
        'first_name' => 'John',
        'last_name' => 'Doe',
        'num' => 123,
    ),
    array(
        'id' => 4,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
        'num' => 146,
    ),
    array(
        'id' => 8,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
        'num' => 253,
    ),
    array(
        'id' => 9,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
        'num' => 632,
    )
);

How can I search for ID 8 in array $results and modify the num? For example, find array that has ID = 8 and add 5 to the num? The the modified $result array will be:

$records = array(
    array(
        'id' => 2,
        'first_name' => 'John',
        'last_name' => 'Doe',
        'num' => 123,
    ),
    array(
        'id' => 4,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
        'num' => 146,
    ),
    array(
        'id' => 8,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
        'num' => 258,
    ),
    array(
        'id' => 9,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
        'num' => 632,
    )
);

you need to at least make an attempt

user8011997
– user8011997

2018-01-22 05:17:59 +00:00
Commented Jan 22, 2018 at 5:17 — user8011997
– user8011997, Commented Jan 22, 2018 at 5:17
refer stackoverflow.com/questions/6661530/…

Naincy
– Naincy

2018-01-22 05:21:55 +00:00
Commented Jan 22, 2018 at 5:21 — Naincy
– Naincy, Commented Jan 22, 2018 at 5:21

Rahul · Accepted Answer · 2018-01-22 05:45:38Z

2

This one liner trick will solve your problem,

$records[array_search(8, array_column($records, 'id'))]['num'] += 5;
print_r($records);

array_search — Searches the array for a given value and returns the first corresponding key if successful
array_column — Return the values from a single column in the input array

Here is working demo.

answered Jan 22, 2018 at 5:45

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

Comments

Talk2Nit · Accepted Answer · 2018-01-22 05:25:46Z

1

This is one way to achieve output

$records = array(
    array(
        'id' => 2,
        'first_name' => 'John',
        'last_name' => 'Doe',
        'num' => 123,
    ),
    array(
        'id' => 4,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
        'num' => 146,
    ),
    array(
        'id' => 8,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
        'num' => 253,
    ),
    array(
        'id' => 9,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
        'num' => 632,
    )
);

foreach($records as $key => $value)
{
    if($value['id']=='8'){
        $records[$key]['num'] = $value['num']+5;
    }   
}
    echo "<pre>";
    print_r($records);
    exit;

answered Jan 22, 2018 at 5:25

Talk2Nit

1,1353 gold badges22 silver badges38 bronze badges

Comments

Sarvan Kumar · Accepted Answer · 2018-01-22 05:27:45Z

1

Use this one...

foreach ($records as $key => $value) {
    $search_value = "";
    $search_value = array_search("8",$value);
    if($search_value!="")
        $value["num"] = $value["num"]+5;
    $result[] = $value;
}
print_r($result);

answered Jan 22, 2018 at 5:27

Sarvan Kumar

9252 gold badges11 silver badges27 bronze badges

Comments

Arun Kumaresh · Accepted Answer · 2018-01-22 05:29:03Z

1

try this

use &$r array is passed by reference so you can update the value in for loop without having the key

foreach($records as &$r){

 if($r['id'] == 8){
    $r['num'] = 258;
 }  
}

answered Jan 22, 2018 at 5:29

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

Comments

Gur Janjua · Accepted Answer · 2018-01-22 11:52:31Z

1

foreach($records as $key => $data) {
	if(in_array(8,$data)) {
		$records[$key]['num'] = 253+50;
	}
}

echo "<pre>";
print_r($records);

answered Jan 22, 2018 at 11:52

Gur Janjua

2532 silver badges11 bronze badges

Comments

Nims Patel · Accepted Answer · 2018-01-22 05:39:38Z

<?php
$records = array(
    array(
        'id' => 2,
        'first_name' => 'John',
        'last_name' => 'Doe',
        'num' => 123,
    ),
    array(
        'id' => 4,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
        'num' => 146,
    ),
    array(
        'id' => 8,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
        'num' => 253,
    ),
    array(
        'id' => 9,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
        'num' => 632,
    ));



 $id2 = searchForId(8, $records);



function searchForId($id, $records) {
   foreach ($records as $key => $val) {
       if ($val['id'] === $id) {

           $abc = $records[$key]['num'] = $val['num']+5;
           echo "<pre>";
           print_r($records);
       }
   }
   return null;
}
?>

Collectives™ on Stack Overflow

Modify multidimensional array value from searching by key = value

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related