donglu7998 2015-03-10 20:51
浏览 372

PHP:使用特殊字符导出为CSV

I am trying to export some data that is stored on a table but when I tried to export to CSV this letter č shows like Ä or &#269.

I tried everithing utf8_decode, utf8_enconde, html_entity_decode, but is not working. What can I do?

Thanks, Leandro.

Additional Information: Now I directly testing the following:

$delimiter = ";";
$enclosure = '"';

header("Content-Disposition: attachment; filename=memorandos.csv");
header("Pragma: no-cache");
header("Expires: 0");
$output = fopen('php://output', 'w');

$header = array('Apellido');
fputcsv($output, $header, $delimiter, $enclosure);
$memorando = Memorando::getById(3263);
if ($memorando){
    $dd = array ();
    $dd[] = $memorando->apellido;   ////ON THE DATABSE IS STORED LIKE Jurič
    fputcsv($output, $dd, $delimiter, $enclosure);
}

On the file I see this Juri&#269 ; instead of Jurič

  • 写回答

1条回答 默认 最新

  • dqqt31923 2015-03-10 21:01
    关注

    There are many angles and approaches of dealing with this issue, you can even try: ISO-8859-1

    Lets say you have

    $input = "Fóø Bår Zacarías ?S?B?D Ferreíra"; // original text
    

    Use iconv to get rid of the special chars

    $output = iconv("utf-8", "ascii//TRANSLIT//IGNORE", $input);
    

    Regexp lets remove utf-8 special characters except blank spaces

    $output =  preg_replace("/^'|[^A-Za-z0-9\s-]|'$/", '', $output); 
    

    Results in: Foo Bar Zacarias ASABAD Ferreira

    echo $output;
    

    And where is your code? can you share?

    评论

报告相同问题?

悬赏问题

  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行