wordpress csv export includes html in the output

Question

I am trying to dynamically create a downloadable csv file from within WordPress. The data to be included is correct, and the file is created for download successfully. However, the created csv file includes the template HTML output.

How can the data be output, without the HTML from the template?

Here is the function. The arrays are correctly populated with a sql query, but the results are identical to this.

function exportAsCSV (  ) {
  $csv = '';
  $header_array = array('Header 1', 'Header 2', 'Header 3');
  $data_array = array(
    array('Row 1 A', 'Row 1 B', 'Row 1 C'),
    array('Row 2 A', 'Row 2 B', 'Row 2 C'), 
  ); 

  $csv .= implode(', ', $header_array);
  $csv .= '\n';

  foreach($data_array as $row){
    $csv .= implode(', ', $row);
    $csv .= '\n';  
  } 


    $now = gmdate('D, d M Y H:i:s') . ' GMT';

    header('Content-Type: text/csv');
    header('Expires: ' . $now);

    header('Content-Disposition: attachment; filename="data.csv"');
    header('Pragma: no-cache'); 

    echo $csv; 
    exit();
}

The function is called as so:

if(isset($_GET['export_data'])){
  ob_end_clean();   
  exportAsCSV();
}

gonetil · Accepted Answer · 2023-02-15 21:21:02Z

3

To make this safer, you could clear the output buffer before sending anything to it. After that, you can start sending data to the output buffer, and flush it before closing the data stream. Something like this:

    function get_csv($columns_headers, $data) {
        
        $filename = "php://output";

        ob_clean(); //empty the output buffer 
        ob_start();  //and start a new one
        
        header('Pragma: public');
        header('Expires: 0' );
        header('Cache-Control: no-cache, must-revalidate');
        header('Content-Type: text/csv');
        header('Content-Disposition: attachment; filename="'.'data.csv"');

        $outstream = fopen($filename, 'r+')  or die("Error opening php://output");
        
        fputcsv( $outstream , $columns_headers );

        foreach($data as $item)
            fputcsv($outstream,$item);
        
        ob_flush();  //send the whole buffer
        fclose($outstream) or die("Error closing php://output");    
        //all done
        die();

    }

answered Feb 15, 2023 at 21:21

gonetil

594 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

faerysteel Over a year ago

This is the correct answer, to a decade old question lol

gotnull · Accepted Answer · 2012-09-11 05:08:58Z

1

I figured it out. More levels of output buffering. Now, I call ob_get_level() to determine how many times to ob_end_clean(). No more extra HTML in the output.

edited Sep 11, 2012 at 5:08

gotnull

27.2k23 gold badges143 silver badges207 bronze badges

answered Sep 11, 2012 at 2:36

faerysteel

1435 bronze badges

Comments

RobinAA2 · Accepted Answer · 2024-08-06 19:47:47Z

0

I had the same issue in WordPress. This worked for me; run this near the beginning of your function:

    foreach (range(0, ob_get_level()) as $i)
    {
        ob_end_clean();
    }

answered Aug 6, 2024 at 19:47

RobinAA2

11 bronze badge

Collectives™ on Stack Overflow

wordpress csv export includes html in the output

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related