Forcing fputcsv to Use Enclosure For *all* Fields

php csv fputcsv
Alan Storm picture Alan Storm · Mar 22, 2010 · Viewed 39.8k times · Source

When I use fputcsv to write out a line to an open file handle, PHP will add an enclosing character to any column that it believes needs it, but will leave other columns without the enclosures.

For example, you might end up with a line like this

11,"Bob ",Jenkins,"200 main st. USA ",etc

Short of appending a bogus space to the end of every field, is there any way to force fputcsv to always enclose columns with the enclosure (defaults to a ") character?

Answer

VolkerK picture VolkerK · Mar 22, 2010

No, fputcsv() only encloses the field under the following conditions

/* enclose a field that contains a delimiter, an enclosure character, or a newline */
if (FPUTCSV_FLD_CHK(delimiter) ||
  FPUTCSV_FLD_CHK(enclosure) ||
  FPUTCSV_FLD_CHK(escape_char) ||
  FPUTCSV_FLD_CHK('\n') ||
  FPUTCSV_FLD_CHK('\r') ||
  FPUTCSV_FLD_CHK('\t') ||
  FPUTCSV_FLD_CHK(' ')
)

There is no "always enclose" option.

Related questions

Export whole table to CSV using laravel

I am new to laravel and having a tough time figuring out a way to export one table to csv. I have tried the following code in the controller class, but it gives me an error: public function get_export() { $…

Read More
php fputcsv use semicolon separator in CSV

I wrote a code where I retrieve data from DB and populate them in CSV using the function 'fputcsv' I put on top the following: $file = fopen("internal/customer_info.csv","w"); Then I retrieve the data and put them …

Read More
fputcsv and integer typcasting to string

So I have a line that I want to do a fputcsv on that has some integers (that I need to be treated as strings but they are numbers). These integers have leading zeroes that get cut off when I …

Read More