[SOLVED] Generating a CSV on the fly

[bluesoul]

Ugh, having some problems getting this working.

 

Before my loop:

 

$list = array (
    'Account ID,Invoice ID,Domain,Invoice Date, Registrar, Description, Exp. Date, Charge, Balance');

 

In the loop:

$fp = fopen('invoice'.$timestamp.'.csv', 'w');
$list .= array (
    "$aaid,$aiid,$adn,$invdate, $arid, $adesc, $expdate, $charge, $balance");
foreach ($list as $line) {
    fputcsv($fp, split(',', $line));
}

 

After the loop:

fclose($fp);

 

Results in "Warning: Invalid argument supplied for foreach() in searchinvoices.php on line 77".  I'm assuming it's because I can only pass it one element at a time.  Ideas?

[kenrbnsn]

You do not want to use the "." operator, try something like this:

<?php
$list = array();
$list[] = array (
    'Account ID,Invoice ID,Domain,Invoice Date, Registrar, Description, Exp. Date, Charge, Balance');
$fp = fopen('invoice'.$timestamp.'.csv', 'w');
$list[] = array (
    "$aaid,$aiid,$adn,$invdate, $arid, $adesc, $expdate, $charge, $balance");
foreach ($list as $line) {
    fputcsv($fp, split(',', $line));
}?>

 

Ken

[Mchl]

$fp = fopen('invoice'.$timestamp.'.csv', 'w');
$list = array (
    'Account ID','Invoice ID','Domain','Invoice Date','Registrar','Description','Exp. Date','Charge','Balance');
fputcsv($fp,$list);

$list = array (
    $aaid,$aiid,$adn,$invdate,$arid,$adesc,$expdate,$charge,$balance);
fputcsv($fp,$list);

[rhodesa]

couple of things...

-the fopen should probably be OUTSIDE the loop

-you are putting variables into a string then back to an array...just put them right into the array:

$list = array ($aaid,$aiid,$adn,$invdate, $arid, $adesc, $expdate, $charge, $balance);
fputcsv($fp, $list);

[bluesoul]

$fp = fopen('invoice'.$timestamp.'.csv', 'w');
$list = array (
    'Account ID','Invoice ID','Domain','Invoice Date','Registrar','Description','Exp. Date','Charge','Balance');
fputcsv($fp,$list);

$list = array (
    $aaid,$aiid,$adn,$invdate,$arid,$adesc,$expdate,$charge,$balance);
fputcsv($fp,$list);

 

This got it, thanks a ton, I'd have been beating my head on this for a while.