How can I filter data from my array php?

Question

I am really struggling filtering my data.I know how to access parts of the array but am struggling on how to filter. I know how to do it in SQL SUM & count) but not when it comes to PHP arrays please help.

I need to filter some of my data stored in the variable $res.

I need to see how many times each 'REF' appears & total 'LCL_D_CBM' for each ref all of this where the "TERR" is equal to "TERR1".

foreach ($res as $res1){


   if ($res1["TERR"] == "TERR1"){

   //the individual ref 
   //$res1['REF'];  


   // the coutn of how many times each ref appears
   //echo count($res1['REF']);

   //sum
   //echo array_sum($res1['LCL_D_CBM']);    



   }
}

need result to be like -

CEA

3

2561

CEF

456

135

var_dump($res); gives me below

array(350) { 
  
[0]=> array(7) { [0]=> string(3) "CEA" ["REF"]=> string(3) "CEA" [1]=> string(5) "1.080" ["LCL_D_CBM"]=> string(5) "1.080" [2]=> string(3) "WF2" ["AREA_CODE"]=> string(3) "WF2" ["TERR"]=> string(5) "TERR1" } 
            
[1]=> array(7) { [0]=> string(3) "CEA" ["REF"]=> string(3) "CEA" [1]=> string(5) "2.000" ["LCL_D_CBM"]=> string(5) "2.000" [2]=> string(4) "HU13" ["AREA_CODE"]=> string(4) "HU13" ["TERR"]=> string(5) "TERR1" } 
            
[2]=> array(7) { [0]=> string(3) "CEF" ["REF"]=> string(3) "CEA" [1]=> string(5) "2.448" ["LCL_D_CBM"]=> string(5) "2.448" [2]=> string(4) "TW16" ["AREA_CODE"]=> string(4) "TW16" ["TERR"]=> string(5) "TERR2" } ..... etc

please reformat with line breaks. no one wants to scroll that. — Gordon, Feb 18 '16 at 12:53

Ole Haugset · Accepted Answer · 2016-02-18T14:52:24.730

2

You can solve it like this. Not a pretty solution, but should do the work. (I did not test this, so it might contain a spelling error or something):

$sum_lcl = 0;
$unique_refs = array();
foreach ($res as $res1){

    if (!array_key_exists($res1['REF'], $unique_refs)) {
        $unique_refs[$res1['REF']] = array();
    }   

    $unique_refs[$res1['REF']]['SUM'] = ( array_key_exists('SUM', $unique_refs[$res1['REF']]) ) ? ( intval( $unique_refs[$res1['REF']]['SUM'] ) + 1 ) : 1;
    $unique_refs[$res1['REF']]['LCL_SUM'] = ( array_key_exists('LCL_SUM', $unique_refs[$res1['REF']]) ) ? ( floatval( $unique_refs[$res1['REF']]['LCL_SUM'] ) + floatval( $res1['LCL_D_CBM'] ) ) : 1;


}


foreach( $unique_refs AS $unique => $data ){
    $title = $unique;
    $sum = $data['SUM'];
    $lcl_sum = $data['LCL_SUM'];
    echo "{$title}<br />{$sum}<br />{$lcl_sum}";
}

edited Feb 18 '16 at 14:52

answered Feb 18 '16 at 13:50

Ole Haugset

3,709
3
23
44

Your code sums all the LCL_D_CBM and the count how many times each ref appears doesn't work. please see edited question to see how I would like the results. Thank you – JIMMY THE CODE Feb 18 '16 at 14:02
Mkay. Edited my answer accordingly. From this point though, Id advice you to try yourself to change it if needed to actually learn from it :) – Ole Haugset Feb 18 '16 at 14:22
amazing could you put the icing on the cake and get it to display like in my question so i can get my head round it and learn it. Thank youuu – JIMMY THE CODE Feb 18 '16 at 14:33
Just remove the text I echoed and you would have that. just echo the $unique, $key and $value – Ole Haugset Feb 18 '16 at 14:37
Or add some
tags to make new lines if you like – Ole Haugset Feb 18 '16 at 14:38
the value echos two values (the count and the sum) ? could this be split? – JIMMY THE CODE Feb 18 '16 at 14:39
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/103856/discussion-between-jimmy-the-code-and-ole-haugset). – JIMMY THE CODE Feb 18 '16 at 14:40
Yes. echo $key; echo $value. Or as I said, if you want them on a new line echo $key; echo "
"; echo $value; or as I would properly do it: echo "{$key}
{$value}"; – Ole Haugset Feb 18 '16 at 14:41
The key echos - SUM and LCL_SUM the value echos the two values. How can i split value so can use as two diffrent vars – JIMMY THE CODE Feb 18 '16 at 14:45
Then just echo the $value variable. echo "{$value}
"; – Ole Haugset Feb 18 '16 at 14:47
yes that will put them on new lines but I want them as two diff vars – JIMMY THE CODE Feb 18 '16 at 14:49
See the updated answer again. There they are assigned to variables. This is more than what I have time for today, any further questions now and Id advice you to use google or php.net for reference – Ole Haugset Feb 18 '16 at 14:53
Thats it! all sorted :D Thank youuuuuuu – JIMMY THE CODE Feb 18 '16 at 14:55

How can I filter data from my array php?

1 Answers1