[Resolved] Page is update when refresh TWICE??WHY??

wendymelon

I have a table containing some records. Each record contains a CHECKBOX to determine the DELETE.

When I have ticked the CHECKBOX, and PRESS the button DELETE, the page refresh but the record still remains in the table.

WHen i PRESS the button DELETE again(without ticking the CHECKBOX), the page refresh. ONLY THIS TIME the record is deleted from the table.

What is causing this problem??

Can anybody help me out?

devinemke

sounds like you are doing the delete after your page display. post some code.

wendymelon

<?php session_start();
global $position;
function checkMonth($monthfrom)
     {
         global $mon;
         If($monthfrom == 1){
             $mon="January";
     }elseif($monthfrom==2){
             $mon="February";
     }elseif($monthfrom==3){
         $mon = "March";
     }elseif($monthfrom==4){
         $mon = "April";
     }elseif($monthfrom==5){
         $mon = "May";
     }elseif($monthfrom==6){
          $mon = "June";
     }elseif($monthfrom==7){
          $mon = "July";
     }elseif($monthfrom==8){
          $mon = "August";
     }elseif($monthfrom==9){
          $mon = "September";
     }elseif($monthfrom==10){
          $mon = "October";
     }elseif($monthfrom==11){
          $mon = "November";
     }elseif($monthfrom==12){
          $mon = "December";
     }
}
?>


<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>
<form method="POST" action="<? echo $_SERVER['PHP_SELF']?>" name="HODApplyfrm">
<?php
     include('connect2db.php');
     $query = "SELECT employee.Emp_ID, employee.Emp_Name from employee,supervisor WHERE employee.Supervisor_ID = supervisor.Supervisor_ID and supervisor.Supervisor_ID ='". $_SESSION['Department']."'";
     $result = mysql_query($query);
     echo '<font size="4"><b>Employee :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></font>';
     echo '<input type="text" style="width: 100px; value="" name="emID" id="emID" ></input>';
     echo '<select name="eName" id="eName" style="width: 250px;" onchange="\javascript:document.HODApplyfrm.emID.value = document.HODApplyfrm.eName.options[document.HODApplyfrm.eName.selectedIndex].value">';
     echo '<option></option>';
     while($row = mysql_fetch_array($result,MYSQL_NUM)){
         echo '<font size="1">';
         echo '<option value="'.$row[0].'">'.$row[1].'</option>';
         echo '</font>';

 }
 echo '</select>';
 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">';
 $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"><bOT Date :</b></font>

<?PHP
	$today = getdate();
 $setday = $today['mday'];
 $setmonth = $today['month'];
  $setmonth = substr($setmonth, 0, 3);
 $setnomonth = $today['mon'];
 $setyear = $today['year'];
	 ?>
      <select name="day_from" id="day_from">
        <option value="<? echo $setday ?>" selected><? echo $setday ?></option>
        <option value="1">1</option>
              </select> <select name="month_from" id="month_from">
        <option value="<? echo $setnomonth?>" selected><? echo $setmonth ?></option>
        <option value="1">Jan</option>
        ........................
        ........................
        ........................
        ........................
      </select> <input name="year_from" type="text" id="year_from" value ="<? echo $setyear ?>" size="4">
      <br>
      <font size="4"><b>Start Time : &nbsp&nbsp</font>
      <input type="text" maxlength="4" name="StartTime" size="3"></input>
HHMM<font size="4">End Time : &nbsp&nbsp</font>
      <input type="text" maxlength="4" 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"></textarea>
      <br>

  <input type=submit name="btnAdd" id="btnAdd" value="Add" 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">
  <br><hr>
  <table align="center" name="table01" bgcolor="#CFCFCF" width="100%" border=3 bordercolor="#000000" cellpadding="0" cellspacing="3">
   <tr height="20" bgcolor="#B1724B" align="center" id="row01">
        <td width="5%" align="center" >
             <font size="4" color="#FFFFFF"><b>ID&nbsp&nbsp;</b></font>
        </td>
        <td width="25%" align="center">
             <font size="4" color="#FFFFFF"><b>Name&nbsp&nbsp;</b></font>
        </td>
        <td width="9%" align="center">
             <font size="4" color="#FFFFFF"><b>Time&nbsp&nbsp;</b></font>
        </td>
        <td width="9%" align="center">
             <font size="4" color="#FFFFFF"><b>OT Date&nbsp&nbsp;</b></font>
        </td>
        <td width="4%" align="center">
             <font size="4" color="#FFFFFF"><b>Delete?&nbsp&nbsp;</b></font>
        </td>
  </tr>
  <?
  $query6 = "SELECT Emp_ID, Emp_Name,HOUR(Time_Start),MINUTE(Time_Start), HOUR(Time_End),MINUTE(Time_End), DAYOFMONTH(Date_OT),MONTHNAME(Date_OT),YEAR(Date_OT) from Approval";
  $result6 = mysql_query($query6);
  while ($row6 = mysql_fetch_array($result6,MYSQL_NUM)){
      echo '<tr bgcolor="#FFFFD7" bordercolor="#FFFFD7">
      <td><font size="2.5">'.$row6[0].'</font></td>';
      echo '<td><font size="2.5">'.$row6[1].'</font></td>';
      echo '<td><font size="2.5">'. str_pad($row6[2],2,"0",STR_PAD_LEFT). str_pad($row6[3],2,"0",STR_PAD_LEFT).' - '.str_pad($row6[4],2,"0",STR_PAD_LEFT). str_pad($row6[5],2,"0",STR_PAD_LEFT).'</font></td>';
      echo '<td><font size="2.5">'.$row6[6].' ' .$row6[7].' '.$row6[8].'</font></td>';
      echo '<td align="center"><input type="checkbox" name="delete[]" value="'.$row6[0].''. str_pad($row6[2],2,"0",STR_PAD_LEFT).''. str_pad($row6[3],2,"0",STR_PAD_LEFT).'"></input></td>
      </tr>';

  }

        }
  if(isset($_POST['btnDelete'])){
      foreach ($_POST['delete'] as $value){
              $emp = substr($value,0,-4);
              $str = substr($value,-4);
              $delQuery = "Delete from Approval where Emp_ID = '".$emp."' and Time_Start='".$str."00'";
              mysql_query($delQuery);
      }
  }
          ?>
  </table>
  <br>
        <input type=submit name="btnDelete" id="btnDelete" value="Delete" 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">
  <input type=submit name="btnDone" id="btnDone" value="Done" 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>

devinemke

just as i suspected. your DELETE query is all the way at the bottom after all of your select queries. therefore when you hit "delete" you are first pulling (as displaying) the old record that is about to be deleted.

wendymelon

So, how should I arrange the codes? When I put the ISSET(btnDELETE) on top of the HTML codes, The delete function does not work at all.

wendymelon

I found out that if I click DELETE for the first item, it will be remove from the table.

If i click DELETE for the item beneath it, the item will be MOVED to the first row. Therefore, since it's the first row, then I can remove it from the table.

Why does this occur?

wendymelon

After much try and error, I managed to solve this problem...those who has these below error:

DELETE from database but when the page refresh, the record is still in the table
When DELETE from database occur, it only manage to delete a few records which the checkbox is ticked.

SOLUTION:

put the IF(DELETE) and IF(ADD) before the HTML codes. Just include the SQL query in both the IF structure.......

Then from the HTML codes. retrieve the information from database to be displayed.

Therefore, when the button is click/submit, the queries is done before the display in HTML....So, when the display occur, the information has been updated in the database

😉

Thanks everybody!!