create each csv row to json file in php

Question

i found this code for csv row as a object

$fp = fopen('test.csv','r') or die("**! can't open file\n\n");
$i = 0;
while($csv_line = fgetcsv($fp,1024)) {
    $i++;
    $json['json_'.$i]['id'] = $csv_line[0];
    $json['json_'.$i]['product_id'] = $csv_line[1];
    $json['json_'.$i]['title'] = $csv_line[2];
    $json['json_'.$i]['outline'] = $csv_line[3];        
}
$json['total_lines'] = $i;
print json_encode($json);
fclose($fp) or die("**! can't close file\n\n");

how to create each csv row as a separate json file in php

Please go read How to Ask. We expect you to make a reasonable effort upfront here - not just to ask “how to”. Show us what you tried please. — 04FS
– 04FS, Commented Nov 4, 2019 at 14:25

u_mulder · Accepted Answer · 2019-11-04 14:27:06Z

1

Soultion simplified:

while($csv_line = fgetcsv($fp,1024)) {
    $json = [
        'id' => $csv_line[0],
        'product_id' => $csv_line[1],
        'title' => $csv_line[2],
        'outline' =>  $csv_line[3],
    ];
    // use any other naming approach that you want
    file_put_contents('file_' . $csv_line[0] . '.json', json_encode($json));
}

answered Nov 4, 2019 at 14:27

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

create each csv row to json file in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related