dongqi8863 2019-05-21 05:53
浏览 65

将MYSQL数据表从网站导出为CSV时出现错误的字符

I found solutions here but still got problems. I have data table in my website which one uses Georgian Fonts, in my MYSQL database those fonts are displayed normally but when I try to download this table using export.php in my PC with .csv file the fonts are like

გáƒáƒ¡áƒáƒ¡áƒ•áƒšáƒ”ლში

In my export.php the code is below:

if(isset($_POST["export"]))  
 {   
      header('Content-Transfer-Encoding: binary'); 
      header('Content-Type: text/csv; charset=UTF-8');  
      header('Content-Disposition: attachment; filename=data.csv');  
      $output = fopen("php://output", "w");  
      fputcsv($output, array('არდუინოს N','ტრანზაქცია', 'User ID', 'Transaction Date', 'Object Name', 'Terminal Name', 'Amount'));  
      $query = "SELECT * FROM Table WHERE userID='$userID' ORDER BY trID DESC"; 
      $result = mysqli_query($db, $query);  
      while($row = mysqli_fetch_assoc($result))  
      {  
           fputcsv($output, $row);  
      }  
      fclose($output);  
 }  

Download works fine I got file data.csv but inside this file characters are unrecognized Link for Image

Any ideas? What is wrong ? If you think that is duplicated Question then I can tell you NO because before posting here I found lots of same solutions but nothing helps In my database connection php file I have added

$db->set_charset("utf8");

and

mysqli_query("SET NAMES 'utf8';");

But nothing changed... Any tips what would cause this problem would be great, Thank you guys in advance...

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 matlab数字图像处理频率域滤波
    • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
    • ¥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发现数据能走到后端,但是放行之后就会提示错误