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

Question

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.

Answer 1

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) . '';
            }