PHP Arrays: Extract from CSV

Question

Hi I'm using a simple import to CSV script that brings information into an array from a CSV file.

The sample output of the print_r($data) statement is:

Array ( [0] => Array ( [Email,Name,"Message Number","Date Added", ...etc ]) => email@email,com,myname,1001,"10/27/16 9:54pm EDT",... etc ) 1 => Array ( [Email,Name,"Message Number","Date Added",

print_r($data[0])

shows Array ( [Email,Name,"Message Number","Date Added",

I'm trying to isolate the variables but each time I get a null result on the quoted values.

$csv="members.csv";
$importer = new CsvImporter($csv,true);
$data = $importer->get();
echo "<pre>";
$n=0;

$messageNumber = $data[$n]['Message Number'];

What am I doing wrong? It should return '1001' in that variable.

Note: I'm using the class CsvImporter on this page in PhP FgetFSV

Again, what I'm looking for is the definition to isolate an individual variable in an easy way.

Thank you!

Perhaps someone has a simpler way to read a CSV into a PHP Array than using the above class?

Erh, looks like your extraction is wrong, that doesn't look like a proper array. — Epodax
– Epodax, Commented Oct 28, 2016 at 8:35
Could you show what print_r($data[0]) and print_r($data[1]) produces? — Rwd
– Rwd, Commented Oct 28, 2016 at 8:36
@Viktor noooo, not as a comment - edit your original post instead. — Franz Gleichmann
– Franz Gleichmann, Commented Oct 28, 2016 at 8:38
Show us the part of your code where you extract the data into the array. — Epodax
– Epodax, Commented Oct 28, 2016 at 8:41

Viktor · Accepted Answer · 2016-10-28 19:39:02Z

3

In the example given in the php docs for CsvImporter it's changing the default delimiter to \t. Try add ',' as the 3rd param for the class:

$importer = new CsvImporter($csv,true, ',');

Hope this helps!

edited Oct 28, 2016 at 19:39

Viktor

5477 silver badges25 bronze badges

answered Oct 28, 2016 at 8:55

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

Comments

Viktor · Accepted Answer · 2016-10-28 19:38:49Z

0

$csv="members.csv";
$importer = new CsvImporter($csv,true, ',');
$data = $importer->get();
echo "<pre>";
$n=0;
$messageNumber = $data[$n]['Message Number']; 
print $messageNumber;

Returns the correct '1001' as expected. The solution is marked above.Thanks to Ross. Simply changing the $importer = new CsvImporter($csv,true, ','); solved the entire puzzle.

answered Oct 28, 2016 at 19:38

Viktor

5477 silver badges25 bronze badges

Collectives™ on Stack Overflow

PHP Arrays: Extract from CSV

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related