douci1851 2015-02-17 07:05
浏览 43
已采纳

如何使用php将数组写为csv文件内容?

I am importing a CSV file into my site which contain Hebrew language.While opening the CSV file in the notepad, the Hebrew language content are not enclosed by the quotes. The content which is not in quotes are not read in my site. During the time of uploading this csv file is moved into another file.To enclose the Hebrew content with double quotes I tried the following code,but the file is not upldated.

$fileHandler = fopen('IMPORT_193', 'rw');
        while (($buffer = fgets($fileHandler))) 
        {
        $v=explode(',',$buffer);

        for($i=0;$i<count($v);$i++)
        {

            $val=trim($v[$i],'"');
            $v1[]= '"'.$val.'"';

        }

        fputcsv($fileHandler, $v1);
        }

I want to update the current content in the file with the new values with quotes as CSV . Is there any way to enclose the CSV content in a file with quotes?Waiting for your reply!

  • 写回答

1条回答 默认 最新

  • dongtong1226 2015-02-17 07:43
    关注

    You can not (at least in this example) read and write to the same file at the same time. Try this:

    $fileRead = fopen('IMPORT_193', 'r');
    $tempFile = tempnam(sys_get_temp_dir(), 'CSVIMPORT');
    $fileWrite = fopen($tempFile, 'w');
    while(!feof($fileRead)) {
      $data = fgetcsv($fileRead);
      foreach($data as $key=>$value) {
        if(!is_numeric($value)) {
          $data[$key] = '"'.$value.'"';
        }
      }
      fputcsv($fileWrite, $data);
    }
    fclose($fileRead);
    fclose($fileWrite);
    rename($tempFile, 'IMPORT_193');
    

    This should do the trick. I have not tested this. And you need to have permissions to overwrite the IMPORT_193 file.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥200 uniapp长期运行卡死问题解决
  • ¥15 latex怎么处理论文引理引用参考文献
  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?