Form results to a CSV file

exportformresultcsv

// +KH 17.05.12: ==================================================================
// Dowload Link CSV-File
echo '<div style="padding:3px; margin-top:20px; border: 1px solid #aaa; width: 150px; text-align:center; font-weight:bold; background-color:#ddd;">
<a href="'.PHPWCMS_URL.'include/inc_act/act_export.php?action=exportformresultcsv&fid='.$fid.'">Download CSV-File</a>'.LF.'
</div>'.LF;
// ================================================================================
 
    exit();
 
 
// +KH 17.05.12: ==================================================================
 
} elseif($action == 'exportformresultcsv' && isset($_GET['fid']) && ($fid = intval($_GET['fid']))) {
 
//    $data        = _getDatabaseQueryResult("SELECT *, DATE_FORMAT(formresult_createdate, '%Y-%m-%d %H:%i:%S') AS formresult_date FROM ".DB_PREPEND.'phpwcms_formresult WHERE formresult_pid='.$fid);
 
        $data        = _dbQuery("SELECT *, DATE_FORMAT(formresult_createdate, '%Y-%m-%d %H:%i:%s') AS formresult_date  FROM ".DB_PREPEND.'phpwcms_formresult WHERE formresult_pid='.$fid);
 
    if(!$data) die('Just a problem!');
 
    $separator    =';';     // CSV-Feldseparator
    $export        = array();
    $row        = 1;
    $export[0]    = array('#'=>'','#ID'=>'','#Date'=>'','#IP'=>'');
 
    // run all data first and combine array elements
    foreach($data as $key => $value) {
 
        // numbering starting at 1
        $export[$row]['#']        = $row;
        $export[$row]['#ID']    = $value['formresult_id'];
        $export[$row]['#Date']    = $value['formresult_createdate'];
        $export[$row]['#IP']    = $value['formresult_ip'];
 
        $val_array                = @unserialize($value['formresult_content']);
        if(is_array($val_array) && count($val_array)) {
            foreach($val_array as $a_key => $a_value) {
                $export[$row][$a_key]    = $a_value;
                $export[0][$a_key]        = '';
            }
        }
 
        $row++;
    }
 
 
    header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
    header('Last-Modified: '.gmdate('D, d M Y H:i:s GMT', time()) );
    header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0, post-check=0, pre-check=0');
 
    $filename = date('Y-m-d_H-i-s').'_formresultXmlID-'.$fid.'.csv';
    header('Content-Type: text/comma-separated-values');
    header( 'Content-Transfer-Encoding: BASE64;' );
     header('Content-Disposition: attachment; filename="'.$filename.'"');
 
    $elements = array();
 
    // ---- Kopfzeile
    $elements[0]  = '';
    foreach($export[0] as $key => $value) {
        $elements[0] .= '';
        $elements[0] .= $key;
        $elements[0] .= $separator;
    }
    $elements[0] = substr($elements[0], 0, -1);  // letztes ";" in Zeile loeschen
 
 
    // ---- Naechste Zeilen
    for($x = 1; $x < $row; $x++) {
 
        $elements[$x]  = '';
        foreach($export[0] as $key => $value) {
 
            $elements[$x] .= '';
 
//            if ( isset($export[$x][$key]) ) {
 
//                // Nicht zwingen notwenig, nur um fuer HTML-Darstellung
//                $export[$x][$key] = html_specialchars($export[$x][$key]);
 
                // Jede Spalte wird standardkonform in "..." gesetzt (OG: 18.05.2012)
                $export[$x][$key] = str_replace(chr(13),'', $export[$x][$key]);            // CR loeschen wenn vorhanden (LF bleibt bestehen wenn vorhanden)
                $export[$x][$key] = '"'.str_replace('"', '""', $export[$x][$key]).'"';    // Jede Spalte in "..." setzen
 
//            }
 
            $elements[$x] .= $separator;        // CSV-Trenner setzen
 
        }
        $elements[$x] = substr($elements[$x], 0, -1);     // letztes ";" in Zeile loeschen
 
        unset($export[$x]); // free memory
    }
 
    echo implode(chr(13).chr(10), $elements);        // CRLF am Zeilenende anfuegen
 
    exit();
 
// ================================================================================