PHP read CSV & ignore certain columns

Question

I have a simple PHP script that reads a CSV file and generates an array from this:

<?php
$file = fopen('food.csv', 'r');
$allfile = [];
$idsColumnsWanted = array(0,1,16);
while (($line = fgetcsv($file)) !== FALSE) {

  $i = 0;

  foreach ($line as $i => $cell) {
      if (!in_array($i, $idsColumnsWanted)) {
          continue;
      }
      $allfile[] = $line;
      $i++;
  }

}
fclose($file);
?>

I'd like to display just the data in columns 0, 1 & 16.

I have made an attempt above, but it still outputs the entire CSV.

well, i think you want to check on key instead of value, in_array() checks for the value, array_key_exists() checks for the key — user1897253
– user1897253, Commented Oct 11, 2016 at 13:28

Casimir et Hippolyte · Accepted Answer · 2016-10-11 13:52:18Z

2

You can do it with array_intersect_key:

$file = fopen('food.csv', 'r');
$allfile = [];

$idsColumnsWanted = array_flip([0, 1, 16]);

while (false !== $fields = fgetcsv($file)) {
    $allfile[] = array_intersect_key($fields, $idsColumnsWanted);
}

fclose($file);

Note: if you don't want to preserve the column numbers as keys in your result array, use array_values(array_intersect_key(...)).

edited Oct 11, 2016 at 13:52

answered Oct 11, 2016 at 13:37

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

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

5 Comments

michaelmcgurk Over a year ago

When I run this, my array is populated with null items. How do I resolve?

Casimir et Hippolyte Over a year ago

@michaelmcgurk: really? I will make some tests.

Casimir et Hippolyte Over a year ago

@michaelmcgurk: the "s" was missing in "$idsColumnsWanted"

michaelmcgurk Over a year ago

Many thanks, @Casimir - that worked perfectly :-) I just need to now figure out how to change the numbers 0, 1, 16 to text values :-)

dimButTries Over a year ago

This is fantastic and works first time @CasimiretHippolyte

Collectives™ on Stack Overflow

PHP read CSV & ignore certain columns

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related