Home  >  Article  >  Backend Development  >  How to convert csv file content into array in php

How to convert csv file content into array in php

藏色散人
藏色散人Original
2021-10-14 09:07:292164browse

php method to convert the content of a csv file into an array: 1. Create a new PHP file; 2. Create a new EXCEL document and save it as a CSV file; 3. Store the csv file path in a variable; 4. Use The while loop converts the contents of the csv file into an array.

How to convert csv file content into array in php

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

php converts the contents of the csv file into an array :

Create a new PHP file and name it text.php.

How to convert csv file content into array in php

The encoding of the definition file is UTF8 to prevent Chinese garbled characters when printing the array.

How to convert csv file content into array in php

Create a new EXCEL document, write the content in it, and save it as a CSV file, named test.csv, the storage path of the file is the same as text The .php file path is in the same directory.

How to convert csv file content into array in php

In the text.php file, write the code. Store the path of the file test.csv in the $filepath variable, and use the fopen() function to open the file. The code is as follows:

How to convert csv file content into array in php

Use the while loop in PHP and use fgetcsv() The function stores the content of each line of the test.csv file in the $data array. The code is as follows:

How to convert csv file content into array in php

In order to prevent garbled characters during the conversion process, the following code needs to be added to convert It is UTF8 encoding format. Then close the file and use print_r() to print the $data variable to see if the conversion is successful.

How to convert csv file content into array in php

Run the code and the output result is as follows (successfully converted to an array):

How to convert csv file content into array in php

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to convert csv file content into array in php. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn