PHP echo issue while in a while loop

Question

I read in a csv file by using a while loop:

while (($data = fgetcsv($handle, null, ",")) !== FALSE)

and i want to skip the first row because this is the title row and i want to display on the screen "first line skipped".

if($data[0]=="title")
echo "Title row..skipping<br />";  
else
//do stuff

The problem is since its in a while loop it prints out "Title row...skipping" a bunch of times shown here:

Checking row 0...
Title row..skipping
Title row..skipping
Title row..skipping
Title row..skipping
Title row..skipping
Title row..skipping
Title row..skipping
Checking row 1...

what should i do so it only prints it out once? does it have something to do with php's output buffering?

Your output looks really odd. Are you sure your csv file is formatted correctly? — Ben
– Ben, Commented Jul 5, 2010 at 5:34
Post more code. Your problem isn't in the part that we can see. — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Jul 5, 2010 at 5:44

Felix Kling · Accepted Answer · 2010-07-05 05:46:52Z

1

Or call fgetcsv($handle, null, ",") once without assignment, to move the handler forward by one line:

fgetcsv($handle, null, ",");

while (($data = fgetcsv($handle, null, ",")) !== FALSE) {
    // do stuff
}

answered Jul 5, 2010 at 5:46

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

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

Comments

Ast Derek · Accepted Answer · 2010-07-05 05:34:30Z

0

if($data[0]=="title") {
  if (!$skipped) {
    echo "Title row..skipping<br />";
    $skipped = true;
  }
}
else
//do stuff

answered Jul 5, 2010 at 5:34

Ast Derek

2,7291 gold badge20 silver badges29 bronze badges

1 Comment

Ian McCullough Over a year ago

clever ;) i should have thought of that

Poni · Accepted Answer · 2010-07-05 05:48:13Z

0

If you know for a certain that you only need to skip the first line then;

if(!$skipped)
{
    echo "Title row..skipping<br />";
    $skipped = true;
}
else
//do stuff

answered Jul 5, 2010 at 5:48

Poni

11.4k28 gold badges83 silver badges126 bronze badges

1 Comment

Poni Over a year ago

Note: Aspired from Ast's answer ;P

Klinky · Accepted Answer · 2010-07-05 06:33:47Z

0

I think it'd be more elegant to use foreach:

foreach data as item {
  if (item == "title") {
   echo "Skipping title<br/>";
  }
}

How you have it now, you are checking if (data[0] == "title") every time you loop. data[0] will always equal "title", so it will always evaluate to true. You could increment an $index variable and do something like if (data[$index] == $title) then $index++ near the bottom of the loop, but why do that when foreach will essentially do that for you.

answered Jul 5, 2010 at 6:33

Klinky

2,09215 silver badges12 bronze badges

Collectives™ on Stack Overflow

PHP echo issue while in a while loop

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related