How to import JSON data into CSV file with PHP and MySQL?

How to import JSON data into CSV file with PHP and MySQL?

During the development process, we often encounter situations where we need to convert data from one format to another. For example, sometimes we need to import JSON data into a CSV file. This article will introduce how to import JSON data into a CSV file using PHP and MySQL.

First, we need to prepare a JSON data file. Suppose we have a file named "data.json" which contains the following JSON data:

[
   {
      "id": 1,
      "name": "John",
      "age": 25
   },
   {
      "id": 2,
      "name": "Jane",
      "age": 30
   },
   {
      "id": 3,
      "name": "Mike",
      "age": 35
   }
]

Next, we need to write PHP code to import the JSON data and convert it to CSV format. We can use PHP's built-in json_decode() function to decode JSON data into a PHP array. We will then use the fputcsv() function to write the data to the CSV file.

Below is the complete PHP code example:

<?php
// 读取JSON文件内容
$jsonData = file_get_contents('data.json');

// 解码JSON数据为PHP数组
$data = json_decode($jsonData, true);

// 创建一个新的CSV文件并打开写入模式
$csvFile = fopen('output.csv', 'w');

// 写入CSV文件的表头
fputcsv($csvFile, array('ID', 'Name', 'Age'));

// 遍历数据数组并将数据写入CSV文件
foreach($data as $row) {
   fputcsv($csvFile, $row);
}

// 关闭CSV文件
fclose($csvFile);

echo 'CSV文件已成功生成!';
?>

In the above example, we first read the contents of the JSON file using the file_get_contents() function and use json_decode() Function decodes it into a PHP array. Then, we create a new CSV file and turn on write mode. We use the fputcsv() function to write the header of the CSV file to the file, and then use foreach to loop through the data array and write each row of data to the CSV file. Finally, we close the CSV file.

To run the above code, you need to create a file named "data.json" in the same directory as the PHP file and copy the above given JSON data into the file. Then, run the PHP file and it will generate a CSV file named "output.csv".

Summary:

This article introduces how to use PHP and MySQL to import JSON data into a CSV file. We can easily achieve this conversion by using the json_decode() function to decode the JSON data into a PHP array and the fputcsv() function to write the data to a CSV file. This is a very useful technique that can help us with data format conversion during the development process. Hope this article helps you!

The above is the detailed content of How to import JSON data into CSV file with PHP and MySQL?. For more information, please follow other related articles on the PHP Chinese website!