Php quick export csv format data program code

Csv file format

The code is as follows:	Copy code
$ Exportdata = 'rule 111, valid period '. "\ n ";

To output csv files in php, use the header to tell the browser format.

The code is as follows:	Copy code
Header ("Content-type: application/vnd. ms-excel "); Header ("Content-Disposition: attachment; filename = $ filename ");

Example

The code is as follows:

Copy code

$ Exportdata = 'rule 111, Rule 222, audit 222, Rule 222, server 2222, rule 1, rule 2, Rule 3, matching character, set time, valid time '. "\ n "; $ Date = date ("YmdHis "); If (! Empty ($ lists )){ Foreach ($ lists as $ key => $ value ){ $ Time = date ("Y-m-d_H: I: s", $ value ['add _ time']); $ Exportdata. = "\" \ t ". $ value ['rule_id']. "\", \ "\ t ". $ value ['rule_name']. "\", \ "\ t ". $ value ['matching _ level']. "\", \ "\ t ". "{$ value ['rule _ action']}". "\", \ "\ t ". $ value ['service _ type']. "\", \ "\ t ". $ value ['keyword1 ']. "\", \ "\ t ". $ value ['keyword2 ']. "\", \ "\ t ". $ value ['keyword3 ']. "\", \ "\ t ". $ value ['matching _ word']. "\", \ "\ t ". $ value ['set _ time']. "\", \ "\ t ". $ value ['validation _ time']. "\" \ n ";     } } $ Filename = "plcnetinfo_00000000date0000.csv "; Header ("Content-type: application/vnd. ms-excel "); Header ("Content-Disposition: attachment; filename = $ filename "); Header ("Expires: 0 "); Header ("Pragma: public "); Header ("Cache-Control: must-revalidate, post-check = 0, pre-check = 0 "); Header ("Cache-Control: public ");       Echo (mb_convert_encoding ($ exportdata, "gb2312", "UTF-8 "));

The following is an example of importing csv data from php + mysql:

The code is as follows:

Copy code

<? Php Export_csv (); Function export_csv (){ $ Filename = date ('ymdhis '). ". csv"; // file name Header ("Content-type: text/csv "); Header ("Content-Disposition: attachment; filename =". $ filename ); Header ('cache-Control: must-revalidate, post-check = 0, pre-check = 0 '); Header ('expires: 0 '); Header ('pragma: public '); Echo array_to_string (get_export_data ()); } Function array_to_string ($ result ){ If (empty ($ result )){ Return I ("no data that meets your requirements! __^ "); } $ Data = 'Book ID, title '. "\ n"; // topic name $ Size_result = sizeof ($ result ); For ($ I = 0; $ I <$ size_result; $ I ++ ){ $ Data. = I ($ result [$ I] ['name']). ','. I ($ result [$ I] ['option']). "\ n "; } Return $ data; } Function get_export_data (){ $ Link = mysql_connect ('localhost', 'root', '121051xz ') or die (mysql_error ()); Mysql_select_db ('ht '); Mysql_query ("set names 'utf8'"); // defines the encoding. $ SQL = 'select * from booklist '; $ Result = mysql_query ($ SQL ); $ Rowaa = mysql_fetch_array ($ result ); $ Res = array (); $ I = 0; While ($ row = mysql_fetch_array ($ result )){ $ Res [$ I] ['name'] = $ row ['bookid']; $ Res [$ I] ['option'] = $ row ['bookname']; $ I ++; } Return $ res; } Function I ($ strInput ){ Return iconv ('utf-8', 'gb2312', $ strInput); // This parameter is used when the page encoding is UTF-8. Otherwise, the exported Chinese characters are garbled. }