php mysql導出excel_用PHP将MySQL資料導出到Excel

我正在嘗試将MySQL資料儲存到Excel檔案，但是Excel單元格出現問題。我所有的文本都放在一個單元格中，我希望每個行值都在單獨的Excel單元格中。這是我的代碼：

$queryexport = ("

SELECT username,password,fullname FROM ecustomer_users

WHERE fk_customer='".$fk_customer."'

");

$row = mysql_fetch_assoc($queryexport);

$result = mysql_query($queryexport);

$header = '';

for ($i = 0; $i < $count; $i++){

$header .= mysql_field_name($result, $i)."\t";

}

while($row = mysql_fetch_row($result)){

$line = '';

foreach($row as $value){

if(!isset($value) || $value == ""){

$value = "\t";

}else{

$value = str_replace('"', '""', $value);

$value = '"' . $value . '"' . "\t";

}

$line .= $value;

}

$data .= trim($line)."\n";

$data = str_replace("\r", "", $data);

if ($data == "") {

$data = "\nno matching records found\n";

}

}

header("Content-type: application/vnd.ms-excel; name='excel'");

header("Content-Disposition: attachment; filename=exportfile.xls");

header("Pragma: no-cache");

header("Expires: 0");

// output data

echo $header."\n".$data;

mysql_close($conn);`