source: trunk/www/db_po/get_date.php@ 11553

Last change on this file since 11553 was 11502, checked in by Daniela Dorner, 14 years ago
added (script to get pulldown with date)
  • Property svn:executable set to *
File size: 3.6 KB
Line 
1<?php
2{
3 ini_set("display_errors", "On");
4 ini_set("mysql.trace_mode", "On");
5
6 if (empty($_GET["fDateValue"]))
7 {
8 echo "Please give the date value.<br>";
9 return;
10 }
11 if (empty($_GET["fDateName"]))
12 {
13 echo "Please give the date name.<br>";
14 return;
15 }
16 if (empty($_GET["fIdx"]))
17 {
18 echo "Please give the idx.<br>";
19 return;
20 }
21 if (empty($_GET["fDateValuePrev"]))
22 $_GET["fDateValuePrev"]="";
23
24 include("db.php");
25 $db_id = mysql_pconnect($host, $user, $pw);
26 if ($db_id==FALSE)
27 {
28 printf("mysql_connect returned the following error: %s\n", mysql_error());
29 die("");
30 }
31 mysql_select_db($db);
32
33 if (strcmp("year",$_GET["fDateName"])==0)
34 {
35 $identifier1="";
36 $identifier2="Y";
37 $newdatename="month";
38 if (strcmp($_GET["fDateValue"],"empty")==0)
39 $_GET["fDateValue"]="all";
40 if (strcmp($_GET["fDateValuePrev"],"empty")==0)
41 $_GET["fDateValuePrev"]="all";
42 }
43 if (strcmp("month",$_GET["fDateName"])==0)
44 {
45 $identifier1="Y";
46 $identifier2="m";
47 $newdatename="day";
48 }
49 if (strcmp("day",$_GET["fDateName"])==0)
50 {
51 $identifier1="m";
52 $identifier2="d";
53 $newdatename="hour";
54 }
55 if (strcmp("hour",$_GET["fDateName"])==0)
56 {
57 $identifier1="d";
58 $identifier2="H";
59 $newdatename="min";
60 }
61 if (strcmp("min",$_GET["fDateName"])==0)
62 {
63 $identifier1="H";
64 $identifier2="i";
65 $newdatename="sec";
66 }
67 if (strcmp("sec",$_GET["fDateName"])==0)
68 {
69 $identifier1="i";
70 $identifier2="s";
71 $newdatename="";
72 }
73
74 if (strcmp($_GET["fDateValuePrev"],"empty")!=0)
75 {
76 $query0 ="SELECT ";
77 $query0.=" Date_Format(fValidFrom, '%". $identifier2."') as valid ";
78 $query0.=" FROM History ";
79 if (empty($identifier1))
80 $query0.=" WHERE NOT fValidFrom='0000-00-00 00:00:00' ";
81 else
82 $query0.=" WHERE Date_Format(fValidFrom, '%". $identifier1."')=".$_GET["fDateValuePrev"];
83 $query0.=" GROUP BY valid";
84 $result0=mysql_query($query0, $db_id);
85 }
86 //echo $_GET["fDateValuePrev"];
87
88 //echo $query0;
89 if (empty($newdatename))
90 printf("<select id='%s%d'>\n", $_GET["fDateName"], $_GET["fIdx"]);
91 else
92 {
93 //if (empty($identifier1))
94 //{
95 printf("<select id='%s%d' onchange=\"get_dates('%s', this.value, this.value, %d, 'yes')\">\n",
96 $_GET["fDateName"], $_GET["fIdx"], $newdatename, $_GET["fIdx"]);
97 //}
98 //else
99 //{
100 // printf("<select id='%s%d' onchange=\"get_dates('%s', this.value, '%s', %d, 'yes')\">\n",
101 // $_GET["fDateName"], $_GET["fIdx"], $newdatename, $_GET["fDateValuePrev"], $_GET["fIdx"]);
102 //}
103 }
104 if (strcmp($_GET["fDateValue"],"empty")!=0)
105 printf("<option value='empty'>%s</option>\n", $_GET["fDateName"]);
106 else
107 printf("<option value='empty'>-</option>\n");
108 if (strcmp($_GET["fDateValuePreV"],"empty")!=0)
109 {
110 while ($row0 = mysql_fetch_row($result0))
111 {
112 if (strcmp($row0[0],$_GET["fDateValue"])==0)
113 printf("<option value='%s' selected>%s </option>\n", $row0[0], $row0[0]);
114 else
115 printf("<option value='%s'>%s </option>\n", $row0[0], $row0[0]);
116 }
117 mysql_free_result($result0);
118 }
119 printf("</select>\n");
120
121 mysql_close($db_id);
122
123 ini_set("display_errors", "Off");
124 ini_set("mysql.trace_mode", "Off");
125}
126?>
Note: See TracBrowser for help on using the repository browser.