Get distinct sum from an php array

Question

I have an array like this:

Array
(
    [0] => Array
        (
            [url_id] => 1
            [time_spent] => 41
        )

    [1] => Array
        (
            [url_id] => 2
            [time_spent] => 25
        )
    [2] => Array
        (
            [url_id] => 1
            [time_spent] => 41
        )
)

So, how to get the 'distinct' of time_spent and also the 'sum' of the time_spent.

Thanks.

Sarfraz · Accepted Answer · 2011-03-10 10:17:54Z

2

You can try:

$result = array_unique($input_array);
var_dump(array_sum($result['time_spent']));

Docs:

edited Mar 10, 2011 at 10:17

answered Mar 10, 2011 at 10:12

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

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

2 Comments

Shakti Singh Over a year ago

@vishnu: Really you needs i doubt, Accept your previous question keep in mind.

jon_darkstar Over a year ago

i believe that call to array_unique wont be effective bc it doesnt work on multi-dimensional arrays. youd have to do it AFTER making parallel (using the term loosely) array of just time_spent values

codaddict · Accepted Answer · 2011-03-10 10:21:30Z

2

Try this:

$sum = 0;
$timeSpent = array();
foreach($myArray as $element) {
    $timeSpent[] = $element['time_spent'];
    $sum += $element['time_spent'];
}

To have:

$sum => The sum of all time_spent
$time_spent => An array of all time spent (whitout URL)

edited Mar 10, 2011 at 10:21

codaddict

457k83 gold badges501 silver badges537 bronze badges

answered Mar 10, 2011 at 10:14

Akarun

3,3602 gold badges26 silver badges26 bronze badges

1 Comment

vishnu Over a year ago

hey, i need distinct sum of time_spent

Community · Accepted Answer · 2023-11-17 20:42:18Z

1

$ts = array_map(function ($a) {return $a['time_spent'];}, $arr);  //get array of time_spent's
$sum = array_sum($ts); //sum
$distinct = array_unique($ts); //distincts

One-liner for sum of distinct values

$ans = array_sum(array_unique(array_map(function ($a) {return $a['time_spent'];}, $arr)));

https://www.php.net/manual/en/ref.array.php

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Mar 10, 2011 at 10:23

jon_darkstar

16.9k7 gold badges35 silver badges38 bronze badges

Collectives™ on Stack Overflow

Get distinct sum from an php array

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related