output data as excel file

MYPETHELP

New Member
i am trying to open a file for export as excel. i can see the data in firebug but there is no option to offer the file to the user. what am i missing here? i have included my code that handles the query etc and would welcome your comments. many thanks\[code\]header("Content-Type: application/force-download");header("Content-Type: application/octet-stream");header("Content-Type: application/download");header("Content-type: application/vnd.ms-excel; name='excel'");header("Content-Disposition: attachment; filename=".$_GET['e'].".xls");header("Pragma: no-cache"); header("Expires: 0"); $e = $_GET['e'];// Load the common classesrequire_once('../../../includes/common/KT_common.php');// Load the tNG classesrequire_once('../../../includes/tng/tNG.inc.php');// Make a transaction dispatcher instance$tNGs = new tNG_dispatcher("../../../");// Make unified connection variable$conn_conn= new KT_connection($conn, $database_conn); switch($e) { case "act": mysql_select_db($database_conn, $conn); $select = "SELECT service, activity, company, user, item, filebox, date FROM act"; $export = mysql_query($select); $count = mysql_num_fields($export); for ($i = 0; $i < $count; $i++) { $header .= mysql_field_name($export, $i)."\t"; } while($row = mysql_fetch_row($export)) { $line = ''; foreach($row as $value) { if ((!isset($value)) OR ($value =http://stackoverflow.com/questions/3741492/="")) { $value = "http://stackoverflow.com/t"; } else { $value = http://stackoverflow.com/questions/3741492/str_replace('"', '""', $value); $valuehttp://stackoverflow.com/questions/3741492/= '"' . $value . '"' . "\t"; } $line .= $value; } $data .= trim($line)."\n"; } $data = http://stackoverflow.com/questions/3741492/str_replace("\r", "", $data); if ($data =http://stackoverflow.com/questions/3741492/="") { $data = "http://stackoverflow.com/n(0) Records Found!/n"; } print "$header\n$data"; break;\[/code\]
 
Back
Top