source: branches/Corsika7405Compatibility/datacenter/db/printtable.php@ 20115

Last change on this file since 20115 was 17386, checked in by tbretz, 11 years ago
Removed svn:executable property, these are no executables.
File size: 2.5 KB
Line 
1<?php
2{
3 function PrintForm($_GET)
4 {
5 if (empty($_GET["fTable"]))
6 {
7 printf("ERROR - No table selected.\n");
8 return;
9 }
10 }
11
12 function PrintPage($html, $host, $user, $pw, $db, $limits, $rms)
13 {
14 if (empty($_GET["fTable"]))
15 {
16 printf("ERROR - No table selected.\n");
17 return;
18
19 }
20
21 $db_id = mysql_connect($host, $user, $pw);
22 if ($db_id==FALSE)
23 {
24 printf("mysql_connect returned the following error: %s\n", mysql_error());
25 die("");
26 }
27 mysql_select_db($db);
28
29 $fromtable=$_GET["fTable"];
30 $query0 = "SELECT SQL_CALC_FOUND_ROWS * FROM " . $fromtable;
31 if (!empty($_GET["fSortBy"]))
32 {
33 $val=substr($_GET["fSortBy"], 0, -1);
34 $query0 .= " ORDER BY " . GetTable($fromtable,$val) . " ";
35 if (substr($_GET["fSortBy"], -1)=="-")
36 $query0 .= "DESC";
37 }
38
39
40 $result0 = mysql_query($query0, $db_id);
41 $result1 = mysql_query("SELECT FOUND_ROWS()", $db_id);
42
43 if ($result0)
44 {
45 if ($html=="1")
46 {
47 $alias = array
48 (
49 );
50 $rightalign = array
51 (
52 );
53 PrintMagicTable($result0, $alias, $rightalign, "", "", "", $result1);
54 }
55 else
56 PrintText($result0);
57
58 mysql_free_result($result0);
59 mysql_free_result($result1);
60 }
61 mysql_close($db_id);
62
63 if ($html=="1")
64 PrintSubmittedQuery($query0, $db, "old");
65 }
66
67 include ("include.php");
68 include ("db.php");
69 include ("magicdefs.php");
70
71 ini_set("display_errors", "On");
72 ini_set("mysql.trace_mode", "On");
73
74 if (!empty($_GET["fSendTxt"]))
75 {
76 header("Content-type: application/octet");
77 header("Content-Disposition: attachment; filename=query-result.txt");
78
79 PrintPage("0", $host, $user, $pw, $db, "", "");
80 }
81 else
82 {
83 echo (file_get_contents("index-header.html"));
84
85 $environment = sizeof($_GET);
86
87 PrintForm($_GET);
88
89 if ($environment==0)
90 printf("No query submitted yet.<BR>");
91 else
92 PrintPage("1", $host, $user, $pw, $db, "", "");
93
94 echo (file_get_contents("index-footer.html"));
95 }
96
97 ini_set("display_errors", "Off");
98 ini_set("mysql.trace_mode", "Off");
99}
100?>
Note: See TracBrowser for help on using the repository browser.