UPDATE problem with $_GET...[HELP!!]

wendymelon

I'm having problem with the UPDATE query. After some debugging I found out that it's because of the $_GET variable....however, I had tried the solution provided from other threads and still couldn't solve the problem.... Can anybody help me out..PLEASE...

Below are my code:

<?
#$eID = $_GET['empID'];
#$dayOT = $_GET['OTDateDay'];
#$monthOT = $_GET['OTDateMonth'];
#$yearOT = $_GET['OTDateYear'];
#$tStart = $_GET['OTStartTime'];
 if (isset($_POST['btnUpdate'])){
     if((!empty($_POST['OT_Rate'])) && (!empty($_POST['StartTime'])) && (!empty($_POST['EndTime'])) && (!empty($_POST['reason']))){
         ECHO "HELLO";
         $eID = $_POST['empID'];
         $dayOT = $_POST['OTDateDay'];
         $monthOT = $_POST['OTDateMonth'];
         $yearOT = $_POST['OTDateYear'];
         $tStart = $_POST['OTStartTime'];
         echo '<br>'.$eID;
         echo '<br>'.$dayOT ;
         echo '<br>'.$monthOT;
         echo '<br>'.$yearOT;
         echo '<br>'.$tStart;
         echo '<br>'.$_POST['OT_Rate'];
         echo '<br>'.$_POST['StartTime'];
         echo '<br>'.$_POST['EndTime'];
         echo '<br>'.$_POST['reason'];
         $updateQuery = "UPDATE application SET OT_Rate='".$_POST['OT_Rate']."', Time_Start='".$_POST['StartTime']."00', Time_End='".$_POST['EndTime']."00', Reason='".$_POST['reason']."' WHERE Emp_ID='".$eID."' AND Date_OT='".$yearOT."-".$monthOT."-".$dayOT."' AND Time_Start='".$tStart."00'";
         mysql_query($updateQuery);
         #header("Location: AdminViewNotYetApproved.php");
     }Else{
         echo '<script language=Javascript>alert("Please enter all required information")</script>';
     }

 }

?>
<html>
<head>
<title>Title here!</title>
</head>
<body bgcolor="#D6D6AD" link="#0000FF" text="#000000" alink="#FF0000" vlink="#FF00FF">

<table bgcolor="#800000" width="100%" border="" bordercolor="#000000">
<tr height="50"><td>
<p><font size="6" color="#FFFFFF"><b>Employee Overtime Application Form</b></font></p>
</td></tr></table>
<?
     echo '<form method="POST" action="Edit_OT.php?eID='.$_GET['empID'].'&dayOT='.$_GET['OTDateDay'].'&monthOT='.$_GET['OTDateMonth'].'&yearOT='.$_GET['OTDateYear'].'&tStart='.$_GET['OTStartTime'].'" name="HODApplyfrm">';

 echo '<font size="4"><b>Employee :&nbsp&nbsp&nbsp&nbsp&nbsp</b></font>';
 echo '<font size ="3"><b>'.$_GET['empID'];
 echo '&nbsp&nbsp&nbsp&nbsp&nbsp'.$_GET['empName'].'</b></font>';
 #echo '<br>';
 #echo '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
 #&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp'.$_GET['empName'].'</font>';


 echo '<br>';
 echo '<font size="4"><b>OT Rate : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></font>';
 echo '<select name="OT_Rate" id="OT_Rate">';
 $query2 = "SELECT OT_Rate from Application WHERE Emp_ID='".$_GET['empID']."' and Date_OT='".$_GET['OTDateYear']."-".$_GET['OTDateMonth']."-".$_GET['OTDateDay']."' and Time_Start = '".$_GET['OTStartTime']."00'";
 $result2 = mysql_query($query2);
 while($row2 = mysql_fetch_array($result2,MYSQL_NUM)){
     echo '<option value="'.$row2[0].'" selected>'.$row2[0].'</option>';
 }
 $query3 = "SELECT * FROM otcode;";
 $result3= mysql_query($query3);
 while($rate = mysql_fetch_array($result3,MYSQL_NUM)){
     echo '<option value="'.$rate[0].'">'.$rate[0].'</option>';
 }
 echo '</select>'
