Problem in Export csv file in php

Question

I need to export csv file in php using mysql query .But when i export filename like this "yourfilename.csv_".

My code is

header("Content-type: application/csv");

header("Content-Disposition: \"inline; filename=yourfilename.csv\"");  

$query = "SELECT * FROM login";

$result = mysql_query($query) ;

echo "username ,password \r\n";

while($row = mysql_fetch_array($result))
{
    echo "$row[user],$row[pass]\r\n";  
}

I need file name "yourfilename.csv".

Gordon · Accepted Answer · 2011-09-22 11:40:05Z

2

You can have MySql return a query result to file directly with

SELECT * INTO OUTFILE 'result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM my_table;

and then just do (also see Example #1 Download dialog)

header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="yourfilename.csv"');
readfile('result.csv');

answered Sep 22, 2011 at 11:40

Gordon

318k76 gold badges547 silver badges566 bronze badges

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

Collectives™ on Stack Overflow

Problem in Export csv file in php

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related