i managed to reset the $_GET[fac] to $_POST[fac] passed from previous page, but for some reason when i type in a [fac] in the form it resets back to all. i do not want this to happen... can someone look at my code and tell me how to prevent this?
Expand|Select|Wrap|Line Numbers
- <html>
- <STYLE type="text/css">
- TD{font-family:ARIAL;font-size:11px;color:#666666;}
- BODY{font-family:ARIAL;font-size:11px;color:#666666;background-color:#eeeeee;margin-top:40px;margin-bottom:0px;margin-left:40px;margin-right:0px;}
- FORM{display:inline;}
- A:LINK, A:VISITED{color:#6699cc;text-decoration:none;}
- A:HOVER{text-decoration:underline;color:#CCCCCC;}
- .HOMETEXT{font-size:14px;}
- .ITEMNAME{font-size:14px;font-weight:BOLD;}
- /*.WHITELINK{color:#ffffff;font-size:10px;}*/
- .INPUT{border-color:#66CCFF;border-width:1px;border-style:solid;background-color:#eeeeee;font-size:10px;}
- .INPUT2{background-image:url(webtd_grass_matrix_pic4.jpg);color:#666666;border-top:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;border-right:1px solid #BBBBBB; border-left:1px solid #BBBBBB; font-family:copperplate gothic light;font-size:7pt;}
- .BUTTON{border-color:#99CCFF;border-width:1px;border-style:solid;}
- .BOLD{color:#666666;font-family:Arial, Tahoma, Helvetica, sans-serif;font-size:8pt;font-weight:BOLD;}
- .BOLDLARGE{color:#666666;font-size:12pt;font-weight:BOLD;}
- .CURRENTPAGE{color:#666666;font-size:8pt;font-weight:BOLD;}
- .ERROR{color:#cc0033;font-size:8pt;font-weight:BOLD;}
- .MENUCELL{height:24px;width:80px;text-align:center;font-weight:BOLD;color:#FFFFFF;border-top:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;border-right:1px solid #BBBBBB;}
- .MENUCELLSTART{height:24px;width:80px;border:1px solid #BBBBBB;text-align:center;font-weight:BOLD;color:#FFFFFF;}
- .SPACE1{padding-left:20px;}
- .BORDER{background-color:#EEEEEE;color:#666666;border-top:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;border-right:1px solid #BBBBBB;height:24px;padding-left:16px;}
- .BORDERNEW{background-color:#EEEEEE;color:#666666;border-top:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;border-left:1px solid #BBBBBB;border-right:1px solid #BBBBBB;height:170px;padding-left:0px;}
- .BGWHITE{background-color:#FFFFFF;color:#666666;border-top:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;border-left:1px solid #BBBBBB;border-right:1px solid #BBBBBB;height:170px;padding-left:20px;}
- .BORDER1{border-bottom:1px solid #BBBBBB;}
- .BORDER2{background-color:#EEEEEE;color:#666666;border:1px solid #BBBBBB;}
- .BORDER3{background-color:#000000;color:#666666;border-top:1px solid #ffffff;border-bottom:1px solid #ffffff;border-right:1px solid #ffffff;height:44px;padding-left:16px;}
- .HEADER{background-color:#EEEEEE;color:#666666;border:1px solid #BBBBBB;height:24px;font-weight:BOLD;padding-left:20px;}
- .PRODCELL{border-left:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;background-color:#FFFFFF;}
- .HEADER1{background-color:#EEEEEE;color:#666666;border-left:1px solid #BBBBBB;border-top:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;height:24px;font-weight:BOLD;padding-left:20px;}
- .HEADER5{width:130px;color:#666666;background-color:#EEEEEE;border-top:1px solid #BBBBBB;border-right:1px solid #BBBBBB;height:24px;}
- .PRODIMGLGCELL{width:300px;height:295px;background-color:#EEEEEE;border-left:1px solid #BBBBBB;border-right:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;vertical-align:top;text-align:center;}
- .PRODIMGSMCELL{width:130px;height:125px;background-color:#EEEEEE;border-left:1px solid #BBBBBB;border-right:1px solid #BBBBBB;border-bottom:1px solid #BBBBBB;vertical-align:top;text-align:center;}
- .PRODIMGSM{border:1px solid white;height:120px;width:120px;align:middle;}
- .PRODIMGLG{border:1px solid #BBBBBB;height:290px;width:290px;align:middle;}
- .CATIMG{width:120px;height:120px;border:1px solid #BBBBBB;}
- .stylegreyblue {color: #669999}
- .stylelightblue {color: ##DEE7F7}
- .styleblack {color:#000000}
- .stylegreyblack {color:#444444}
- .styledarkpink {color: #990033}
- .styleslateblue {color: #008b8b}
- .stylewhite {color: #ffffff}
- .input.btn {color:#666666; font: bold small 'trebuchet ms',helvetica,sans-serif;
- background-color: #eeeeee;
- border:1px solid;
- border-color: #66CCFF #66CCFF #66CCFF #66CCFF;
- font-size:11px;
- }
- .style17 {color: #666666}
- .style18 {color: #CC6699}
- .style19 {color: #CCCCCC}
- .style22 {font-family: Verdana; color: #CCCCCC;}
- .style23 {color: #66CCFF}
- .style24 {
- color: #99FF66;
- font-weight: bold;
- }
- .style26 {color: #99FF66}
- .style27 {color: #999999}
- .stylered {color: #FF0000}
- .stylegreen {color: #00FF00}
- </STYLE>
- </head>
- <?php
- #if(isset($_POST['submit'])) {
- #destroy_GET();
- #}
- ?>
- <?php
- if(!isset($_POST['submit']) AND ($_POST['fac'] ='ALL'))
- {
- SETTER();
- }
- else
- {
- SETTER2();
- }
- ?>
- <?php
- #function destroy_GET()
- #{
- # unset($_GET['fac']);
- #}
- ?>
- <?php
- function SETTER()
- {
- $_POST['fac'] = $_GET['fac'];
- $_POST['SRG_GROUP'] = $_GET['SRG_GROUP'];
- }
- ?>
- <?php
- function SETTER2()
- {
- echo "POST SUBMIT SET";
- #$_GET['fac'] = $_POST['fac'];
- #$_POST['fac'] = $_POST['fac'];
- #$_POST['SRG_GROUP'] = $_POST['SRG_GROUP'];
- }
- ?>
- <BODY>
- <!---
- <body background ="silverswimmer.jpg">
- -->
- <?php
- if(empty($_POST['fac']))
- {
- echo "posted fac empty";
- $count=$_GET['count'];
- $fac2= strtoupper($_GET['fac']);
- $SRG_GROUP=$_GET['SRG_GROUP'];
- $SFT=$_GET['SFT'];
- echo "passed fac is:";
- echo $_GET['fac'];
- echo "passed SRG is:";
- echo $_GET['SRG_GROUP'];
- }
- else
- {
- echo "posted fac NOT empty";
- }
- echo "<br>";
- ?>
- <table width = "600" height = "170" bordercolor = "#ffffff" border = "1" cellpadding = "0" cellspacing = "0" class = "BORDERNEW">
- <tr>
- <!---
- <td background = "ER_SIGN2_IMP0136074.JPG">
- -->
- <td background = "TOPBORDER.JPG">
- <table width = "240" height = "75" bordercolor = "#ffffff" border = "1" cellpadding = "0" cellspacing = "0" class = "border3">
- <tr bordercolor="#ffffff" bgcolor="#eeeeee" align = "center">
- <td align = "center" width = "70" bordercolor = "#eeeeee">
- <span class="stylered">
- <font face = "arial" size = "20">
- <b>ER</b>
- </font>
- </span>
- </td>
- <td align = "left" bgcolor="#808080" bordercolor = "#808080">
- <span class="stylewhite">
- <font face = "arial" size = "4">
- <b> volumes</b>
- </font>
- </span>
- </td>
- </tr>
- </table>
- <!---
- <hr align = "left" width = "800" size = 3 color = #666666>
- -->
- </td>
- </tr>
- </table>
- <?php
- print "<span class='style17'><font face = 'arial' size = '1'>";
- if(empty($_POST['fac']) AND empty($_GET['fac']))
- {
- echo "facility code: all";
- print "      ";
- echo "SRG group: " .$_GET['SRG_GROUP'];
- print "</font></span>";
- }
- elseif(empty($_POST['fac']) AND !empty($_GET['fac']))
- {
- echo "facility code GET: " .strtoupper($_GET['fac']);
- print "      ";
- echo "SRG group: " .$_GET['SRG_GROUP'];
- print "</font></span>";
- }
- else
- {
- echo "facility code POST: " .strtoupper($_POST['fac']);
- print "      ";
- echo "SRG group: " .$_POST['SRG_GROUP'];
- print "</font></span>";
- }
- ?>
- <?php
- if(empty($_POST['fac']) AND !empty($_GET['fac']))
- {
- echo "first query";
- }
- elseif(empty($_POST['fac']) AND empty($_GET['fac']))
- {
- echo "second query";
- }
- elseif(empty($_POST['fac']) AND isset($_GET['fac']) AND empty($_GET['fac']))
- {
- echo "third query";
- }
- elseif($_POST['fac'] = ALL)
- {
- echo "fourth query";
- }
- elseif($_GET['fac'] = ALL)
- {
- echo "fifth query";
- }
- else
- {
- echo "sixth query";
- }
- ?>
- <br>
- <br>
- <table width = "600" height = "170" bordercolor = "#ffffff" border = "1" cellpadding = "0" cellspacing = "0" class = "BGWHITE">
- <tr>
- <td bgcolor = "#ffffff">
- <br>
- <form method="post" action="<?php echo $PHP_SELF;?>">
- <span style='color: #008b8b; font-size: 10pt; font-family: arial'>
- <b>facility code </b><input type="text" size="12" class = "INPUT" maxlength="3" name="fac" value="<?php echo strtoupper($_POST['fac']);?>"
- </span>
- <span style='color: #008b8b; font-size: 10pt; font-family: arial'>
-   <b> SRG group </b>
- </span>
- <?php
- ########################################################
- #this dropdown remembers the values selected after form is posted
- #by processing each element as i dynamically output it
- ########################################################
- echo "<select name='SRG_GROUP' class = 'INPUT'>";
- $values =
- array
- (
- 'Charity' => 'Charity'
- , 'Insured' => 'Insured'
- , 'Other' => 'Other'
- , 'Self Pay' => 'Self Pay'
- );
- $selected = $_POST['SRG_GROUP'];
- foreach( $values as $val => $text )
- {
- echo '<option value="', htmlentities($val), '"';
- if( $val == $selected )
- {
- echo ' selected="selected"';
- }
- echo '>', htmlentities($text), '</option>';
- }
- echo "</select>";
- ?>
- <input type="submit" value=' go ' name='submit' class = 'btn'></form>
- <?php
- ########################################################
- #end of this dropdown remembers the values selected after form is posted
- #by processing each element as i dynamically output it
- ########################################################
- ?>
- <br><br>
- </td>
- </tr>
- <tr>
- <td>
- <!---
- <table width = 1000>
- <tr>
- <td>
- <img src="coniferlogo.jpg" alt="Conifer" border="0">
- </td>
- <td align = "bottom">
- <img src="grand_canyon.jpg" alt="test" border="0">
- </tr>
- </table>
- -->
- <?php
- #<img src="coniferlogo.jpg" alt="conifer">
- #################################################
- #this one lists the days of the week starting dynamically with the current day
- #along with the shift list and count after each day
- #################################################
- $fac = $_POST["fac"];
- $SRG_GROUP = $_POST["SRG_GROUP"];
- #print "<span style='color: #008b8b; font-size: 9pt; font-family: arial'><b><br>";
- #echo "faciity code: " .$fac;
- #print "</b></span><br>";
- #print "<span style='color: #008b8b; font-size: 9pt; font-family: arial'><b>";
- #echo "SRG group: " .$SRG_GROUP;
- #print "</b></span><br>";
- #print "<br>";
- ?>
- <?php
- /*
- if(empty($_POST['fac']))
- {
- print "<span style='color: #008b8b; font-size: 12pt; font-family: arial'><b>";
- echo "no facility posted from self";
- echo $_GET['fac'];
- print "</b></span><br>";
- }
- else
- {
- echo "facility posted from self";
- }
- if(empty($_POST['fac']))
- {
- echo "1";
- echo $_GET['SRG_GROUP'];
- }
- else
- {
- echo "2";
- }
- if(!empty($_GET['fac']))
- {
- echo "get not empty";
- }
- else
- {
- echo "get is empty";
- }
- if(empty($_POST['fac']) AND !empty($_GET['fac']))
- {
- echo "first query";
- }
- elseif(empty($_POST['fac']) AND !isset($_GET['fac']) AND empty($_GET['fac']))
- {
- echo "second query";
- }
- elseif(empty($_POST['fac']) AND isset($_GET['fac']) AND empty($_GET['fac']))
- {
- echo "third query";
- echo $_GET['SRG_GROUP'];
- }
- else
- {
- echo "other query";
- }
- */
- $test = array('sunday','monday','tuesday','wednesday','thursday','friday', 'saturday');
- $day=date('w'); //Numeric representation of the day of the week 0 (for Sunday) through 6 (for Saturday)
- $key=each($test);
- while ($key['key']!=$day)
- $key=each($test);
- prev($test);
- prev($test);
- for ($i=0;$i<7;$i++)
- {
- $count = (next($test)) ? current($test) : reset($test);
- #print "<br>";
- print "<span style='color: #008b8b; font-size: 12pt; font-family: arial'><b><br>";
- echo $count;
- print "<hr size = 1 width = 300 align = left color = #666666>";
- print "</b></span>";
- #print "<br>";
- #echo "<table><tr><th>shift</th><th>count</th></tr><tr><td>";
- #################################################
- #DETAIL SECTION
- #################################################
- #print "details: ";
- $conn=odbc_connect('ERVOLUMES','','');
- if (!$conn)
- {exit("Connection Failed: " . $conn);}
- #$sql="SELECT admitday, shift, infocount FROM qry_sum WHERE admitday = 'sunday'";
- #$sql="SELECT admitday, shift, infocount FROM qry_sum WHERE admitday ='".$count."'";
- if(empty($_POST['fac']) AND !empty($_GET['fac']))
- {
- $sql="SELECT admitday, shift, SRG_GROUP, infocount FROM qry_sum2 WHERE SRG_GROUP = '".$_GET['SRG_GROUP']."' AND hospitalcode LIKE '".$_GET['fac']."' AND admitday ='".$count."'";
- $sql2="SELECT sum(infocount) AS ttl FROM qry_sum WHERE SRG_GROUP = '".$_GET['SRG_GROUP']."' AND hospitalcode LIKE '".$_GET['fac']."' AND admitday ='".$count."'";
- $sql3="SELECT sum(infocount) AS ttl_GRAND FROM qry_sum WHERE SRG_GROUP = '".$_GET['SRG_GROUP']."' AND hospitalcode LIKE '".$_GET['fac']."'";
- }
- elseif(empty($_POST['fac']) AND empty($_GET['fac']))
- {
- $sql="SELECT admitday, shift, SRG_GROUP, infocount FROM qry_sum3 WHERE SRG_GROUP = '".$SRG_GROUP."' AND admitday ='".$count."'";
- $sql2="SELECT sum(infocount) AS ttl FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode IS NOT NULL AND admitday ='".$count."'";
- $sql3="SELECT sum(infocount) AS ttl_GRAND FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode IS NOT NULL";
- }
- elseif(empty($_POST['fac']) AND isset($_GET['fac']) AND empty($_GET['fac']))
- {
- #$sql="SELECT admitday, shift, SRG_GROUP, infocount FROM qry_sum3 WHERE SRG_GROUP LIKE '".$_GET['SRG_GROUP']."' AND admitday ='".$count."'";
- $sql="SELECT admitday, shift, SRG_GROUP, infocount FROM qry_sum3 WHERE SRG_GROUP = '".$SRG_GROUP."' AND admitday ='".$count."'";
- $sql2="SELECT sum(infocount) AS ttl FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode IS NOT NULL AND admitday ='".$count."'";
- $sql3="SELECT sum(infocount) AS ttl_GRAND FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode IS NOT NULL";
- }
- elseif($_POST['fac'] = "ALL")
- {
- $sql="SELECT admitday, shift, SRG_GROUP, infocount FROM qry_sum3 WHERE SRG_GROUP = '".$SRG_GROUP."' AND admitday ='".$count."'";
- $sql2="SELECT sum(infocount) AS ttl FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode IS NOT NULL AND admitday ='".$count."'";
- $sql3="SELECT sum(infocount) AS ttl_GRAND FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode IS NOT NULL";
- }
- else
- {
- $sql="SELECT admitday, shift, SRG_GROUP, infocount, hospitalcode FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode LIKE '".$fac."' AND admitday ='".$count."'";
- $sql2="SELECT sum(infocount) AS ttl FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode LIKE '".$fac."' AND admitday ='".$count."'";
- $sql3="SELECT sum(infocount) AS ttl_GRAND FROM qry_sum WHERE SRG_GROUP = '".$SRG_GROUP."' AND hospitalcode LIKE '".$fac."'";
- }
- $rs=odbc_exec($conn,$sql);
- $rs2=odbc_exec($conn,$sql2);
- $rs3=odbc_exec($conn,$sql3);
- $TTLS=odbc_result($rs2, ttl);
- print "<span class='style17'><font face = 'arial' size = '1'>";
- echo number_format($TTLS);
- print "  total     |     </font></span>";
- print "</font></span>";
- print "<span class='style17'><font face = 'arial' size = '1'><b>";
- if(empty($_POST['fac']))
- {
- echo "<a href = 'REC.php?count=$count&fac=$_GET[fac]&SRG_GROUP=$_GET[SRG_GROUP]'>VIEW DETAILS</a>";
- }
- else
- {
- echo "<a href = 'REC.php?count=$count&fac=$fac&SRG_GROUP=$SRG_GROUP'>VIEW DETAILS</a>";
- }
- print "</b></font></span>";
- print "<br>";
- if (!$rs)
- {exit("Error in SQL");}
- while (odbc_fetch_row($rs))
- {
- $SFT=odbc_result($rs, shift);
- $BER=odbc_result($rs, infocount);
- $TTLGRAND=odbc_result($rs3, ttl_GRAND);
- #$TEST = numrows($rs);
- echo "<br><table width = '250' height = '10' align = 'left' border = '0'><tr height = '10'><td width = '200' height = '10'>";
- print "<span style='color: #666666; font-size: 9pt; font-family: arial'>";
- #echo $SFT;
- if(empty($_POST['fac']))
- {
- echo "<a href = 'REC.php?count=$count&fac=$_GET[fac]&SRG_GROUP=$_GET[SRG_GROUP]&SFT=$SFT'>$SFT</a>";
- }
- else
- {
- echo "<a href = 'REC.php?count=$count&fac=$fac&SRG_GROUP=$SRG_GROUP&SFT=$SFT'>$SFT</a>";
- }
- print "</span>";
- echo "</td><td width = '50'>";
- print "<span style='color: #666666; font-size: 9pt; font-family: arial'>";
- echo number_format($BER);
- print "</span>";
- #print "<br>";
- echo "</td></tr></table></br>";
- }
- #################################################
- # END OF DETAIL SECTION
- #################################################
- print "<br>";
- #echo $count.'<br />';
- }
- print "<br>";
- print "<tr><td bgcolor = '#000000' bordercolor = '#000000'><span style='color: #008b8b; font-size: 12pt; font-family: arial'><br><b>";
- echo "grand total: " .number_format($TTLGRAND);
- print "<br><br></td></tr></b></span>";
- #echo $TEST;
- ?>
- <br></td>
- </tr>
- </table>
- <br>
- <br>
- </html>
geebee