Ben C. wrote:
I am using the code below to export my data into an excel file. The code is located in a password protected area which is checked against saved session variables. However when I put session_start(); the download errors out. Does any one have any suggestions? Please help.
<? session_start();
$connection = @mysql_connect("$host", "$uname", "$pass") or die("Couldn't connect."); $db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
/* Specify the filename, which includes a datestamp for archival purposes... */ $date_stamp = date("Ymd"); $file_name = "ExportedData" . "_" . "$date_stamp" . ".xls";
/* Specify MIME type for tab-separated-values... */ //header("Content-type: text/tab-separated-values");
/* To open file directly into Excel, use this MIME type instead... */ header("Content-type: application/x-msexcel");
/* To force file download... */ header("Content-Disposition: attachment; filename=$file_name");
/* List the spreadsheet column labels (optional)... */ $column_labels = array("Label 1", "Label 2 ", "Label 3"); /* ...and so on */ foreach($column_labels as $value) { echo("$value\t"); } echo("\n"); /* ...end column labels row */
/* Specify the SELECT query (you will need to change this)... */ $query = "SELECT * FROM buyers";
/* Execute the query... */ $result = mysql_query($query);
/* Format data as tab-separated values... */ while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { while (list($key, $value) = each($row)) { echo ("$value" . "\t"); } echo ("\n"); } ?>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php