Home >Backend Development >PHP Problem >How to convert csv file content into array in php
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.
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.
The encoding of the definition file is UTF8 to prevent Chinese garbled characters when printing the array.
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.
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:
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:
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.
Run the code and the output result is as follows (successfully converted to an array):
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!