How to solve the problem of php fputcsv garbled code

This article introduces the relevant knowledge of "how to solve the problem of php fputcsv garbled". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

This article operating environment: Windows7 system, PHP7.1 version, DELL G3 computer

How to solve the php fputcsv garbled problem?

PHP uses fputcsv () to generate csv files to open garbled problems under windows Excel to solve csv files open normally under windows wps and my ubuntu16 desktop version.

But use windows Excel to open the garbled code.

Resolve:

Function test () {$fileName = 'demo'; / / several header functions need to be put before fopen. Otherwise, the output will be printed directly on the browser page. Instead of file download header ('Content-Type: application/vnd.ms-excel'); header (' Content-Disposition: attachment;filename= "'. $fileName.'.csv'); header ('Cache-Control: max-age=0'); / / output directly to the browser $fp = fopen (' php://output', 'a'); / / add bom at the beginning of the first string written. $bom = chr (0xEF) .chr (0xBB) .chr (0xBF); $column = [$bom.' Name', 'gender', 'age']; $data = ['Zhang San', 'man','21']; fputcsv ($fp, $column); fputcsv ($fp, $data); fclose ($fp);} "how to solve the problem of php fputcsv garbled". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!