fgetcsv and array work

Cerulean

Hi,

I've been trying to work with a CSV, and so far I'm doing an okay job of it. The CSV has seven variables per line, and I'm using a FOREACH to iterate over it. The problem is, i find that each output repeats seven times. I'll give you an example:

<?php

$filename = "mod.csv";
$id = fopen($filename, "r");

while ($data = fgetcsv($id, filesize($filename),","))

foreach ($data as $row) {
echo "$data[0],$data[1],$data[2]\n";

}
?>

This code gives me data[0], data[1] and data[3] each seven times, then moves to the next "record" in the csv. How can I circumvent this?

Thanks so much!

-Marty

yelvington

foreach() iterates across an array. For each pass, it assigns the found value to a variable. You're not using that variable. Why not? Perhaps you mean

<?php
$filename = "mod.csv";
$id = fopen($filename, "r");
while ($data = fgetcsv($id, filesize($filename),",")){
        foreach ($data as $row)
                echo "$row";
        echo "\n";
        } 
?>

Or, using your original model of referencing the $data array directly, you don't need the foreach.

<?php
$filename = "mod.csv";
$id = fopen($filename, "r");

while ($data = fgetcsv($id, filesize($filename),","))
        echo "$data[0],$data[1],$data[2]\n";

?>

Cerulean

Woo! The bottom one is just exactly what I needed. I had tried using $row, but for some reason i was only getting the first character of each value. Anyway,that's why I posted in the "Newbie" forum 🙂

The bottom example worked. I'm thrilled, thank you.

-Marty