duancu4731 2019-05-24 07:38
浏览 92

在CSV文件的所有字段中插入双引号(PHP5.6.38)

I've got one problem with fputcsv function. When I introduce an enclosure parameter (double quotes) and execute it with php command in Ubuntu, php script not insert this parameter in csv file.

fputcsv($handle,$array,";",'"'); //One try
fputcsv($handle,$array,";","\""); //Second try
fputcsv($handle,$array,";",chr(34)); //Third try
fputcsv($handle,$array,";","""); //Fourth try
fputcsv($handle,$array,";","'"'"); //Fifth try
fputcsv($handle,$array,";",'"','"'); //Sixth try
fputcsv($handle,$array,";",$quote = '"'); //Seventh try

<?php

//An example JSON string.
$jsonString = file_get_contents('archivo.json');
$codificado = utf8_encode($jsonString);

//Decode the JSON and convert it into an associative array.
$jsonDecoded = json_decode($codificado, true);

//Give our CSV file a name.
$csvFileName = 'example.csv';

//Open file pointer.
$fp = fopen($csvFileName, 'w');

$firstLineKeys = false;
//Loop through the associative array.
foreach($jsonDecoded as $row){
        if(empty($firstLineKeys)) {
                $firstLineKeys = array_keys($row);
                fputcsv($fp,$firstLineKeys,';','"');  
                $firstLineKeys = array_flip($firstLineKeys);
        }
        fputcsv($fp,array_merge($firstLineKeys,$row),';','"');  
}

//Finally, close the file pointer.
fclose($fp);
?>

CSV file without double quotes in all fields.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 Jenkins自动化部署—悬赏100元
    • ¥15 关于#python#的问题:求帮写python代码
    • ¥20 MATLAB画图图形出现上下震荡的线条
    • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
    • ¥15 perl MISA分析p3_in脚本出错
    • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
    • ¥15 ubuntu虚拟机打包apk错误
    • ¥199 rust编程架构设计的方案 有偿
    • ¥15 回答4f系统的像差计算
    • ¥15 java如何提取出pdf里的文字?