Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHP Sum Array - sum only elemants of an array

Tags:

php

I have have an array as follows:

$row when I output the entire array it produces the following:

1. I like crisps (38) 37% 55% 8% 0%

When I echo one part of the array I get the 4 figures I am interested in.

echo "<td class='set1'>". number_format($row[6], 0) ."%</td>";

The above code outputs the following 4 numbers:

37% 55% 8% 0%

What I would like to do is simply ad the first two numbers together (i.e. 37% + 55%) and output the result (92%). Hope that helps?

I should also point out that the array contains much more information than just these four figures.

As requested: output from var_dump[6]

string(7) "36.8421" string(7) "28.9474" string(7) "39.4737" string(7) "23.6842" string(7) "28.9474" string(6) "8.0000" string(7) "23.6842" string(7) "39.4737" string(7) "11.1111" string(7) "13.8889" string(7) "11.1111" string(7) "13.8889" string(7) "17.1429" string(7) "20.0000" string(7) "28.5714" string(7) "25.7143" string(7) "34.2857" string(7) "28.5714" string(7) "28.5714" string(7) "28.5714" string(7) "20.5882" string(7) "20.5882" string(7) "11.7647" string(7) "29.4118" string(7) "17.6471" string(7) "20.5882" string(6) "3.0303" string(6) "2.9412" string(6) "3.0303" string(7) "38.2353" string(7) "12.1212" string(7) "27.2727" string(7) "18.1818" string(7) "33.3333" string(7) "34.7826" string(7) "17.3913" string(7) "30.4348" string(7) "17.3913" string(7) "17.3913" string(7) "13.0435" string(7) "30.4348" string(7) "27.2727"

Is there any way to do this?

Thanks in advance,

Homer.

Entire code - hope this helps:

if ($mysqli->multi_query($query)) {
do {
    /* store first result set */
    if ($result = $mysqli->store_result()) {
        $i = 1;
        while ($row = $result->fetch_row()) {
            if($i==1){
            echo "<tr><td class='qnum'><span class='bold'>". $row[3] .".</span></td><td class='qtext'> ". $row[4] ." (<span class='italics'>". $row[5] ."</span>)</td><td></td>";
            $i = 0;
            }

            echo "<td class='set1'>". number_format($row[6], 0) ."%</td>";
            $var =  $row[6];
        }
        echo "</tr>";
        $result->free();
    }
    /* print divider */
    //if ($mysqli->more_results()) {
      //  printf("-----------------\n");
    //}
} while ($mysqli->next_result());
}

The section where $row[6] appears is where the four firgures 37% 55% 8% 0% appear - I would like to add the first two of these figures together.

If this helps, here's the result of the SQL query

response    q1  Responses   qnum    Question_Text   Total   percentage
4           4   14          1       I like crisps   38    36.8421
3           3   21          1       I like crisps   38    55.2632
2           2   3           1       I like crisps   38    7.8947
1           NULL    0       1       I like crisps   38    0.0000

The what I'd like to do is ad the 36.8421 and 55.2632 together.

Hope this helps!

like image 838
Homer_J Avatar asked Jan 23 '23 05:01

Homer_J


1 Answers

I imagine you could use a combination of array_sum and array_slice:

$arr = array(1, 2, 3, 4);
echo "First sum: " . array_sum(array_slice($arr,0,2));
echo '<br />';
echo "Second sum: " . array_sum(array_slice($arr,2,3));

Output:

First sum: 3
Second sum: 7

EDIT: based on the updated question, you would need something like:

$str = "55% 23% 12% 20%";

// the below line can be omitted because of the way PHP handles conversions
$str = str_replace('%', '', $str);
$arr = split(' ', $str);
echo "First sum: " . array_sum(array_slice($arr,0,2)) . '%';
echo '<br />';
echo "Second sum: " . array_sum(array_slice($arr,2,3)) . '%';

Output:

First sum: 78%
Second sum: 32%
like image 164
karim79 Avatar answered Jan 31 '23 23:01

karim79