Need help in array manipulation (php)

Question

I have this $record array

array(4) { 
[0]=> array(2) { ["ROLE_ID"]=> string(1) "2" ["SUBFUNCTION_ID"]=> string(3) "904" } 
[1]=> array(2) { ["ROLE_ID"]=> string(1) "2" ["SUBFUNCTION_ID"]=> string(3) "903" } 
[2]=> array(2) { ["ROLE_ID"]=> string(1) "2" ["SUBFUNCTION_ID"]=> string(3) "902" } 
[3]=> array(2) { ["ROLE_ID"]=> string(1) "2" ["SUBFUNCTION_ID"]=> string(3) "901" } 
}

How can i manipulate it so it will become like this?

array("901","902","903","904");

Thanks in advance

alex · Accepted Answer · 2011-01-12 06:12:40Z

5

$subfunctionIds = array();

foreach($record as $values) {
   $subFunctionIds[] = $values['SUBFUNCTION_ID'];
}

// If you want them reversed like in your example output...
$subFunctionIds = array_reverse($subFunctionIds);

var_dump($subFunctionIds);

answered Jan 12, 2011 at 6:12

alex

492k205 gold badges890 silver badges992 bronze badges

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

1 Comment

cyberfly Over a year ago

Thanks alex! I cant believe it is that simple :D

StasM · Accepted Answer · 2011-01-12 07:06:06Z

2

    function fetch($row) {
       return $row["SUBFUNCTION_ID"];
    }
    $result = array_map("fetch", $record);
    sort($result);
    var_dump($result);

in 5.3+ you could do better:

    $result = array_map(function ($row) { return $row["SUBFUNCTION_ID"]; }, $record);
    sort($result);
    var_dump($result);

edited Jan 12, 2011 at 7:06

answered Jan 12, 2011 at 6:20

StasM

11.3k7 gold badges60 silver badges105 bronze badges

3 Comments

alex Over a year ago

The anonymous function is indeed much clearer - however, pre 5.3 it is kind of ugly (having to define a named function) :P

StasM Over a year ago

@alex you could use create_function() in pre-5.3, but I don't want to stuff too much into one answer :)

alex Over a year ago

Yeah, but it is not very pretty either. Looks just like a wrapper for eval(). +1 for array_map and anonymous function.

David Conde · Accepted Answer · 2011-01-13 05:51:11Z

0

Try doing this:

foreach ($array as $row ) {   
  $response[] = $row["SUBFUNCTION_ID"]; 
}
print_r($response);

edited Jan 13, 2011 at 5:51

answered Jan 12, 2011 at 6:14

David Conde

4,6472 gold badges37 silver badges48 bronze badges

3 Comments

alex Over a year ago

That will have $response equal to the last variable.

Samuel Herzog Over a year ago

you're missing the [] in $response[] = $row['SUBFUNCTION_ID'];. This will only print the last ID

alex Over a year ago

@Samuel Herzog He'll also get a warning if $response is not an array.

Collectives™ on Stack Overflow

Need help in array manipulation (php)

3 Answers 3

1 Comment

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related