resetting to ALL

geraldjr30
New Member
Join Date: Jan 2009
Posts: 60
Feb 11 '09, 08:28 PM
hi,

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?
Code:
<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 "&nbsp &nbsp &nbsp ";
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 "&nbsp &nbsp &nbsp ";
echo "SRG group: " .$_GET['SRG_GROUP'];
print "</font></span>";
}
else
{
echo "facility code POST: " .strtoupper($_POST['fac']);
print "&nbsp &nbsp &nbsp ";
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'>
&nbsp <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 "&nbsp total &nbsp &nbsp | &nbsp &nbsp </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>
thanks in advance,
geebee
Tags: None
hoopy

New Member

Join Date: Feb 2009

Posts: 88
#2

Feb 11 '09, 08:48 PM

I thnk it relates to your conditional statement on your other post.

Try with that fix and see if it works.
Comment
Markus

Recognized Expert Expert

Join Date: Jun 2007

Posts: 6092
#3

Feb 11 '09, 08:56 PM

As a general note, post only the code that relates to the question; I for one ain't going to sit here and sift through that code to find an obscure error.
Comment
hoopy

New Member

Join Date: Feb 2009

Posts: 88
#4

Feb 11 '09, 09:08 PM

Agreed. When you have a bug like this, you can debug it easily enough yourself by echoing variables to the output at different stages until you find the general area of where the issues are occuring.
Comment
Previous template Next
resetting to ALL

resetting to ALL

Comment

Comment

Comment
