PHP: how do I get values of csv based on specified column?

Question

For example I wanted to do something like

php sample.php [csv file] [column name]

it should display all data based on the specified column name. My code below just gets the first column but I wanted it to be a variable based on column name

CURRENT CODE

function getCSV($csv){
    $file = fopen($csv, 'r');
    while (!feof($file) ) {
        $lines[] = fgetcsv($file, 1024);
    }
    fclose($file);
    return $lines;
}

$csv = getCSV($argv[1]);
foreach ($csv as $values) {
    $row1[] = $values[0];
}
print_r($row1);

SAMPLE CSV

ID,Name
1,Amy
2,Ana 
3,Ava

EXPECTED OUTPUT

php sample.php sample.csv ID
1
2
3

php sample.php sample.csv Name
Amy
Ana
Ava

How do I do this?

explode can be tricky if you're relying on consistent delimiters, and it'll fail on delimiters embedded in values. — Jake Bathman
– Jake Bathman, Commented Aug 27, 2015 at 15:38
Try to print_r($csv); after you set $csv from the getCSV() function. See what it looks like at that point, and that might help you loop over it. — Jake Bathman
– Jake Bathman, Commented Aug 27, 2015 at 15:40

David Alrdrin · Accepted Answer · 2015-08-27 15:51:39Z

1

thanks for all your help, eventually got it.

function getColumn($csv, $column){
    $header = array_shift($csv);
    $col = array_search($column, $header); 
    foreach ($csv as $row) {      
        $array[] = $row[$col]; 
    }
    return $array;
}

answered Aug 27, 2015 at 15:51

David Alrdrin

4711 gold badge6 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

PHP: how do I get values of csv based on specified 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