Why does the $_POST not executed?

[wendymelon]

Why isn't the $_POST['btnApproveAll'] does not execute?

The database connection is in the include('AdminOTNotYet.php').

My code is as below:

else if(isset($_POST['btnNotYetApproved']))
   {
       include('DateTo.php');
       echo '<table bgcolor="#CFCFCF" width="100%" border=3 bordercolor="#000000" cellpadding="0" cellspacing="3">';
       echo '<tr bgcolor="#B1724B">';
            echo '<td colspan="2">';
                 echo '<font size="4" color="#FFFFFF"><b>Supervisor ID:&nbsp&nbsp;</b></font>';
            echo '</td>';
            echo '<td colspan="6">';
                 echo '<font size="4" color="#FFFFFF"><b>Record:&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&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp';
                 echo '<input type="submit" name="btnApproveAll" id="btnApproveAll" value="Approve All" style="BACKGROUND:#D6D6AD; BORDER-BOTTOM: #000000  2px solid; BORDER-LEFT:  #000000 2px solid; BORDER-RIGHT: #000000 2px solid; BORDER-TOP: #000000 2px solid; CURSOR: hand; FONT-FAMILY: verdana,arial,helvetica;color:#000000;font-weight:bold;HEIGHT: 25px; WIDTH: 100px">';
                 echo '&nbsp&nbsp&nbsp&nbsp;';
                 echo '<input type="submit" name="btnUnapproveAll" id="btnUnapproveAll" value="Unapprove All" style="BACKGROUND:#D6D6AD; BORDER-BOTTOM: #000000  2px solid; BORDER-LEFT:  #000000 2px solid; BORDER-RIGHT: #000000 2px solid; BORDER-TOP: #000000 2px solid; CURSOR: hand; FONT-FAMILY: verdana,arial,helvetica;color:#000000;font-weight:bold;HEIGHT: 25px; WIDTH: 120px">';
            echo '</td>';
       echo '</tr>';
       echo '<tr bgcolor="#B1724B">';
            echo '<td width="8%" align="center">';
                 echo '<font size="3" color="#FFFFFF"><b>Emp ID</b></font>';
            echo '</td>';
            echo '<td width="30%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Name</b></font>';
            echo '</td>';
            echo '<td width="10%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>OT Rate</b></font>';
            echo '</td>';
            echo '<td width="20%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Reason</b></font>';
            echo '</td>';
            echo '<td width="5%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Start Time</b></font>';
            echo '</td>';
            echo '<td width="5%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>End Time</b></font>';
            echo '</td>';
            echo '<td width="10%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Status</b></font>';
            echo '</td>';
            echo '<td width="20%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Date</b></font>';
            echo '</td>';
            echo '</tr>';
       include('AdminOTNotYet.php');
       if(isset($_POST['btnApproveAll'])){
           if(!empty($_POST['day_to']) && !empty($_POST['month_to'])&&!empty($_POST['year_to'])){
               $query2 = "UPDATE employee,application,supervisor SET application.ApplyStatus='APPROVED' WHERE
                supervisor.Supervisor_ID=employee.Supervisor_ID AND employee.Emp_ID=application.Emp_ID
                AND supervisor.Supervisor_ID='".$superID."' AND application.Date_OT BETWEEN '". $YearFrom."-".$MonthFrom."-".$DayFrom."' AND '".$YearTo."-".$MonthTo."-".$YearTo."';";
            }
            elseif(empty($_POST['day_to'])||empty($_POST['month_to']) && empty($_POST['year_to'])){
                $query2 = "UPDATE employee,application,supervisor SET application.ApplyStatus='APPROVED' WHERE
                supervisor.Supervisor_ID=employee.Supervisor_ID AND employee.Emp_ID=application.Emp_ID
                AND supervisor.Supervisor_ID='".$superID."' AND application.Date_OT ='".$YearFrom."-".$MonthFrom."-".$DayFrom."';";
            }
            mysql_query($query2);
        }
        

[laserlight]

Um, where are the form tags?

[wendymelon]

It is located above...quite long codes...the form is method="post"

[laserlight]

look again.

It isnt provided with your code snippet.

[wendymelon]

i didn't paste the form tag in the code snippets above...

<body bgcolor="#D6D6AD" link="#0000FF" text="#000000" alink="#FF0000" vlink="#FF00FF">
<form name="frmApplyOT" method="post"  title="Employee Overtime Approval Form">
<p><font size="4"><b>Date From :</b></font>
<?PHP
	$today = getdate();
 $setday = $today['mday'];
 $setmonth = $today['month'];
  $setmonth = substr($setmonth, 0, 3);
 $setnomonth = $today['mon'];
 $setyear = $today['year'];
	 ?>
<font size="4"><b>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspSupervisor ID : </b></font>
  <select name="supervisorID" id="supervisorID">
  <?php
       $db_host = "localhost";
       $mysql_database = "dbtest01";
       $link = mysql_connect($db_host) or die("Unable to connect to MySQL Server");
       mysql_select_db($mysql_database, $link) or die("Unable to connect to database");

   $query = "SELECT Supervisor_ID FROM SUPERVISOR";
   $result= mysql_query($query) or die("Unable to connect to database");

   if(mysql_num_rows($result)){
       echo '<option value=""></option>';
       while($row = mysql_fetch_array($result,MYSQL_NUM)){
           echo '<option value="'.$row[0].'">'.$row[0].'</option>';
       }
   }


?>
   </select>
   <p>
   <font size="4"><b>View : </b></font>
   <input type=submit name="btnViewAll" id="btnViewAll" value="All" 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">
   &nbsp&nbsp&nbsp
   <input type=submit name="btnApproved" id="btnApproved" value="Approved" 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">
   &nbsp&nbsp&nbsp
   <input type=submit name="btnUnapproved" id="btnUnapproved" value="Unapproved" 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">
   &nbsp&nbsp&nbsp
   <input type=submit name="btnNotYetApproved" id="btnNotYetApproved" value="Not Yet Approved" 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: 150px">
   </p>
   <hr>
   <?php
   if(isset($_POST['btnApproved']))
   {
       include('DateTo.php');
       showNormalTable();
       include('AdminOTApproved.php');
   }
   else if(isset($_POST['btnViewAll']))
   {
       include('DateTo.php');
       showNormalTable();
       include('AdminOTAll.php');
   }
   else if (isset($_POST['btnUnapproved'])){
       include('DateTo.php');
       showNormalTable();
       include('AdminOTUnapproved.php');
   }
   else if(isset($_POST['btnNotYetApproved']))
   {
       include('DateTo.php');
       echo '<table bgcolor="#CFCFCF" width="100%" border=3 bordercolor="#000000" cellpadding="0" cellspacing="3">';
       echo '<tr bgcolor="#B1724B">';
            echo '<td colspan="2">';
                 echo '<font size="4" color="#FFFFFF"><b>Supervisor ID:&nbsp&nbsp;</b></font>';
            echo '</td>';
            echo '<td colspan="6">';
                 echo '<font size="4" color="#FFFFFF"><b>Record:&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&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp';
                 echo '<input type="submit" name="btnApproveAll" id="btnApproveAll" value="Approve All" style="BACKGROUND:#D6D6AD; BORDER-BOTTOM: #000000  2px solid; BORDER-LEFT:  #000000 2px solid; BORDER-RIGHT: #000000 2px solid; BORDER-TOP: #000000 2px solid; CURSOR: hand; FONT-FAMILY: verdana,arial,helvetica;color:#000000;font-weight:bold;HEIGHT: 25px; WIDTH: 100px">';
                 echo '&nbsp&nbsp&nbsp&nbsp;';
                 echo '<input type="submit" name="btnUnapproveAll" id="btnUnapproveAll" value="Unapprove All" style="BACKGROUND:#D6D6AD; BORDER-BOTTOM: #000000  2px solid; BORDER-LEFT:  #000000 2px solid; BORDER-RIGHT: #000000 2px solid; BORDER-TOP: #000000 2px solid; CURSOR: hand; FONT-FAMILY: verdana,arial,helvetica;color:#000000;font-weight:bold;HEIGHT: 25px; WIDTH: 120px">';
            echo '</td>';
       echo '</tr>';
       echo '<tr bgcolor="#B1724B">';
            echo '<td width="8%" align="center">';
                 echo '<font size="3" color="#FFFFFF"><b>Emp ID</b></font>';
            echo '</td>';
            echo '<td width="30%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Name</b></font>';
            echo '</td>';
            echo '<td width="10%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>OT Rate</b></font>';
            echo '</td>';
            echo '<td width="20%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Reason</b></font>';
            echo '</td>';
            echo '<td width="5%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Start Time</b></font>';
            echo '</td>';
            echo '<td width="5%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>End Time</b></font>';
            echo '</td>';
            echo '<td width="10%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Status</b></font>';
            echo '</td>';
            echo '<td width="20%" align="center">';
                 echo '    <font size="3" color="#FFFFFF"><b>Date</b></font>';
            echo '</td>';
            echo '</tr>';
       include('AdminOTNotYet.php');
       if(isset($_POST['btnApproveAll'])){
           if(!empty($_POST['day_to']) && !empty($_POST['month_to'])&&!empty($_POST['year_to'])){
               $query2 = "UPDATE employee,application,supervisor SET application.ApplyStatus='APPROVED' WHERE
                supervisor.Supervisor_ID=employee.Supervisor_ID AND employee.Emp_ID=application.Emp_ID
                AND supervisor.Supervisor_ID='".$superID."' AND application.Date_OT BETWEEN '". $YearFrom."-".$MonthFrom."-".$DayFrom."' AND '".$YearTo."-".$MonthTo."-".$YearTo."';";
            }
            elseif(empty($_POST['day_to'])||empty($_POST['month_to']) && empty($_POST['year_to'])){
                $query2 = "UPDATE employee,application,supervisor SET application.ApplyStatus='APPROVED' WHERE
                supervisor.Supervisor_ID=employee.Supervisor_ID AND employee.Emp_ID=application.Emp_ID
                AND supervisor.Supervisor_ID='".$superID."' AND application.Date_OT ='".$YearFrom."-".$MonthFrom."-".$DayFrom."';";
            }
            mysql_query($query2);
        }

[laserlight]

What if you add the attribute:
action="<?php echo $_SERVER['PHP_SELF']; ?>"

the form tag requires an action attribute.

[wendymelon]

where to add the attribute?

[laserlight]

In the form tag.
Basically getting the form to point to itself.

Though I doubt that that is the root of the problem.

[mrhappiness]

you should have an action-attribute like

<form method="post" action="work.php">

but you don't need it if you want the processing of the form in the very same script that outputs your form

try

echo '<pre>$HTTP_POST_VARS: ';
print_r($HTTP_POST_VARS);
echo '$_POST:';
print_r($_POST);
echo '</pre>';

[wendymelon]

I've added the attribute to the form tag...but nothing happen....

the $_POST['btnApproveAll'] didn't execute.

[wendymelon]

I've placed the codes in the code. When I run the script, I found out that...the btnApproveAll is not in the $_POST array.

[mrhappiness]

the code should print two arrays

are both arrays empty?
are both arays not existent (meaning it even don't states "Array( )"?

[laserlight]

"but you don't need it if you want the processing of the form in the very same script that outputs your form"
The action attribute is required, according to the HTML specification.

wendymelon, we could cut short the testing by asking: what version of PHP are you using?

[wendymelon]

I"m currently using PHP4

[laserlight]

PHP 4.0.6 ?
PHP 4.1.0 ?
PHP 4.2.3 ?
PHP 4.3.6 ?

Which version of PHP are you using?
If you're using a version before PHP 4.1.0, the $_POST array is not available to you.

[wendymelon]

I can see the $POST arrays...i can see other elements in my $POST array....

it's just that....btnApproveAll and btnUnapproveAll..doesn't exist in my $_POST array.