pearl/csv-json-converter

Convert CSV to JSON and JSON to CSV file format using PHP

, _(*1)

Convert CSV to JSON and JSON to CSV using PHP.

Installation

composer require pearl/csv-json-converter, _(*2)

## How to use?, _(*3)

### JSON to CSV: ##### Sample Json Data: php $jsonString = '[{ "name": "Half Girlfriend", "author": "Chetan Bhagat", "publisher": "Rupa Publications", "language": "en" }, { "name": "My Journey: Transforming Dreams into Actions", "author": "A.P.J. Abdul Kalam", "publisher": "Rupa Publications", "language": "en" }]';, _(*4)

use Pearl\CsvJsonConverter\Type\JsonToCsv;  

Data loading:

• Array or Json values are accepted.
• Custom output header optional available. This is optional parameter if not passed then default header will be considered.

$jsonToCsv = new JsonToCsv($jsonString, ['headers' => ["productName", "author", "publisher", "lang"]]);

Or load the json data from file., _(*5)

$jsonToCsv->load(__Dir__ . '/data/products.json');

Data conversion result options :

$jsonToCsv->convertAndSave(__Dir__ . '/output');


$jsonToCsv->convertAndDownload(__Dir__ . '/output');


$jsonToCsv->convert();

Output:

CSV to JSON:

use Pearl\CsvJsonConverter\Type\CsvToJson;

Load the CSV data., _(*6)

$csvToJson = new CsvToJson($csvString, ['bitmask' => 'JSON_PRETTY_PRINT|JSON_UNESCAPED_UNICODE|JSON_UNESCAPED_SLASHES']);

Or Load the csv data from file., _(*7)

$csvToJson->load(__Dir__ . '/data/products.csv');

Data conversion result options :

$csvToJson->convertAndSave(__Dir__ . '/output');


$csvToJson->convertAndDownload(__Dir__ . '/output');


$csvToJson->convert();

Sample Csv:

Output:

  [{
        "name": "Half Girlfriend",
        "author": "Chetan Bhagat",
        "publisher": "Rupa Publications",
        "language": "en"
    },
    {
        "name": "My Journey: Transforming Dreams into Actions",
        "author": "A.P.J. Abdul Kalam",
        "publisher": "Rupa Publications",
        "language": "en"
    }
  ]