Download to excel problem

[Ady01]

As part of my website i want to be able to allow mysql table to be downloaded to excel I have the below code to 'get' the data :

<?php
require_once("config.php");


$db=mysql_connect($AddressBook_HOST,$AddressBook_Username,$AddressBook_Password);
mysql_select_db($AddressBook_DatabaseName,$db);


$query  = "SELECT Name, DOB, HouseNumber FROM Addresses";
$result = mysql_query($query) or die('Error, query failed');

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
	echo "Name :{$row['Name']} <br" .
	     "DOB : {$row['DOB']} <br" .
		 "HouseNumber : {$row['HouseNumber']} <br><br>";
}

mysql_free_result($result);

include 'close.php';

?>

The below code then takes the data and allows to be converted to excel:

<?php
include 'download.php';

$query  = "SELECT Name, DOB, HoseNumber FROM Addresses";
$result = mysql_query($query) or die('Error, query failed');

$tsv  = array();
$html = array();
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
   $tsv[]  = implode("\t", $row);
   $html[] = "<tr><td>" .implode("</td><td>", $row) .              "</td></tr>";
}

$tsv = implode("\r\n", $tsv);
$html = "<table>" . implode("\r\n", $html) . "</table>";

$fileName = 'mysql-to-excel.xls';
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$fileName");

echo $tsv;


include 'download.php';
?>

All it does is give the below output and it just displays in the web page not in excel ? what have i done wrong ?

Name :

Name :

522380 Ptechnology group alivemore 358225 eservices person a

[leatherback]

Hm..

Your first file gets the data? It seems to echo the records. At that point you have output being generated. You should get a lot of errors after that point when you try to set the excel headers. Is the first file the download.php that you mention?

Second; A linebreak in xhtml is <br /> not <br

Third: I think the mime type excel is not vnd.ms-excel, but just ms-excel:

Content-type: excel/ms-excel; name=$filename

[Ady01]

I think i messed up on the above code so I have started again ! this time using just 1 file (new code below) Still getting problems though: now its just saying on the website that the table is empty when its not !

<?php
include('config.php');

$db=mysql_connect($AddressBook_HOST,$AddressBook_Username,$AddressBook_Password);
mysql_select_db($AddressBook_DatabaseName,$db);

$result = mysql_query('select DOB from Addresses', $linkID);
$count = mysql_num_fields($result);

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 = "\nSQL table is empty, no data to display. Please add entries to database before using the download function\n";
}


header("Content-type: application/octet-stream");


header("Content-Disposition: attachment; filename=buddylist.xls");
header("Pragma: no-cache");
header("Expires: 0");

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

[snb828]

[MOD]Please do not re-open multiple old threads to promote your software.[/MOD]