如何在php语句中引用值？周一大脑冻结

发布于 2024-09-30 08:15:36 字数 552 浏览 7 评论 0原文

我有一段 php 代码，它从数据库结果集中读取值，将它们推入数组，然后将它们写入 CSV 文件。当每个值进入 CSV 文件时，我需要强制每个值用双引号引起来，但我一辈子都不记得如何做到这一点。

这是写入文件的循环（这实际上包含在另一个循环中以遍历每一行；我显示的这个循环遍历当前选定行中的列）：

foreach ($row as $key => $val){

    $newrow[$key] = preg_replace("(\r\n|\n|\r|\t)", "", $val);

}

fputcsv($fp, $newrow);

我需要的是将 $val 的值写入文件时用双引号引起来。现在，我得到的结果如下所示：

554,702180,25.00,6FYAK0,9090909090909090

我需要的是：

"554","702180","25.00","6FYAK0","9090909090909090"

有人可以启动我的大脑吗？

原文

I have a piece of php code that reads values from a database resultset, shoves them into an array, and writes them to a CSV file. I need to force each value to be surrounded by double quotes when it goes into the CSV file, and can't for the life of me remember how to do this.

Here's the loop that writes to the file (this is actually contained in another loop to go through each row; this loop I'm showing goes through the columns in the currently-selected row):

foreach ($row as $key => $val){

    $newrow[$key] = preg_replace("(\r\n|\n|\r|\t)", "", $val);

}

fputcsv($fp, $newrow);

What I need is for the value of $val to be enclosed in double quotes when it's written to the file. Right now, the results I get look like this:

554,702180,25.00,6FYAK0,9090909090909090

What I need is this:

"554","702180","25.00","6FYAK0","9090909090909090"

Can someone jump start my brain?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

扮仙女 2024-10-07 08:15:36

我将使用 fputscsv 的替代函数：

function my_fputcsv($handle, $fieldsarray, $delimiter = ",", $enclosure ='"'){
    $glue = $enclosure . $delimiter . $enclosure;
    return fwrite($handle, $enclosure . implode($glue,$fieldsarray) . $enclosure);
}

I would use substitute function for fputscsv:

function my_fputcsv($handle, $fieldsarray, $delimiter = ",", $enclosure ='"'){
    $glue = $enclosure . $delimiter . $enclosure;
    return fwrite($handle, $enclosure . implode($glue,$fieldsarray) . $enclosure);
}

回复收藏 0 原文

调妓 2024-10-07 08:15:36

查看 PHP 站点上的 fputscsv 命令帮助：http ://php.net/manual/en/function.fputcsv.php

第四个参数指定封闭字符。这是您要找的吗？不过，据我了解，如果字段需要引号，则 CSV put 只会包含引号，因为字段本身包含分隔符字符或括弧字符。

回复收藏 0 原文

听你说爱我 2024-10-07 08:15:36

这是一个快速修复方法，但确实有效。

$value = '554,702180,25.00,6FYAK0,9090909090909090';

$new_value = '"' . implode('","', explode(',', $value)) . '"';

echo $new_value;

This is a quick fix, but it works.

$value = '554,702180,25.00,6FYAK0,9090909090909090';

$new_value = '"' . implode('","', explode(',', $value)) . '"';

echo $new_value;

回复收藏 0 原文

自我难过 2024-10-07 08:15:36

看起来很简单：

 $newrow[$key] = '"' . preg_replace("(\r\n|\n|\r|\t)", "", $val) . '"';

Seems simple enough:

 $newrow[$key] = '"' . preg_replace("(\r\n|\n|\r|\t)", "", $val) . '"';

回复收藏 0 原文

好菇凉咱不稀罕他 2024-10-07 08:15:36

如果您想在不使用 fputscsv 的情况下编写它，那么您可以使用与此类似的函数来生成要写入文件的行：

function csvify ($array)
{
   $temp = "";
   $counter = 0;
   foreach ($array as $element)
   {
      if ($counter > 0)
         $temp = $temp . ",";
      $counter ++;
      $temp = $temp . "\"$element\"";
   }
   return $temp;
}

IF you want to write it without using fputscsv then you could use a function similar to this to generate a line to write to a file:

function csvify ($array)
{
   $temp = "";
   $counter = 0;
   foreach ($array as $element)
   {
      if ($counter > 0)
         $temp = $temp . ",";
      $counter ++;
      $temp = $temp . "\"$element\"";
   }
   return $temp;
}

回复收藏 0 原文

~没有更多了~