Looping through a csv with fgetcsv

php csv fgetcsv
user3725781 picture user3725781 · Nov 11, 2014 · Viewed 30.1k times · Source

I have a csv file with 3 columns: email address, first name and last name. I have got the stage where I can print out the array using the following code:

<?php
$file = fopen("testEmails.csv","r");

while(! feof($file))
{
print_r(fgetcsv($file));
}

fclose($file);
?>

This prints the array, so every field in a row. What I want it to print is purely the values in the first column of the row. How would this be done, documentation on fgetcsv seems very sketchy to me (a relative beginner).

Thanks.

Answer

Cody Caughlan picture Cody Caughlan · Nov 11, 2014

The first example in the fgetcsv() documentation contains the nuggets of what you need.

$file = fopen("testEmails.csv","r");

while (($data = fgetcsv($file)) !== FALSE)
{
    echo "email address " . $data[0];
}

fgetcsv() returns a numerically indexed array of representing the columns, so you just want to print the first column.

Related questions

How to parse a CSV file using PHP

Suppose I have a .csv file with the following content: "text, with commas","another text",123,"text",5; "some without commas","another text",123,"text"; "some text with commas or no",,123,"text"; How can I parse the content through PHP?

Read More
UTF-8 problems while reading CSV file with fgetcsv

I try to read a CSV and echo the content. But the content displays the characters wrong. Mäx Müstermänn -> Mäx Müstermänn Encoding of the CSV file is UTF-8 without BOM (checked with …

Read More
PHP dynamically create CSV: Skip the first line of a CSV file

I am trying to import a CSV file. Due to the program we use, the first row is basically all headers that I would like to skip since I've already put my own headers in via HTML. How can I …

Read More