How to skip first row and read upto five rows from csv in PHP

Question

Hello,

I have following code in which I want to skip first row in csv that is headers of columns and read upto five rows of csv file.

Current code skip first row but display all records.

How can I achieve this ?

<?php 
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
set_time_limit(0);

define('CSV_PATH', '/var/www/Products_upload_12499/'); // specify CSV file path

$csv_file = CSV_PATH . "skipfirstrow.csv"; // Name of your CSV file
$csvfile  = fopen($csv_file, 'r');

$counter = 1;
while ($data = fgetcsv($csvfile)) 
{
    if($counter==1) {
            $counter++;
            continue;
            }       }
    $days = trim($data[0]);
    echo "==>> " . $days."\n";
        if ($counter >= 6) {
        exit();
    }

}

?>

Use [PHPExcel](https://github.com/PHPOffice/PHPExcel) library — narasimharaosp, May 24 '16 at 04:26
I work on Ubuntu so I dont think so Excel works in Ubuntu. Therefore I am using csv files — Nikita, May 24 '16 at 04:29

Webeng · Answer 1 · 2016-05-24T04:37:16.967

You can create an if else conditional that only outputs the rows you want, and that breaks the while loop when you got all the rows you wanted:

$row = 0;
while ($data = fgetcsv($csvfile)) 
{
    $row++;//starts off with $row = 1
    if (($row>1)&&($row<6))//rows 2,3,4,5
    {
        foreach ($data as $cell)
        {
           echo "|  {$cell}  |";
        }
        echo "<br>";
    }
    else if ($row>=6)
    {
        break;
    }
}

You can replace the echo "| {$cell} |"; code with whatever you like the code to output.

Let me know if this worked for you.

score 0 · Answer 2 · edited May 24 '16 at 05:29

0

just skip first line by not equal assign != ,let me know is it work

$counter = 1;
while ($data = fgetcsv($csvfile)) 
{
    if($counter !=1) {
      $days = trim($data[0]);
      echo "==>> " . $days."\n";
      if($counter >= 6)
        break;
    }
    $counter++;
}

edited May 24 '16 at 05:29

vp_arth

14,461
4
37
66

answered May 24 '16 at 04:34

Jack jdeoel

4,554
5
26
52

1

oh yes Thanks @vp_art – Jack jdeoel May 24 '16 at 04:37
Nice catch, @Nikita :) But unbalanced `{}` here now. – vp_arth May 24 '16 at 05:28
No its not unbalanced .. All `{}` are properly closed – Nikita May 24 '16 at 08:09
@Nikita, I fix that. see [edit history](https://stackoverflow.com/posts/37404454/revisions) – vp_arth May 24 '16 at 14:06

score 0 · Answer 3 · answered May 24 '16 at 04:53

Yet another code to achieve this.
fgets used to skip lines to avoid excess csv parsing.

if (($f = fopen('test.csv', 'r')) === false)
  throw new Exception('File not found');

$skip = 1;
$length = 5;

for ($i = 1; $i < $skip; $i++) fgets($f); // skip first $skip lines
for ($i = $skip; $i < $skip + $length; $i++) {
  $row = fgetcsv($f);
  echo implode(', ', $row)."<br/>\n";
}

How to skip first row and read upto five rows from csv in PHP

3 Answers3