export mysql table data to csv file through php..html also get dumped

Question

So I was trying to export mysql table to csv file via php. This is the code

<?php if (isset($_POST['exp'])) {

    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=data.csv');

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

    fputcsv($output, array('User ID', 'User Name', 'Password'));
    $con = mysqli_connect('localhost', 'root', 'pass', 'xyz');
    $rows = mysqli_query($con, 'SELECT * FROM users');

    while ($row = mysqli_fetch_assoc($rows)) {
      fputcsv($output, $row);
    }
    fclose($output);
    mysqli_close($con);
  }
?>

<div>
  <form action="#" method="post">
    <input type="submit" value="Export" name="exp" />
  </form>
</div>

Every thing is fine but the html part also gets dumped in the csv file. here is screen shot of the csv csv output

Why is that happening? Am I doing anything wrong?

separate your code in two different files: HTML and PHP. — RNK
– RNK, Commented Oct 27, 2014 at 17:46

slapyo · Accepted Answer · 2014-10-27 17:50:24Z

4

Your page continues to load beyond the PHP. Add exit() at the end inside the IF statement and it will stop running right there.

<?php if (isset($_POST['exp'])) {

    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=data.csv');

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

    fputcsv($output, array('User ID', 'User Name', 'Password'));
    $con = mysqli_connect('localhost', 'root', 'pass', 'xyz');
    $rows = mysqli_query($con, 'SELECT * FROM users');

    while ($row = mysqli_fetch_assoc($rows)) {
      fputcsv($output, $row);
    }
    fclose($output);
    mysqli_close($con);
    exit();
  }
?>

<div>
  <form action="#" method="post">
    <input type="submit" value="Export" name="exp" />
  </form>
</div>

answered Oct 27, 2014 at 17:50

slapyo

2,9911 gold badge18 silver badges26 bronze badges

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

2 Comments

Sourabh Over a year ago

ok, that does the trick. But why does the html gets written in csv, even if I have closed the file pointer?

slapyo Over a year ago

My guess is because the script continues to execute after you close the file pointer. So even though the file pointer is closed, more output exists after that, the HTML. So it just gets tagged onto the end of it.

Collectives™ on Stack Overflow

export mysql table data to csv file through php..html also get dumped

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related