简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

Open CSV file with PHP

WBOY
Release： 2016-07-25 09:02:12
Original
1009 people have browsed it
Open CSV file with PHP
  1. //Set UTF-8 encoding
  2. setlocale(LC_ALL, 'en_US.UTF-8');
  3. //csv path
  4. $csv_file = "csv/excel.csv";
  5. //Open in read-only mode File
  6. $handle = fopen($csv_file, "r");
  7. //Define the result array
  8. $listarr = array();
  9. //Open a row in csv and split it into an array with ","
  10. while($data = fgetcsv($handle, 1000, ",")){
  11. $num = count($data);
  12. for($i=0; $i<$num; $i++){
  13. $data[$i] = mb_convert_encoding ($data[$i],"UTF-8","UTF-8");
  14. }
  15. $listarr[] = $data;
  16. }
  18. return $listarr;
Copy code


Related labels：
PHP打开CSV文件
source：php.cn
Previous article：PHP imitates GD to generate BMP pictures Next article：Output the IP address in the form of 192.168.*.*
Statement of this Website
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
Latest Articles by Author
Latest Issues
Even after clearing, the value of my file input remains As you can see in the screenshot. I select a file, keep the popup without refreshing the p...
From 2024-04-06 15:44:52
0
1
384
Tried everything but still the HTML content is not showing Basically, the content of the html document won't display anything on the browser. This HT...
From 2024-04-04 19:16:15
0
1
3496
Retrieve payment method history for WooCommerce customers I found a script that helps me get the information I need: the payment methods a customer ...
From 2024-04-04 14:57:11
0
1
428
Is there any way to recover my PHP files? I'm using VisualStudioCode for coding but my PHP file is now corrupted and 70% of the code...
From 2024-04-03 11:28:59
0
1
291
My WPF application won't start on another PC, but the application without MySql does, what could be the problem? This is my first time using a database. I've created an application using XAMPP via mySqll...
From 2024-04-03 11:16:00
0
1
396
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！