mysqldata excel
hvordan hiver jeg data ud af min db direkte til exceljeg kan godt selv eksportere men skulle gerne gøres kunne gøres af en bruger som ikke skal ind og pille i min db
jeg har fundet føgene kode men den smider det bare ud i html.
<?php
define(db_host, "******");
define(db_user, "******");
define(db_pass, "*****");
define(db_link, mysql_connect(db_host,db_user,db_pass));
define(db_name, "*****");
mysql_select_db(db_name);
$select = "SELECT * FROM ******";
$export = mysql_query($select);
$fields = mysql_num_fields($export);
for ($i = 0; $i < $fields; $i++) {
$header .= mysql_field_name($export, $i) . "\t";
}
while($row = mysql_fetch_row($export)) {
$line = '';
foreach($row as $value) {
if ((!isset($value)) OR ($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 = "\n(0) Records Found!\n";
}
header("Content-type: application/xls");
header("Content-Disposition: attachment; filename=bestillinger.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";
?>