fwrite() can display number_format() in PHP

Question

I'm doing function to export CSV file in PHP. but when i do an export, i need to add information about total in number_format().. but display is wrong.

Here is my code

header('Content-Type: text/csv; charset=utf-8');  
header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");
header('Content-Disposition: attachment; filename=' . $fileName ); 
header("Content-Transfer-Encoding: binary");
header('Pragma: no-cache');
header('Expires: 0');

$file = fopen("report.csv", "w");  

fwrite($file, "Generate Report \r\n"); 
fwrite($file, "Total Sales, ".number_format($total)."\r\n");
fwrite($file, " "."\r\n");

the result is this

and that is wrong.

How do i can display the correct format number like "5,485" or maybe "5,485.00" in 1 cell on CSV file?

please help

fwrite($file, "Total Sales, \"".number_format($total)."\"\r\n"); — user10099, Dec 01 '21 at 06:05
The fwrite() writes to an open file. The function will stop at the end of the file (EOF) or when it reaches the specified length, whichever comes first. — Sarthak Raval, Dec 01 '21 at 06:25

Sarthak Raval · Accepted Answer · 2021-12-01T06:48:22.137

1

fwrite(resource $handle, string $string, int $length = ?): 

fwrite($file, "Total Sales, \"".number_format($total)."\"\r\n");

int fwrite() writes the contents of string to the file stream pointed to by handle.

Return Values fwrite() returns the number of bytes written, or false on error.

edited Dec 01 '21 at 06:48

answered Dec 01 '21 at 06:32

Sarthak Raval

1,001
1
10
23

Please share more details such that others can learn from your answer. How does this help to use proper formatting within that file? – Nico Haase Dec 01 '21 at 06:36
@ferdinand it's helpful? – Sarthak Raval Dec 01 '21 at 06:50

fwrite() can display number_format() in PHP

1 Answers1