[SOLVED] Read CSV File

[timmah1]

How can I have PHP read a csv file, and show just the data?

 

I have been looking around, but everything just reads the Heading and shows that in an array.

 

What I'm trying to do is read the csv file from exporting contacts from Outlook.

 

Thanks in advance.

[DarkWater]

<?php
$file = "contacts.csv";
$contents = file_get_contents($file);
$rows = explode('\n', $contents);
foreach ($rows as $k=>$v) {
       if ($k == 0) { continue; } //header row, don't need it.
       $data = explode(',', $v);
       print_r($data);
}
?>

 

Just an example to get you started.

[timmah1]

Shows absolutely nothing when using that

[DarkWater]

Can I see what the CSV looks like (like how it's formatted)?  I don't use Outlook so I don't know how it exports contacts.

[thebadbad]

"\n" instead of '\n' on line 4, so it's treated like a new line.

 

..

 

But yeah, I don't happen to have Outlook either, so an example of the CSV could be helpful.

[DarkWater]

Oh yeah, sorry about that.  Forgot to press Shift and then missed it when I looked it over. >_<  Good catch.

[timmah1]

ok, that fixed the problem.

 

Now, how do I get it to not show as arrary's?

 

Just 3 headings, First Name, Last Name, E-mail Address

 

So that it would like this:

test test [email protected]

 

right now, it look like this

Array ( [0] => test [1] => test [2] => [email protected] )

[thebadbad]

Simple. Instead of print_r()'ing it, echo the implode()'d array:

 

<?php
$file = "contacts.csv";
$contents = file_get_contents($file);
$rows = explode("\n", $contents);
foreach ($rows as $k=>$v) {
       if ($k == 0) { continue; } //header row, don't need it.
       $data = explode(',', $v);
       echo implode(' ', $data), '<br />';
}
?>

 

Or you could simply replace the commas with spaces, inside the foreach loop.

[timmah1]

Perfect!!

 

Thank you very much