?>
<font size="4"><b>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp OT Date : &nbsp&nbsp</b></font>
<font size="3"><b>
<?php
     checkMonth($_GET['OTDateMonth']);
     echo $_GET['OTDateDay'].'&nbsp&nbsp&nbsp'.$mon2 .'&nbsp&nbsp&nbsp'.$_GET['OTDateYear'];
     $query4 = "SELECT HOUR(Time_End),MINUTE(Time_End), Reason from Application WHERE Emp_ID='".$_GET['empID']."' and Date_OT='".$_GET['OTDateYear']."-".$_GET['OTDateMonth']."-".$_GET['OTDateDay']."' and Time_Start = '".$_GET['OTStartTime']."00'";
     $result4 = mysql_query($query4);
     while($row4 = mysql_fetch_array($result4)){
         $ETime = str_pad($row4[0],2,"0",STR_PAD_LEFT). str_pad($row4[1],2,"0",STR_PAD_LEFT);
         $Rsn = $row4[2];
     }
     ?></b> </font>


  <br>
  <font size="4"><b>Start Time : &nbsp&nbsp</font>
  <input type="text" maxlength="4" value="<?echo $_GET['OTStartTime']?>" name="StartTime" size="3"></input>
  &nbspHHMM&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
  <font size="4">End Time : &nbsp&nbsp</font>
  <input type="text" maxlength="4" value="<?echo $ETime?>" name="EndTime" size="3"></input>&nbspHHMM
  <br>
  <font size="4">Reason : &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
  <textarea name="reason" wrap="HARD"  rows="3"><?echo $Rsn?></textarea>
  <br>
  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
  &nbsp&nbsp&nbsp&nbsp&nbsp
  <input type=submit name="btnUpdate" id="btnUpdate" value="Update" style="BACKGROUND: #B1724B; BORDER-BOTTOM: #444444  2px solid; BORDER-LEFT:  #444444 2px solid; BORDER-RIGHT: #444444 2px solid; BORDER-TOP: #444444 2px solid; CURSOR: hand; FONT-FAMILY: verdana,arial,helvetica;color:#FFFFFF;font-weight:bold;HEIGHT: 25px; WIDTH: 100px">
  </form>
  </body>
  </html>

TheDefender

It would be in your best interest to continue your posts on your other threads... Looking through your post history, you have a habit of not responding to the help we have been giving you in the past. We have no idea how to help you out if you don't continue your threads... I for one, don't feel like looking through your other threads to figure out what kind of troubleshooting you have done so far.

Now, in relation to this post here, can you expand on what you mean by this please?

After some debugging I found out that it's because of the $_GET variable....however, I had tried the solution provided from other threads and still couldn't solve the problem....

And this time, let's keep it in this post here instead of starting a new one OK?

wendymelon

I tried echoing the $_GET variable...apparently, it does not contain any value. Therefore, the UPDATE query is not complete.

TheDefender

OK, so if you echo the $_GET['variablenamehere'] and it is empty, then we need to look at where you are sending those GET variables from...

Since $_GET array is the variables in the URL
http://www.whatever.com/page.php?variable1=1&variable2=hello&variable3=you

Then:
$GET['variable1'] = 1
$GET['variable2'] = hello
$_GET['variable3'] = you

So look in your URL and see if the variables are there. If not, then look at the page you are calling this page from, and check to see if the variables are being sent properly...

wendymelon

the sending of $_GET variable is send to this page successfully because I had display the values in the textboxes/options.

TheDefender

the sending of $_GET variable is send to this page successfully because I had display the values in the textboxes/options.

Obviously not, if you can't echo them out...

So they do show up in the URL then? If that's the case, then if you do this:

echo $_GET['empID'];

Then it should display the value for it... And that should be the case for all of your GET variables. But, you said it won't, so is it one particular variable that isn't displaying or what?

wendymelon

when this page is redirected, I had displayed all the $_GET value in the textbox,...

So, when the UPDATE occur, I want to use the $_GET value in the WHERE clause.

I had tried to use ECHO to debug and test the $_GET value for each of the attribute in the db. However, it didn't return any value to me.

If it does return the correct of $GET value, then I know that the problem is not caused by the $GET values.

TheDefender

OK, so post the code where this redirect occurs... The problem is that your GET values aren't being sent correctly... Also, post the exact URL that is being called so we can see if the GET variables are even there.

