-
Notifications
You must be signed in to change notification settings - Fork 0
/
excelcikart2.php
61 lines (57 loc) · 1.66 KB
/
excelcikart2.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<meta http-equiv="Content-Type" content="text/html" charset="UTF-8" />
<?php
session_start();
if(!isset($_SESSION["login"])){
echo '<meta http-equiv="refresh" content="0;URL=giris.php">';
} else
{
include("kontrol/veritabani.php");
$DB_TBLName = $_POST['tabloadi'];
$filename = $_POST['tabloadi'];
$result = $connection->prepare("select * from $DB_TBLName");
$result->execute();
$file_ending = "xls";
$sep = "\t";
$csv_fields = array();
$csv_fields[] = 'ID';
$csv_fields[] = 'TARİH';
$csv_fields[] = 'İŞ EMRİ';
$csv_fields[] = 'GELİ';
$csv_fields[] = 'IMEI';
$csv_fields[] = 'MODEL';
$csv_fields[] = 'M. AD';
$csv_fields[] = 'M. SOYAD';
$csv_fields[] = 'TELEFON';
$csv_fields[] = 'ÜCRET';
$csv_fields[] = 'ÖDEME';
$csv_fields[] = 'AÇIKLAMA';
$csv_fields[] = 'GELİRGİDER';
for($i=0;$i<13;$i++)
{
echo $csv_fields[$i].$sep;
}
print "\n";
while($row = $result->fetch(PDO::FETCH_NUM))
{
$schema_insert = "";
for($j=0; $j<$result->columnCount();$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif ($row[$j] != "")
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
$schema_insert .= "\t";
print(trim($schema_insert));
print "\n";
}
header("Content-Type: application/xls");
header("Content-Disposition: attachment; filename=$filename.xls");
header("Pragma: no-cache");
header("Expires: 0");
}
?>