CSV to php associative array

Question

My CSV file has this structure

title;firstName;lastName;email;
Sir;Bob;Public;[email protected];

The first row shows the column names. Content starts with the second row. Now I want this to put into an associative array like this

array([0] => 
            array(
                   'title' => 'Sir', 
                   'firstName' => 'Bob', 
                   'lastName' => 'Public', 
                   'email' => '[email protected]'
            ) 
)

What I tried:

    $entities = array();

    while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {

        $num = count($data);

        for ($c = 0; $c < $num; $c++) {

              $line = array();
               //save first row
               if ($row == 1) {
                  foreach (explode(';', $data[$c]) as $field) {
                      //dont save empty fields
                      if ($field != "") {
                         $fields[] = $field;
                         $line[$field] = array();
                      }
                   }
               }
               //go through contents and save them
               foreach ($fields as $field) {
                   for ($i = 2; $i < count($fields); $i++) {
                       $cust = explode(";", $data[$c]);
                       $line[$field][] = $cust[$i];
                   }
               }
               $entities[] = $line;
               $row++;
            }
        }

        fclose($handle);
    }

This gives no error but a strange array that seems to be messed up. Any ideas how I can get my desired structure?

You have a ; separated file yet you are specifying , as the separator. — Salman Arshad
– Salman Arshad, Commented Jan 8, 2013 at 12:55

Salman Arshad · Accepted Answer · 2013-01-08 13:21:36Z

4

This should work:

$entities = array();
$header = fgetcsv($handle, 0, ";"); // save the header
while (($values = fgetcsv($handle, 0, ";")) !== FALSE) {
    // array_combine
    // Creates an array by using one array for keys and another for its values
    $entities[] = array_combine($header, $values);    
}

edited Jan 8, 2013 at 13:21

answered Jan 8, 2013 at 13:00

Salman Arshad

273k85 gold badges450 silver badges540 bronze badges

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

3 Comments

DarkLeafyGreen Over a year ago

This does not work. Header is a large string, with all column titles seperated by a ','. It does not produce the structure from my question.

Salman Arshad Over a year ago

The CSV in your question used ;. Change the separator in my code to match the one used in CSV.

DarkLeafyGreen Over a year ago

THanks, this was the problem. Strange thing, but with ',' it works

Rajat Garg · Accepted Answer · 2013-01-08 13:23:07Z

$entities = array();
//Assuming you are able to get proper array from CSV
$data = array('title;firstName;lastName;email;', 'Sir;Bob;Public;[email protected];');
$num = count($data);

for ($c = 0; $c < $num; $c++) {

$line = array();
//save first row

foreach (explode(';', $data[$c]) as $field) {
    //dont save empty fields
    if ($c == 0) {
        if ($field != "") {
            $fields[] = $field;
            //$line[$field] = array();
        }
    } else {
        if ($field != "") {
            $line[$field] = $field;
        }
    }

}
if (count($line) > 0)
    $entities[] = $line;
}

Collectives™ on Stack Overflow

CSV to php associative array

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related