wendymelon

The FIrst Page contain the redirect code(AdminViewNotYetApproved):

echo '<td align="center"><font size="2.5" color="#0000FF"><a href="Edit_OT.php?empID='.$row[0].'&empName='.$row[1].'&OTDateYear='.$_POST['year_to'].'&OTDateMonth='.$_POST['month_to'].'&OTDateDay='.$_POST['day_to'].'&OTStartTime='. str_pad($SH,2,"0",STR_PAD_LEFT). str_pad($SM,2,"0",STR_PAD_LEFT).'">Edit</a></font></td>';

The URL that redirect(Edit_OT.php):

<?php
include('connect2db.php');

 function checkMonth($monthfrom){
          global $mon2;
         If($monthfrom == 1){
             $mon2="January";
     }elseif($monthfrom==2){
             $mon2="February";
     }elseif($monthfrom==3){
         $mon2 = "March";
     }elseif($monthfrom==4){
         $mon2 = "April";
     }elseif($monthfrom==5){
         $mon2 = "May";
     }elseif($monthfrom==6){
          $mon2 = "June";
     }elseif($monthfrom==7){
          $mon2 = "July";
     }elseif($monthfrom==8){
          $mon2 = "August";
     }elseif($monthfrom==9){
          $mon2 = "September";
     }elseif($monthfrom==10){
          $mon2 = "October";
     }elseif($monthfrom==11){
          $mon2 = "November";
     }elseif($monthfrom==12){
          $mon2 = "December";
     }
 }
$eID = $_GET['empID'];
$dayOT = $_GET['OTDateDay'];
$monthOT = $_GET['OTDateMonth'];
$yearOT = $_GET['OTDateYear'];
$tStart = $_GET['OTStartTime'];
 if (isset($_POST['btnUpdate'])){
     if((!empty($_POST['OT_Rate'])) && (!empty($_POST['StartTime'])) && (!empty($_POST['EndTime'])) && (!empty($_POST['reason']))){
         ECHO "HELLO";
         echo '<br>'.$eID;
         echo '<br>'.$dayOT ;
         echo '<br>'.$monthOT;
         echo '<br>'.$yearOT;
         echo '<br>'.$tStart;
         echo '<br>'.$_POST['OT_Rate'];
         echo '<br>'.$_POST['StartTime'];
         echo '<br>'.$_POST['EndTime'];
         echo '<br>'.$_POST['reason'];
         echo '<br><br>';
         $eID = $_POST['empID'];
         $dayOT = $_POST['OTDateDay'];
         $monthOT = $_POST['OTDateMonth'];
         $yearOT = $_POST['OTDateYear'];
         $tStart = $_POST['OTStartTime'];
         echo '<br>'.$eID;
         echo '<br>'.$dayOT ;
         echo '<br>'.$monthOT;
         echo '<br>'.$yearOT;
         echo '<br>'.$tStart;
         echo '<br>'.$_POST['OT_Rate'];
         echo '<br>'.$_POST['StartTime'];
         echo '<br>'.$_POST['EndTime'];
         echo '<br>'.$_POST['reason'];
         $updateQuery = "UPDATE application SET OT_Rate='".$_POST['OT_Rate']."', Time_Start='".$_POST['StartTime']."00', Time_End='".$_POST['EndTime']."00', Reason='".$_POST['reason']."' WHERE Emp_ID='".$_POST['eID']."' AND Date_OT='".$_POST['yearOT']."-".$_POST['monthOT']."-".$_POST['dayOT']."' AND Time_Start='".$_POST['tStart']."00'";
         mysql_query($updateQuery);
         #header("Location: AdminViewNotYetApproved.php");
     }Else{
         echo '<script language=Javascript>alert("Please enter all required information")</script>';
     }

 }

?>
<html>
<head>
<title>Title here!</title>
</head>
<body bgcolor="#D6D6AD" link="#0000FF" text="#000000" alink="#FF0000" vlink="#FF00FF">


