fwrite() can display number_format() in PHP [duplicate]

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
– user10099, Commented Dec 1, 2021 at 6: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
– Sarthak Raval, Commented Dec 1, 2021 at 6:25

Sarthak Raval · Accepted Answer · 2021-12-01 06:48:22Z

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 1, 2021 at 6:48

answered Dec 1, 2021 at 6:32

Sarthak Raval

1,3011 gold badge15 silver badges25 bronze badges

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

2 Comments

Nico Haase Over a year ago

Please share more details such that others can learn from your answer. How does this help to use proper formatting within that file?

Sarthak Raval Over a year ago

@ferdinand it's helpful?

Collectives™ on Stack Overflow

fwrite() can display number_format() in PHP [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related