csvfile line end

andyb1709

sorry about this - sounds simple but I can't find out what I'm doing wrong.
I've been trying to produce a csv file from a Mysql output using code which writes the output to a variable, then produces the file (not original code from me). The line to create the variable is

$invdte = date ("dmY",$i['invoice_date']);
	            $accno = $i['account_no_c'];
	            $invno = $i['number'];
	            $billorg = $i['billing_org_c'];
	            $totamt = $i['total_amount'];
		    $vatamt = $i['tax_amount'];
		    $subamt = $i['subtotal_amount'];
		    $cur = 'EUR'; 		
	            $content.= 
	$control.','.$invdte.',VE,'.$accno.',"Facture No '.$invno.' '.$billorg.'","'.$invno.'",'.$totamt.',D,'.$invdte.','.$cur.' \n ';

& I thought using \n would give me a line return. The file is created in

$FileName = "invoice.csv";
	            $FileHandle = fopen($FileName, 'w') or die("can't open file");
	            fwrite($FileHandle, $content);
	        fclose($FileHandle);

The problem is that the \n is just read as another column & printed to the file.

Can anyone tell me what I've done wrong? Thanks

bradgrafelman

For one, see the manual page for [man]string[/man]s - variable interpolation and the escape sequences (e.g. \n) are not performed/evaluated for strings delimited with single quotes.

However, also note that you should really consider using [man]fputcsv/man instead, since your code could be broken by certain (valid) data (and since there's no point in reinventing the wheel and/or not using the right tool for the right job).

EDIT: Also, welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

andyb1709

Thanks v much - simple really.

Thanks also for the tip about fputcsv. I read it through but need to understand the dbase output as an array better - some homework for me🙂