PHP - Splitting Multidimensional Array Based On Values

Hi All

How do I go about splitting a multidimensional array into seperate smaller ones?

Currently I have $grade[region][userid]=value.

I'd like to split as $region1[userid]=value $region2[userid]=value $region3[userid]=value $region4[userid]=value $region5[userid]=value $region6[userid]=value
Is there an inbuilt function for this?

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)

I'm using smarty and php to collect parameters from a user defined tag in cmsms that looks like this... 

Code: [Select]
{schedule date="2010-11-13" time="7:05 p.m." location="Evansville" home="Oakland City" vs="Evansville" winner="University of Evansville" results="82-42"}

{schedule date="2010-11-15" time="7:00 p.m." location="Oakland City" home="Oakland City" vs="OSU-Lima" winner="OSU-Lima" results="68-67 2OT"}
etc...

As you can see each {schedule tag above has the same home="" value.  Thats because its schedule dates just for THAT team (i.e. Oakland City).  So I may have 10 of these tags on the same page.  But I also have other places where the schedule tag is used with a different $home name for another team.  So basically I'm calling ALL these schedule tags into one for loop like this...


Code: [Select]
for ($i=0; $i < count($params['date']); $i++) {
    $date= $params['date'];
    $time=$params['time'];
    $location= $params['location'];
    $home= $params['home'];
    $vs= $params['vs'];
    $winner= $params['winner'];
    $results= $params['results'];
    $gameinfo = array("date", "time","location","home","vs","winner","results");
    $game_info = compact($gameinfo);   

}

All I want to do is spit back out the total wins for each $home team.  I am pulling out my hair out trying to get this thing to work but no luck yet, even though I see a little light. This is what I got so far...

Code: [Select]
for ($i=0; $i < count($params['date']); $i++) {
    $date= $params['date'];
    $time=$params['time'];
    $location= $params['location'];
    $home= $params['home'];
    $vs= $params['vs'];
    $winner= $params['winner'];
    $results= $params['results'];
    $gameinfo = array("date", "time","location","home","vs","winner","results");
    $game_info = compact($gameinfo);   

  if($home == $winner) {
    $wins = array('team' => $winner, 'win' => count($winner));
  }

}

 $smarty->append('mwins',$wins);

print '<pre>';
print_r($wins);
print '</pre>';


and I get this...

Code: [Select]
Array
(
    [0] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [1] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [2] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [3] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [4] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [5] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [6] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [7] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [8] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [9] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [10] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [11] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [12] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [13] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [14] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [15] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [16] => Array
        (
            [team] => Oakland City
            [win] => 1
        )

    [17] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [18] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [19] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [20] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [21] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [22] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [23] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [24] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [25] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [26] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [27] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [28] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [29] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [30] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [31] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [32] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [33] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [34] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [35] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [36] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

    [37] => Array
        (
            [team] => Southern Indiana
            [win] => 1
        )

etc...


I want to take all the [win] values for each [team] and add them up this way my final array looks like this...

Code: [Select]

Array
(
    [0] => Array
        (
            [team] => Oakland City
            [win] => 18
        )

    [1] => Array
        (
            [team] => Southern Indiana
            [win] => 24
        )


I know I'm so close but don't know how to solve the condition I need. Any suggestions would be great!!!

bh

Hello. I am editing a plugin that is grabbing a multidimensional array, then breaking it out into a foreach statement and doing stuff with the resulting data.

What I am trying to do is edit the array before it gets to the foreach statement. I want to look and see if there is a key/value combination that exists, and if it does remove that entire subarray, then reform the array and pass it to a new variable.

The current variable Code: [Select]
$arrSlides returns several subarrays that look like something like this (I remove unimportant variables for the sake of brevity):

Code: [Select]
Array (
[0] => Array (
[slide_active] => 1
)
[1] => Array (
[slide_active] => 0
)
)
What I want to do is look and see if one of these subarrays contains the key slide_active with a value of 0. If it contains a value of zero, I want to dump the whole subarray altogether, then reform the multidimensional array back into the variable Code: [Select]
$arrSlides.

I have tried a few array functions but have not had any luck. Any suggestions?

Thanks in advance,
Jason

I have the following multidimensional array;

Array
(
    => Array
        (
            [value] => Alarm
            [safe] => Alarm
            [view] => Alarm
        )

    [1] => Array
        (
            [value] => Deadlocks
            [safe] => Deadlocks
            [view] => Deadlocks
        )

    [2] => Array
        (
            [value] => Security Doors
            [safe] => Security Doors
            [view] => Security Doors
        )

)

I'm trying to implode the array to end up with an output like "Alarm, Deadlocks, Security Doors".

But I cannot for the life of me work out the correct PHP.  I'm assuming i need some foreach loop? Any help would be greatly appreciated.