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.

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

报告相同问题?

悬赏问题

  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
  • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
  • ¥15 TLE9879QXA40 电机驱动
  • ¥20 对于工程问题的非线性数学模型进行线性化
  • ¥15 Mirare PLUS 进行密钥认证?(详解)
  • ¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
  • ¥20 想用ollama做一个自己的AI数据库
  • ¥15 关于qualoth编辑及缝合服装领子的问题解决方案探寻
  • ¥15 请问怎么才能复现这样的图呀