PHP MySQL csv export

Question

I am trying to export MySQL data to csv file. Here is my code

header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");           
header("Content-Type: application/octet-stream");           
header("Content-Disposition: attachment;filename=data.csv");
header("Content-Transfer-Encoding: binary");   
$output = fopen('php://output', 'w');
fputcsv($output, array('Id', 'Data 1', 'Data 2','Data 3'));

foreach ($data as $row)
{                    
     fputcsv($output, $row, ',', '"'); //arabic data
}
fclose($output);           
return chr(255) . chr(254) . mb_convert_encoding(ob_get_clean(), 'UTF-16LE', 'UTF-8');

The data contain Arabic and Hindi languages. The code results with all data with comma separated in one cell with new line.

I want to download this file with data in each cell. I tried this in last of code

return ob_get_clean();

it shows data in each row, but data expect English not loaded correctly.

How can solve this?

Paresh Barad · Accepted Answer · 2017-05-26 13:34:29Z

1

The mysqli_set_charset() function specifies the default character set to be used when sending data from and to the database server.

Please use before Mysql query.

mysqli_set_charset( $db, 'utf8');

edited May 26, 2017 at 13:34

answered May 24, 2017 at 6:01

Paresh Barad

1,60912 silver badges19 bronze badges

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

1 Comment

Aneesh Asokan Over a year ago

header('Content-Type: text/csv; charset=utf-8' ); added in code and not working.

Collectives™ on Stack Overflow

PHP MySQL csv export

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related