+- Sick Gaming (https://www.sickgaming.net)
+-- Forum: Programming (https://www.sickgaming.net/forum-76.html)
+--- Forum: PHP Development (https://www.sickgaming.net/forum-82.html)
+--- Thread: [Tut] Convert PHP JSON to CSV (/thread-100844.html)
[Tut] Convert PHP JSON to CSV - xSicKxBot - 03-08-2023
Convert PHP JSON to CSV
<div style="margin: 5px 5% 10px 5%;"><img src="https://www.sickgaming.net/blog/wp-content/uploads/2023/03/convert-php-json-to-csv.jpg" width="550" height="413" title="" alt="" /></div><div><div class="modified-on" readability="7.0697674418605"> by <a href="https://phppot.com/about/">Vincy</a>. Last modified on March 7th, 2023.</div>
<p>This tutorial gives examples for converting a PHP JSON variable content into a CSV file.</p>
<p>This quick example achieves it in a few steps. It uses the PHP fputcsv() method to prepare the CSV output.</p>
<ol>
<li>It reads the input JSON and decodes it into an array.</li>
<li>Iterate the JSON array to read the line of the record.</li>
<li>Apply PHP fputcsv() to write the array keys in the header, followed by array values.</li>
</ol>
<h2>Quick example</h2>
<div class="post-section-highlight" readability="41">
<pre class="prettyprint"><code class="language-php"><?php function convertJsonToCSV($jsonFile, $csvFile)
{ if (($json = file_get_contents($jsonFile)) == false) { die('Unable to read JSON file.'); } $jsonString = json_decode($json, true); $fp = fopen($csvFile, 'w'); fputcsv($fp, array_keys($jsonString[0])); for ($i = 0; $i < count($jsonString); $i ++) { fputcsv($fp, array_values($jsonString[$i])); } fclose($fp); return;
}
$jsonFile = 'animals.json';
$csvFile = 'animals.csv'; convertJsonToCSV($jsonFile, $csvFile);
echo 'JSON to CSV converted. <a href="' . $csvFile . '" target="_blank">Download CSV file</a>';
</code></pre>
</div>
<p>The input JSON file is in the local drive and specified to a PHP variable $jsonFile.</p>
<p>This example creates a custom function convertJsonToCSV(). It requires the input JSON and the target CSV file names.</p>
<p>It converts the input JSON object to a PHP array. Then, it iterates the <a href="https://phppot.com/php/power-of-php-arrays/">PHP array</a> to read the row.</p>
<p>This function uses the PHP fputcsv() function to write each row into the target CSV file.</p>
<p><strong>Output:</strong></p>
<p>The above program will return the following CSV content in a file. In a previous tutorial, we have seen <a href="https://phppot.com/php/php-csv-file-export-using-fputcsv/">how to export to a CSV file using the PHP fputcsv() function</a>.</p>
<pre class="prettyprint"><code>Id,Name,Type,Role
1,Lion,Wild,"Lazy Boss"
2,Tiger,Wild,CEO
3,Jaguar,Wild,Developer
</code></pre>
<p>Note: The input JSON must be a one-dimensional associative array to get a better output.</p>
<p><img loading="lazy" class="alignnone size-large wp-image-20354" src="https://phppot.com/wp-content/uploads/2023/01/php-json-to-csv-550x413.jpg" alt="php json to csv" width="550" height="413" srcset="https://phppot.com/wp-content/uploads/2023/01/php-json-to-csv-550x413.jpg 550w, https://phppot.com/wp-content/uploads/2023/01/php-json-to-csv-300x225.jpg 300w, https://phppot.com/wp-content/uploads/2023/01/php-json-to-csv-768x576.jpg 768w, https://phppot.com/wp-content/uploads/2023/01/php-json-to-csv.jpg 960w" sizes="(max-width: 550px) 100vw, 550px"></p>
<h2>JSON string to CSV in PHP</h2>
<p>This example has a different approach to dealing with PHP JSON to CSV conversion.</p>
<p>It uses a JSON string as its input instead of reading a file. The JSON string input is initiated in a PHP variable and passed to the <em>convertJSONtoCSV()</em> function.</p>
<p>It reads the JSON string and converts it into a JSON array to prepare CSV. The linked article has an example of <a href="https://phppot.com/php/php-csv-file-read/">reading CSV using PHP</a>.</p>
<p>Then, it iterates the JSON array and applies PHP fputcsv() to write the CSV row.</p>
<p>It reads the array_keys to supply the CSV header. And this will be executed only for the first time. It writes the column names as the first row of the output CSV.</p>
<p class="code-heading">json-string-to-csv.php</p>
<pre class="prettyprint"><code class="language-php"><?php
function convertJsonToCSV($jsonString, $csvFile)
{ $jsonArray = json_decode($jsonString, true); $fp = fopen($csvFile, 'w'); $header = false; foreach ($jsonArray as $line) { if (empty($header)) { $header = array_keys($line); fputcsv($fp, $header); $header = array_flip($header); } fputcsv($fp, array_merge($header, $line)); } fclose($fp); return;
}
$jsonString = '[ { "Id": "1", "Name": "Lion", "Type": "Wild", "Role": "Lazy Boss" }, { "Id": "2", "Name": "Tiger", "Type": "Wild", "Role": "CEO" }, { "Id": "3", "Name": "Jaguar", "Type": "Wild", "Role": "Developer" }
]';
$csvFile = 'animals.csv'; convertJsonToCSV($jsonString, $csvFile);
echo 'JSON to CSV converted. <a href="' . $csvFile . '" target="_blank">Download CSV file</a>';
</code></pre>
<h2>Upload CSV file to convert into JSON in PHP</h2>
<p>This example is to perform the JSON to CSV with a file upload option.</p>
<p>This code will be helpful if you want to convert the uploaded JSON file into a CSV.</p>
<p>It shows an HTML form with a file input field. This field will accept only ‘.json’ files. The restriction is managed with the HTML ‘accept’ attribute. It can also be validated with a <a href="https://phppot.com/php/php-image-upload-with-size-type-dimension-validation/">server-side file validation script in PHP</a>.</p>
<p>The $_FILES[‘csv-file’][‘tmp_name’] contains the posted CSV file content. The JSON to CSV conversion script uses the uploaded file content.</p>
<p>Then, it parses the JSON and converts it into CSV. Once converted, the link will be shown to the browser to download the file.</p>
<p class="code-heading">upload-json-to-convert-to-csv.php</p>
<pre class="prettyprint"><code class="language-php-template"><?php
if (! empty($_FILES["csv-file"]["tmp_name"])) { $csvFile = 'animal.csv'; if (($json = file_get_contents($_FILES["csv-file"]["tmp_name"])) == false) { die('Unable to read JSON file.'); } $jsonString = json_decode($json, true); $fp = fopen($csvFile, 'w'); fputcsv($fp, array_keys($jsonString[0])); for ($i = 0; $i < count($jsonString); $i ++) { fputcsv($fp, array_values($jsonString[$i])); } fclose($fp); echo 'JSON to CSV converted. <a href="' . $csvFile . '" target="_blank">Download CSV file</a>';
}
?>
<HTML>
<head>
<title>Convert JSON to CSV</title>
<style>
body { font-family: arial;
} input[type="file"] { padding: 5px 10px; margin: 30px 0px; border: #666 1px solid; border-radius: 3px;
}
input[type="submit"] { padding: 8px 20px; border: #232323 1px solid; border-radius: 3px; background: #232323; color: #FFF;
}
</style>
</head> <body> <form method="post" enctype="multipart/form-data"> <input type="file" name="csv-file" accept=".json" /> <input type="submit" name="upload" value="Upload"> </form>
</body>
</HTML>
</code></pre>
<p><a class="download" href="https://phppot.com/downloads/php/php-json-to-csv.zip">Download</a></p>
<p> <!-- #comments --> </p>
<div class="related-articles">
<h2>Popular Articles</h2>
</p></div>
<p> <a href="https://phppot.com/php/convert-php-json-to-csv/#top" class="top">↑ Back to Top</a> </p>
</div>
https://www.sickgaming.net/blog/2023/03/07/convert-php-json-to-csv/