<?php
session_start();
include "includes/Include_config.php";
include "../values.php";
//if the user has not logged in
if(!isLoggedIn())
{
header('Location: ../index.php');
die();
}
$result = mysql_query("SELECT code, codeiedereen from `inlogcodes` WHERE subdomein='".mysql_real_escape_string($_SESSION['domein'])."'");
$count = mysql_num_fields($result);
$header = "";
$data = "";
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{
# important to escape any quotes to preserve them in the data.
$value = str_replace('"', '""', $value);
# needed to encapsulate data in quotes because some data might be multi line.
# the good news is that numbers remain numbers in Excel even though quoted.
$value = '"' . $value . '"' . "\t";
}
$line .= $value;
}
$data .= trim($line)."\n";
}
# this line is needed because returns embedded in the data have "\r"
# and this looks like a "box character" in Excel
$data = str_replace("\r", "", $data);
# Nice to let someone know that the search came up empty.
# Otherwise only the column name headers will be output to Excel.
if ($data == "") {
$data = "\nno matching records found\n";
}
# This line will stream the file to the user rather than spray it across the screen
header("Content-Type: application/vnd.ms-excel; name='excel'");
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=inlogcodes.xls");
header("Pragma: no-cache");
header("Expires: 0");
echo $header."\n".$data;
?>
1.577 views
Ik kan een excel bestand genereren met codes er in, alleen loop tegen 1 dingetje aan namelijk hoe ik (zie code)de codes van codeiedereen ook in de juiste kolom kan zetten dus headers heten code en codeiedereen alleen hij zet alle codes nu onder code en ook degene van codeiedereen, dus wil deze apart in een kolom krijgen, iemand een idee?\