parse CSV file in PHP by column

Question

I want to open CSV (comma separated value) file in PHP by column, i want to take all datas from 3 columns. I tried with this code, but this only shows me data by row:

  $row = 1;
    if (($handle = fopen("ut.csv", "r")) !== FALSE) {
      while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
      }
      fclose($handle);
    }

How i can take all datas from one column ?

EXAMPLE: This i my file in Excel, which is exported to SCV: http://prntscr.com/mzcfcw

I want to take in php values from colum Name and Price and find duplicate values in column Name, compare their prices.

Can you show a sample input (a few rows) and the output you want from that? — Nigel Ren
– Nigel Ren, Commented Mar 18, 2019 at 7:44
You should have a look at array_count_values : php.net/manual/en/function.array-count-values.php — Sindhara
– Sindhara, Commented Mar 18, 2019 at 7:49
@kuh-chan problem is how i can take values from excel by column — user11083048
– user11083048, Commented Mar 18, 2019 at 7:51
It's not an excel file. It's a CSV (comma separated value) file. — yunzen
– yunzen, Commented Mar 18, 2019 at 7:52

matwr · Accepted Answer · 2019-03-18 08:07:55Z

2

fgetcsv parses the given handle line by line (rows). It isn't possible to parse a csv file by column using core php. However, if you know the position of the 3 columns for which you wish to access the values, you could simply ignore all other columns:

 //position (zero indexed) of required columns
 $columnsToProcess=[0,3,4]
 for ($c=0; $c < $num; $c++) {
 //do something with value if column's index is in the required columns array 
            if(in_array($c,$columnsToProcess)){
                //value at position $c equals $data[$c]
                echo $data[$c] . "<br />\n";
             }          
        }

Moe info about fgetcsv : http://php.net/manual/en/function.fgetcsv.php

answered Mar 18, 2019 at 8:07

matwr

1,5811 gold badge13 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

parse CSV file in PHP by column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related