Using PHP how to convert csv file

Question

i have a csv file where the header line is in row 1 not row 0 how can i convert a csv in this situation. I have seen good versions of converting a csv file where the header row is at row[0] as

function csv_to_array($filename='', $delimiter=',')
{
if(!file_exists($filename) || !is_readable($filename))
    return FALSE;

$header = NULL;
$data = array();
if (($handle = fopen($filename, 'r')) !== FALSE)
{
    while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE)
    {
        if(!$header)
            $header = $row;
        else
            $data[] = array_combine($header, $row);
    }
    fclose($handle);
}
return $data;
}

please can someone assist me in the situation where row[1] is the header row.

Sharry India · Accepted Answer · 2014-11-24 12:14:05Z

You can do like this :

            function csv_to_array($filename='', $delimiter=',')
            {
            if(!file_exists($filename) || !is_readable($filename))
                return FALSE;

            $header = NULL;
            $data = array();
            if (($handle = fopen($filename, 'r')) !== FALSE)
            {
                $i=0;
                while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE)
                {
                    if($i==0)
                    {
                      $i++;
                      continue;   //SKIP FIRST ROW
                    }
                    if(!$header)
                        $header = $row;
                    else
                        $data[] = array_combine($header, $row);
                }
                fclose($handle);
            }
            return $data;
            }

MrCarrot · Accepted Answer · 2014-11-24 13:20:16Z

1

Out of interest, if the headers are on row 1, what is on row 0? Is it blank?

In any case:

$i = 0;
while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) {
    $i++;
    if ($i == 1) {
        continue; // Or do something else?
    } elseif ($i == 2) {
        $header = $row; // Get the headers on row 1
    } else {
        $data[] = $row; // Get the data on row 2 and above
    }
}

Alternatively:

while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) {
    $data[] = $row;
}

var_dump($data[1]); // This is the header

for ($i = 2, $j = count($data); $i < $j; $i++) {
    var_dump($data[ $i ]); // Each row of data
}

edited Nov 24, 2014 at 13:20

answered Nov 24, 2014 at 12:04

MrCarrot

2,8182 gold badges28 silver badges34 bronze badges

1 Comment

Sharry India Over a year ago

use $i++ before continue otherwise $i will always be equal to 0.

Att3t · Accepted Answer · 2014-11-24 12:01:33Z

0

you can use fgetcsv and store results into an array like this

$file = fopen("path/to/csv","r");
$list=array();

//saving in list 
while ($row=fgetcsv($file)) {
  $list[]=$row;
}

then you can run a for loop starting $i = 2

answered Nov 24, 2014 at 12:01

Att3t

4662 silver badges8 bronze badges

Collectives™ on Stack Overflow

Using PHP how to convert csv file

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related