sum of array values in php using array

Question

I am learning php as part of my studies and at the moment I want to read a csv file into an array and then count all the values. I have successfully read the file and can display all the values in the csv file but am unable to sum/ add them in order to find a total.

Here is my code so far:

   <?php
            $data= explode(",",
              file_get_contents('https://www.mywebsite.com/test.csv')
            );
    $total = 0;
            $lengthofarray=count($data);

            for($x=0;$x<=$lengthofarray;$x++)
            {
                $total = $total + $x; 
//I am not sure if I am missing something here in order to make it working
            }
            echo "  ".$total."<br/>";
    ?>

I know that this is a basic question but I have spent more than 12 hours in order to achieve the solution and have search internet to find the solution but unable to do so.

Here are the values from my csv file:

0.78
0.19
0.78
0.98
0.65
0.79
0.34
0.29
0.55
0.95

Marc · Accepted Answer · 2015-03-23 12:40:04Z

1

You used $x (the iterator) instead of the $data you got out of the file :)

To make sure PHP treats the $data as int - cast it:

 <?php
    $data= explode("\n",file_get_contents('https://www.mywebsite.com/test.csv'));
    $total = 0;
    $lengthofarray=count($data);

    for($x=0;$x<=$lengthofarray;$x++) {
       $total = $total + (int)$data[$x];
    }
    echo "  ".$total."<br/>";
 ?>

But the better way would be to use foreach:

$data= explode("\n",file_get_contents('https://www.mywebsite.com/test.csv'));
$total = 0;

foreach($data as $current) {
    $total += $current;
}
echo "  ".$total."<br/>";

To load a .csv file there is fgetcsv():

$data = fgetcsv(fopen('test.csv','r'));

Update: Now you posted your .csv: You need to use a new line as separator and not a comma :) edited my samples - and the new best way would be to use file()

$data= file('https://www.mywebsite.com/test.csv');
$total = 0;

foreach($data as $current) {
    $total += $current;
}

echo "  $total<br>";

edited Mar 23, 2015 at 12:40

answered Mar 23, 2015 at 11:40

Marc

3,7198 gold badges37 silver badges49 bronze badges

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

6 Comments

Newbie Over a year ago

Hi Marc Thanks for the suggestions but when I use your code $data= explode(",",file_get_contents('mywebsite.com/test.csv')); $total = 0; foreach($data as $current) { $total += $current; } echo " ".$total."<br/>"; It gives me only value at first position in the array. Also I am not sure about fgetcsv(...) that should I replace the first line in my code? If yes then I get error message when I run the code

Marc Over a year ago

Could you post your .csv? Make sure, that you open a file handler while using fgetcsv (and use a relative path)

Newbie Over a year ago

Yeah I have managed to resolve the error but my loop runs only once and gives me the value at array[0] and thats it. I have a csv with only one columns and more than 2000 rows and I want to add all the rows in the csv file.

Marc Over a year ago

Can you post your current code and the .csv? (at least 10 entries so I can see if there is something wrong with my code)

Newbie Over a year ago

Here is the code I am using: $data= fgetcsv(fopen('mywebsite.com/test.csv')); $total = 0; foreach($data as $current) { $total += $current; } echo " ".$total."<br/>"; And for CSV file I am not sure how to upload it here as there is no option to upload a file...

|

Collectives™ on Stack Overflow

sum of array values in php using array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related