csv不会忽略'，'（逗号）并使用php创建一个新行

问题描述：

I am downloading a table from a database using php and saving it as a .csv file. But when one of the columns contains a comma ',' inside the string the script takes the rest of the string (after the comma) to a new column. How can I make the script to ignore that comma?

I have tried putting a '\' next to it or using stripcslashes() but nothing works.

Part of the Code

$rows = mysqli_fetch_assoc($select_table);

if ($rows)
{
    getcsv(array_keys($rows));
}
while($rows)
{
    getcsv($rows);
    $rows = mysqli_fetch_assoc($select_table);
}

// get total number of fields present in the database
function getcsv($no_of_field_names){
    $separate = '';
// do the action for all field names as field name
    foreach ($no_of_field_names as $field_name)
        {
            if (preg_match('/\|\
|,|"/', $field_name))
                {
                $field_name = '' . str_replace(',','!', $field_name) . '';
            }
            echo str_replace('!',',', $field_name) . $separate . $field_name;
            //sepearte with the comma
            $separate = ',';
}

//make new row and line
echo "
";
}
?>

EDIT:

If I don't use comma then the csv file won't load properly in excel (column by column, row by row).

Before anyone starts saying why you doing that and that I AM DOING IT FOR PRACTICE.

我正在使用php从数据库下载表并将其另存为.csv文件。但是当其中一列包含逗号'，'在字符串内时，脚本会将字符串的其余部分（在逗号之后）带到新列。如何让脚本忽略该逗号？ p>

我试过在它旁边放一个'\'或者使用stripcslashes（）但没有任何效果。 p>

部分代码 strong> p>

  $ rows = mysqli_fetch_assoc（$ select_table）; 
 
if（  $ rows）
 {
 getcsv（array_keys（$ rows））; 
} 
while（$ rows）
 {
 getcsv（$ rows）; 
 $ rows = mysqli_fetch_assoc（$ select_table）; 
  } 
 
 //获取数据库中存在的字段总数
 
函数getcsv（$ no_of_field_names）{
 $ separate =''; 
 //对所有字段名称执行操作为字段名称
 foreach（  $ no_of_field_names为$ field_name）
 {
 if（preg_match（'/ \
 | \
 |，|“/'，$ field_name））
 {
 $ field_name =''。str_replace（'，  '，'！'，$ field_name）。''; 
} 
 echo str_replace（'！'，'，'，$ field_name）。$ separate。$ field_name; 
 // sepearte with逗号
 $  separate ='，'; 
} 
 
 //创建新行和行
echo“
 
”; 
} 
？＆gt; 
  code>  pre> 
 \  n  编辑： strong>  p> 
 
 
如果我不使用逗号，那么csv文件将无法在excel中正确加载（逐列，逐行）  ）。  p> 
 
 

在任何人开始说出你为什么这样做以及我为实践而做的事情之前。   p> 
  div>

答

puting the $field_name in quotes in order to be considered as a string will do the trick!!

if (preg_match('/\|\
|,|"/', $field_name))
                {
                $field_name = '"'.$field_name.'"';
            //field_name = '' . str_replace(',','.', $field_name) . '';
            }

答

Since you are practicing, here are some basic rules for csv (let's assume comma as separator):

123,test,456

When a field contains a separator, that field has to be enclosed in double quotes:

123,"monitor, Samsung","45,8"

In other words, if a field is enclosed in double quotes that does not mean it is a string, only that there is (or could be) a separator inside the field.

When a quoted field also contains quotes, those have to be escaped with another quote:

123,"monitor 24"", Samsung","45,8"

This is important to remember when you do the parsing yourself. (and actually, once you start using double quotes, all fields containing double quotes should also be quoted, even if there is no separator inside)

Multiline fields also have to be in double quotes:

123,"monitor 24"", Samsung","test multiline 
field","45,8"

The above is actually 1 row.

csv不会忽略'，'（逗号）并使用php创建一个新行

相关推荐