PHP convert CSV to specific JSON format

Question

I have a CSV file that looks like:

Name, Id, Address, Place,
John, 12, "12 mark street", "New York",
Jane, 11, "11 bark street", "New York"...

I have about 500 coloumns. I would like to convert this to JSON, but I want the output to look like:

{
    "name": [
        "John",
        "Jane"
    ],
    "Id": [
        12,
        11
    ],
    "Address": [
        "12 mark street",
        "12 bark street"
    ],
    "Place": [
        "New York",
        "New York"
    ]
}

Using PHP, how can I iterate through the CSV file so that I can make each column in the first row an array that holds the values in the same column on all the other rows?

I would use file_get_contents to load the CSV, then explode(",", $csvfile) then manipulate the array until you get it to look like you want to and finally json_encode it. — SSH This
– SSH This, Commented Jun 13, 2013 at 20:36
Loop over list, append to groups $output["name"][] = $row[0];. Show your current attempt if you need further advise. — mario
– mario, Commented Jun 13, 2013 at 20:39

The Surrican · Accepted Answer · 2013-06-13 20:45:50Z

6

this would be a generic method which is valid for any amoutn of named colums. if they are static, it will be shorter to address them directly

<?
$result = array();
if (($handle = fopen("file.csv", "r")) !== FALSE) {
    $column_headers = fgetcsv($handle); // read the row.
    foreach($column_headers as $header) {
            $result[$header] = array();
    }

    while (($data = fgetcsv($handle)) !== FALSE) {
        $i = 0;
        foreach($result as &$column) {

                $column[] = $data[$i++];
        }

    }
    fclose($handle);
}
$json = json_encode($result);
echo $json;

answered Jun 13, 2013 at 20:45

The Surrican

30k24 gold badges127 silver badges168 bronze badges

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

Comments

dev-null-dweller · Accepted Answer · 2013-06-13 20:51:24Z

0

Compact solution:

<?php
$fp = fopen('file.csv', 'r');
$array = array_fill_keys(array_map('strtolower',fgetcsv($fp)), array());
while ($row = fgetcsv($fp)) {
    foreach ($array as &$a) {
        $a[] = array_shift($row);
    }
}
$json = json_encode($array);

answered Jun 13, 2013 at 20:51

dev-null-dweller

29.5k3 gold badges68 silver badges87 bronze badges

Comments

crowebird · Accepted Answer · 2013-06-13 20:56:05Z

There are a few helpful php functions that will do what you need.

Open fopen and parse with fgetcsv.

Once you have your array use *json_encode* to get it into JSON format.

Something like this might work (not tested):

$results = array();
$headers = array();

//some parts ripped from http://www.php.net/manual/en/function.fgetcsv.php
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    $line = 0;
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            for ($x=0; $x < count($data); $c++) {
                if ($line == 0) {
                    $headers[] = $data[$x];
                }
                $results[$x][] = $data[$x];
            }
    }
    fclose($handle);
}

$output = array();

$x = 0;
foreach($headers as $header) {
    $output[$header] = $results[$x++];
}

json_encode($output);

Collectives™ on Stack Overflow

PHP convert CSV to specific JSON format

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related