Add Row to Recordset results to use in CSV Header?

2/01/2019 12:07 pm | #1 Steve

How can I add a row to a recordsets results to use as a CVS header?

I'm successfully writing a CSV file but there is no Header values. It's easy to generate these in PhpMyAdmin as an exported csv file.
The code below takes the results from $Recordset1 and puts them in an array ($DataArray). But it is overwriting the list of column names.

How can I manually push the row of column names into the 1st position of the array to use as CSV Header values?

php:

// output headers so that the file is downloaded rather than displayed

header('Content-Type: text/csv; charset=utf-8');

header('Content-Disposition: attachment; filename=all-entries.csv');





// output the column headings

$DataArray = array('invTitle','invDescr','Address','City','fid','key','FeatRoofType','FeatSidingType','FeatColor','FeatGarage','FeatCarport','FeatStorShed','FeatGutters','FeatShutters','FeatThermoWindw','FeatDeck','FeatPatio','FeatCeilings','FeatIntWalls','FeatHeating','FeatIntCAir','FeatIntWAir','FeatIntFirePl','FeatIntPantry','FeatIntSkyLight','FeatIntCFan','FeatIntCathC','FeatIntSunRoom','FeatIntGTub','FeatIntBasement','FeatIntWalkInCloset','FeatIntLaundry','FeatApplDishw','FeatApplDryer','FeatApplWasher','FeatApplGarbageD','FeatApplOven','FeatApplMicroW','FeatApplRefridge');





$DataArray = $Recordset1->Results; // puts results into array





// create a file pointer (FP) connected to the output stream

$fp = fopen('php://output', 'w');



foreach ($DataArray as $fields) {

    fputcsv($fp, $fields);

}





fclose($fp);

2/01/2019 12:59 pm | #2 Ray BorduinWebAssist

update this line:
$DataArray = $Recordset1->Results; // puts results into array

to:
$DataArray = array_merge($DataArray, $Recordset1->Results); // puts results into array

Did this help? Tips are appreciated...

2/01/2019 1:07 pm | #3 Steve

I tried array_unshift() also...

array_merge did not work :-(

php:

<?php

// output headers so that the file is downloaded rather than displayed

header('Content-Type: text/csv; charset=utf-8');

header('Content-Disposition: attachment; filename=all-entries.csv');

// create a file pointer (FP) connected to the output stream

$fp = fopen('php://output', 'w');





// output the column headings

$DataArray = array('invTitle','invDescr','Address','City','fid','key','FeatRoofType','FeatSidingType','FeatColor','FeatGarage','FeatCarport','FeatStorShed','FeatGutters','FeatShutters','FeatThermoWindw','FeatDeck','FeatPatio','FeatCeilings','FeatIntWalls','FeatHeating','FeatIntCAir','FeatIntWAir','FeatIntFirePl','FeatIntPantry','FeatIntSkyLight','FeatIntCFan','FeatIntCathC','FeatIntSunRoom','FeatIntGTub','FeatIntBasement','FeatIntWalkInCloset','FeatIntLaundry','FeatApplDishw','FeatApplDryer','FeatApplWasher','FeatApplGarbageD','FeatApplOven','FeatApplMicroW','FeatApplRefridge');





$DataArray = array_merge($DataArray, $Recordset1->Results); // puts results into array





foreach ($DataArray as $fields) {

    fputcsv($fp, $fields);

}





fclose($fp);

?>

Results are a csv file but no first row matching the manually constructed values.

2/01/2019 1:24 pm | #4 Ray BorduinWebAssist

How about you just write that row separately like:

php:

fputcsv($fp, $DataArray);



$DataArray = $Recordset1->Results; // puts results into array



foreach ($DataArray as $fields) {

    fputcsv($fp, $fields);

}

Did this help? Tips are appreciated...

2/01/2019 1:34 pm | #5 Steve

Yup, that works perfectly. Gracias Ray!

Code in case anyone else needs this:

php:

<?php

// output headers so that the file is downloaded rather than displayed

header('Content-Type: text/csv; charset=utf-8');

header('Content-Disposition: attachment; filename=all-entries.csv');

// create a file pointer (FP) connected to the output stream

$fp = fopen('php://output', 'w');





// output the column headings as array

$DataArray = array('invTitle','invDescr','Address','City','fid','key','FeatRoofType','FeatSidingType','FeatColor','FeatGarage','FeatCarport','FeatStorShed','FeatGutters','FeatShutters','FeatThermoWindw','FeatDeck','FeatPatio','FeatCeilings','FeatIntWalls','FeatHeating','FeatIntCAir','FeatIntWAir','FeatIntFirePl','FeatIntPantry','FeatIntSkyLight','FeatIntCFan','FeatIntCathC','FeatIntSunRoom','FeatIntGTub','FeatIntBasement','FeatIntWalkInCloset','FeatIntLaundry','FeatApplDishw','FeatApplDryer','FeatApplWasher','FeatApplGarbageD','FeatApplOven','FeatApplMicroW','FeatApplRefridge');



fputcsv($fp, $DataArray); // put initial array into csv



$DataArray = $Recordset1->Results; // puts recordset results into existing array





foreach ($DataArray as $fields) {

    fputcsv($fp, $fields);

}





fclose($fp);

?>

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Add Row to Recordset results to use in CSV Header?

2/01/2019 12:07 pm | #1 Steve