PHP - Error occurred in export CSV file

Question

When exporting a CSV file in PHP, full page code also export,after that only data export.

Code:

<?php

      header("Content-type: text/csv");
      header("Content-Disposition: attachment; filename=file.csv");
      header("Pragma: no-cache");
      header("Expires: 0");
      $data = array(
          array("data12", "data16", "data17"),
          array("data2", "data33", "data25"),
          array("data31", "data32", "data23")
      );   
      $file = fopen('php://output', 'w');                              
      fputcsv($file, array('Description', 'Click', 'CTR'));      

?>

Mycode <?php header("Content-type: text/csv"); header("Content-Disposition: attachment; filename=file.csv"); header("Pragma: no-cache"); header("Expires: 0"); $data = array( array("data12", "data16", "data17"), array("data2", "data33", "data25"), array("data31", "data32", "data23") ); $file = fopen('php://output', 'w'); fputcsv($file, array('Description', 'Click', 'CTR')); ?> — Mahalakshmi S
– Mahalakshmi S, Commented Jul 27, 2017 at 8:48
Please edit your initial post and add the code as text, not as an image. Furthermore, watch the overall quality of your question. No one is going to answer, if your post has such a low quality. The question will very likely be flagged and might get deleted. — user1438038
– user1438038, Commented Jul 27, 2017 at 9:11

JohnWayne · Accepted Answer · 2017-07-27 09:52:07Z

1

You should prepare your data for csv file (do not send array). Also I do not know what is your desired result in csv file.

Try this

$data = array(
      array("data12", "data16", "data17"),
      array("data2", "data33", "data25"),
      array("data31", "data32", "data23")
    );
    $csvData = "Your header\n";
    foreach ($data as $row) {
      foreach($row as $dot) {
        $csvData .= $dot.';';
      }
    }
    $csvData = utf8_decode($csvData);
    header('Content-Type: application/csv; charset=UTF-8');
    header('Content-Disposition: attachement; filename="myfile.csv"');
    echo $csvData;
    exit();

answered Jul 27, 2017 at 9:52

JohnWayne

6639 silver badges30 bronze badges

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

4 Comments

Mahalakshmi S Over a year ago

Just i export empty csv file means, page coding also export. i can't able to find the mistake

JohnWayne Over a year ago

in your example you are trying to write an array in file, and than you are getting error like complete HTML in csv etc.

Mahalakshmi S Over a year ago

yes correct.how will i avoid this error when export csv file?. please guide me.

JohnWayne Over a year ago

@MahalakshmiS You have to make iteration of your array, or before export define which data structure do you want and than send data to CSV file. You have to explain which data you are sending and what should be your result. This example is working scheme what you have to do to get proper csv file

Collectives™ on Stack Overflow

PHP - Error occurred in export CSV file

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related