PHP export CSV file, can export leading 0 instance code _php instance

Instance one: can export leading 0

Export CSV format file $data data $title _arr header $file _name filename function exportcsv ($data, $title _arr, $file _name= ') {ini_set ("Max_

  Execution_time "," 3600 ");
  $csv _data = ';

  /** Title */$nums = count ($title _arr); for ($i = 0; $i < $nums-1; + + $i) {$csv _data. = ' "'. $title _arr[$i].
  '",'; } if ($nums > 0) {$csv _data. = ' "'. $title _arr[$nums-1].
  "\ \ r \ n";  foreach ($data as $k => $row) {foreach ($row as $key => $r) {$row [$key] = Str_replace ("\", "\" \ "),

      $R); $csv _data. = "\ T". $row [$key].
    '",'; $csv _data. = ' "'. $row [$nums-1].
    "\ \ r \ n";
  Unset ($data [$k]);
  $csv _data = mb_convert_encoding ($csv _data, "cp936", "UTF-8"); $file _name = Empty ($file _name)?
  Date (' Y-m-d-h-i-s ', Time ()): $file _name;
    if (Strpos ($_server[' http_user_agent '), "MSIE") {//resolve bug of the Chinese name garbled in IE browser output $file _name = UrlEncode ($file _name);
  $file _name = str_replace (' + ', '%20 ', $file _name); $file _name = $file _name.
  '. csv '; Header (' ConteNt-type:application/download ');
  Header ("content-type:text/csv;");
  Header ("Content-disposition:attachment;filename=". $file _name);
  Header (' cache-control:must-revalidate,post-check=0,pre-check=0 ');
  Header (' expires:0 ');
  Header (' Pragma:public ');
  echo $csv _data;
Exit (); }

Note: Hyperlinks cannot be exported directly!

The above PHP export CSV file, you can export the leading 0 instance code is a small series to share all the content, hope to give you a reference, but also hope that we support the cloud habitat community.