Sum elements from array

Question

Here is my script:

<?php   
    $failas = fopen("info.txt", "r");
    while (!feof($failas)){
        $d = fgets($failas);
        $dExploded = explode ( "|", $d );
        list($dDate, $dTime) = explode(" ", $dExploded[substr_count($d, "|")]);
        $metmen[] = implode('-', explode('-', $dDate, -1));
        if(preg_match_all('/[|]\d+[|]/', $d, $match)){
            $numbers[] = implode('', $match[0]);
        } 
    }
    fclose($failas);
    foreach ($numbers as $key=>$value)
    {
        $naujas[$key] = $metmen[$key] . $numbers[$key];
        print $naujas[$key] . "<br>";
    }
?>

The output of this script is:

2015-04|500|
2015-04|1200|
2015-04|1000|
2015-04|1500|
2015-04|3400|
2015-03|1500|
2015-02|1500|
2015-03|3000|

I don't have idea how to sum same month |number| numbers. Maby you can help me?

I don't have idea how to sum same month |number| numbers which you can see in the output :) — Albance
– Albance, Commented Apr 26, 2015 at 15:49
create an array, with the month as the key, and while looping over your data add the number to that array key. — Sean
– Sean, Commented Apr 26, 2015 at 15:53

mcklayin · Accepted Answer · 2015-04-26 16:10:57Z

1

Try this:

$arr = array(
'2015-04|500|',
'2015-04|1200|',
'2015-04|1000|',
'2015-04|1500|',
'2015-04|3400|',
'2015-03|1500|',
'2015-02|1500|',
'2015-03|3000|');
$st = preg_replace('/[0-9]{4}\-[0-9]{2}\||\|/','',$arr);
echo array_sum($st);

If you need to summ by year-month:

$arr = array(
'2015-04|500|',
'2015-04|1200|',
'2015-04|1000|',
'2015-04|1500|',
'2015-04|3400|',
'2015-03|1500|',
'2015-02|1500|',
'2015-03|3000|');

$sub = array();
foreach($arr as $k=>$v)
{
    $value = preg_replace('/[0-9]{4}\-[0-9]{2}\||\|/','',$v);
    $key = str_replace('|'.$value.'|','',$v);
    $sub[$key][] = $value;
}

print_r($sub);
echo array_sum($sub['2015-04']);

edited Apr 26, 2015 at 16:10

answered Apr 26, 2015 at 15:55

mcklayin

1,36010 silver badges17 bronze badges

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

2 Comments

Albance Over a year ago

I know how to split and sum. But I need to sum only those numbers which are from the same month. 2015-03|1500| 2015-03|3000| 2015-03 - 4500

Pratik Joshi Over a year ago

@mcklayin , so is the answer proper?

Sean · Accepted Answer · 2015-04-26 16:10:44Z

0

An easy way to do this is to create an array, with the month being the key-

$months = array();
foreach ($numbers as $key=>$value)
{
    $month = rtrim("|",$metmen[$key]);
    $number = rtrim("|",$numbers[$key]);
    $months[$month] = isset($months[$month]) ? $months[$month]+$number : $number;
}
//print each month/sum
foreach($months as $month=>$number){
    print $month.' - '.$number . "<br>";
}

answered Apr 26, 2015 at 16:10

Sean

12.4k3 gold badges31 silver badges49 bronze badges

Collectives™ on Stack Overflow

Sum elements from array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related