how to handle comma string in fputcsv in php?

Question

how to put array values in csv in correct format? here is my code:

$title = Business - Research, MPhil/PhD | University of Greenwich | Research degrees;    
$description = '';
$keywords = '';
$list = $title.",".$keywords.",".$description;
$fp = fopen('public/scrap-meta-title-info.csv', 'a+');
        foreach ($list as $line) {
            fputcsv($fp, split(',', $line));
        }
        fclose($fp);

here is my array result: Business - Research, MPhil/PhD | University of Greenwich | Research degrees,, but when i put these values in csv then my title string break and put half value in keyword how i put title value complete in title field?

Ohgodwhy · Accepted Answer · 2014-09-25 06:38:00Z

2

Your delimiter is , and inside of your title you have a comma. Choose another delimiter, such as ** to concatenate and split on:

Such as:

$list = $title."**".$keywords."**".$description;

fputcsv($fp, split('\*\*', $line));

edited Sep 25, 2014 at 6:38

answered Sep 25, 2014 at 6:23

Ohgodwhy

50.8k11 gold badges86 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Muhammad Arif Over a year ago

Warning: split(): REG_BADRPT in /mnt/ Warning: fputcsv() expects parameter 2 to be array, boolean

Ohgodwhy Over a year ago

@MuhammadArif Right, my mistake. split() requires escaping of special characters defined by regexp. Therefore, we need to add \ before. Please look again.

Collectives™ on Stack Overflow

how to handle comma string in fputcsv in php?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related