i want to calculate the summation of sal values as follow as an ex:

id             name          sal
1             ghada           4
2             ahmad           4

these data comes from csv file i did before,i wrote the code but something is wrong and this is the code:

PHP Code:

private function open(){
        $sum=0;
        $this->base.=$_REQUEST["item"];
        $file_handler=fopen($this->base, "r");
        while($row=fgetcsv($file_handler,1024,";")){
            
            $this->data[]=$row;
            
            for ($i = 1; $i <= 6; $i++) {
                
                $sum +=$this->data[$i][2];
            
                
                }
                
                
        }
        
        print_r($sum);
        
        
        $this->view="open.php";
    } 


but the result is 168 instead of 8

I don't really understand your code, it's kinda' messy, out of context and there's way to litle information given. My guess is that you don't want that for loop within the while loop, but rather outside.

Originally Posted by lizciz

I don't really understand your code, it's kinda' messy, out of context and there's way to litle information given. My guess is that you don't want that for loop within the while loop, but rather outside.

Or rather nowhere!

$row has your data, one row at a time, as print_r would show.

Hi jarabaaghada,

This is a simple code I used before which could be helpful to you. I modified it the way you can use, just change the variables that you need be changed, like the name of the file and I noticed you are using class, so just modify this the way you can access your variables.

PHP Code:


function open(){
    $sum=0;
    
    $file = "sample.csv";
    
    $filesize = filesize($file);
    
    $file_handler=fopen($file, "r");
    
    $sum = 0;
    
    while($row=fgetcsv($file_handler, $filesize, ",")){
            $sum += (int)$row[2];
    }
    
    echo $sum;
} 


You can test it locally by creating the sample csv file and calling the function I created.

Basically, you just have access the sal value by getting the value of index 2 of your $row since the $row already contains it, so you no more need to loop on it.

Hope this helps.

febrarian