Re: CSV output.

From: Date: Tue, 09 Sep 2008 03:22:29 +0000
Subject: Re: CSV output.
References: 1 2 3 4 5  Groups: php.general 
Request: Send a blank email to php-general+get-279710@lists.php.net to get a copy of this message
What variable contains the number? How _exactly_ are you assigning the number to the variable? How _exactly_ are you writing the data to the CSV file? I tried looking up a function 'dump' at php.net and didn't turn up anything. How is dump implemented? On Sep 8, 2008, at 6:16 PM, Tom Shaw wrote:
This statement _is_ correct. I see values such as 234.55, but not 234.00 in the CSV file and when I dump the data. 55.00 will equal 55 when it should equal 55.00. 234.00 shows up as 234. The data is fine it just simple does not show up correctly in the CSV file. $out .="".$name.",".$description.",".$size.",".$stock.",".$price.",".$total_cost. ""; $out .= "\n"; } dump($out); This prints the correct data. exit(); header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=inventory_report.csv"); print $out; This prints wrong. -----Original Message----- From: Eric Gorr [mailto:mailist@ericgorr.net] Sent: Monday, September 08, 2008 4:21 PM To: PHP General Subject: Re: [PHP] CSV output. On Sep 8, 2008, at 5:06 PM, Tom Shaw wrote:
Actually that won't work I tried it. For some reason the .00 shows up when I try to manually add a .00. I know weird.
Did you mean to say that it .00 _doesn't_ show up when you try to manually add a .00?
The value is in the array or string before outputting printing to CSV. Number format does not work either.
And just to clarify...in your .csv file, you do see values such as 234.55, but not 234.00. I can promise you that if you fprintf( $fp, "234.00" ), you will see 234.00 in your file. So, the question becomes, what _exactly_ are you doing when you are writing this stuff out. --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


« previous php.general (#279710) next »