<table bgcolor="#800000" width="100%" border="" bordercolor="#000000">
<tr height="50"><td>
<p><font size="6" color="#FFFFFF"><b>Employee Overtime Application Form</b></font></p>
</td></tr></table>
<?
     echo '<form method="POST" action="Edit_OT.php?eID='.$_GET['empID'].'&dayOT='.$_GET['OTDateDay'].'&monthOT='.$_GET['OTDateMonth'].'&yearOT='.$_GET['OTDateYear'].'&tStart='.$_GET['OTStartTime'].'" name="HODApplyfrm">';

 echo '<font size="4"><b>Employee :&nbsp&nbsp&nbsp&nbsp&nbsp</b></font>';
 echo '<font size ="3"><b>'.$_GET['empID'];
 echo '&nbsp&nbsp&nbsp&nbsp&nbsp'.$_GET['empName'].'</b></font>';
 #echo '<br>';
 #echo '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
 #&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp'.$_GET['empName'].'</font>';


 echo '<br>';
 echo '<font size="4"><b>OT Rate : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></font>';
 echo '<select name="OT_Rate" id="OT_Rate">';
 $query2 = "SELECT OT_Rate from Application WHERE Emp_ID='".$_GET['empID']."' and Date_OT='".$_GET['OTDateYear']."-".$_GET['OTDateMonth']."-".$_GET['OTDateDay']."' and Time_Start = '".$_GET['OTStartTime']."00'";
 $result2 = mysql_query($query2);
 while($row2 = mysql_fetch_array($result2,MYSQL_NUM)){
     echo '<option value="'.$row2[0].'" selected>'.$row2[0].'</option>';
 }
 $query3 = "SELECT * FROM otcode;";
 $result3= mysql_query($query3);
 while($rate = mysql_fetch_array($result3,MYSQL_NUM)){
     echo '<option value="'.$rate[0].'">'.$rate[0].'</option>';
 }
 echo '</select>'
?>
<font size="4"><b>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp OT Date : &nbsp&nbsp</b></font>
<font size="3"><b>
<?php
     checkMonth($_GET['OTDateMonth']);
     echo $_GET['OTDateDay'].'&nbsp&nbsp&nbsp'.$mon2 .'&nbsp&nbsp&nbsp'.$_GET['OTDateYear'];
     $query4 = "SELECT HOUR(Time_End),MINUTE(Time_End), Reason from Application WHERE Emp_ID='".$_GET['empID']."' and Date_OT='".$_GET['OTDateYear']."-".$_GET['OTDateMonth']."-".$_GET['OTDateDay']."' and Time_Start = '".$_GET['OTStartTime']."00'";
     $result4 = mysql_query($query4);
     while($row4 = mysql_fetch_array($result4)){
         $ETime = str_pad($row4[0],2,"0",STR_PAD_LEFT). str_pad($row4[1],2,"0",STR_PAD_LEFT);
         $Rsn = $row4[2];
     }
     ?></b> </font>


  <br>
  <font size="4"><b>Start Time : &nbsp&nbsp</font>
  <input type="text" maxlength="4" value="<?echo $_GET['OTStartTime']?>" name="StartTime" size="3"></input>
  &nbspHHMM&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
  <font size="4">End Time : &nbsp&nbsp</font>
  <input type="text" maxlength="4" value="<?echo $ETime?>" name="EndTime" size="3"></input>&nbspHHMM
  <br>
  <font size="4">Reason : &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
  <textarea name="reason" wrap="HARD"  rows="3"><?echo $Rsn?></textarea>
  <br>
  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
  &nbsp&nbsp&nbsp&nbsp&nbsp
  <input type=submit name="btnUpdate" id="btnUpdate" value="Update" style="BACKGROUND: #B1724B; BORDER-BOTTOM: #444444  2px solid; BORDER-LEFT:  #444444 2px solid; BORDER-RIGHT: #444444 2px solid; BORDER-TOP: #444444 2px solid; CURSOR: hand; FONT-FAMILY: verdana,arial,helvetica;color:#FFFFFF;font-weight:bold;HEIGHT: 25px; WIDTH: 100px">
  </form>
  </body>
  </html>

kmunk

Try to give us the URL - and what the page prints.
First off, in your UPDATE Query you don't use $GET but $POST meaning that it can't be your $_GET messing up your update.
Since you don't submit a form, you must be using headers to set your post values or there aren't any.

Which is it ?

do you even enter your controls ?
try echo something to ensure that you get in the loops you are supposed to.