I'm facing a problem of...adding value from INPUTS to row in table when the user clicks the Add button..
<?php session_start();?>
<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>
<font size="4"><b>Employee : </b></font>
<form method="POST" action ="HODApply.php" 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['EmpID']."' ORDER BY employee.Emp_ID;";
$result = mysql_query($query);
echo '<select name="emID" onChange="javascript:EName.value = emID.options[emID.selectedIndex].value;" id="emID" style="width: 100px;">';
echo '<option></option>';
while($row = mysql_fetch_array($result,MYSQL_NUM)){
echo '<option value="'.$row[1].'">'.$row[0].'</option>';
}
echo '</select>';
echo '<input type="text" style="width: 250px; name="EName" id="EName" ></input>';
?>
<br><br><font size="4"><b>OT Rate :      </b></font>
<select name="Rate" style="width:150px;">
<option value="" selected></option>
<?php
$query2 = "SELECT * FROM otcode;";
$result2 = mysql_query($query2);
while($rate = mysql_fetch_array($result2,MYSQL_NUM)){
echo '<option>'.$rate[0].'</option>';
}
echo '</select>'
?>
<font size="4"><b>             OT 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>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select> <select name="month_from" id="month_from">
<option value="<? echo $setnomonth?>" selected><? echo $setmonth ?></option>
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select> <input name="year_from" type="text" id="year_from" value ="<? echo $setyear ?>" size="4">
<br>
<font size="4"><b>Start Time :   </font>
<input type="text" maxlength="4" name="StartTime" size="3"></input>
 HHMM                  
<font size="4">End Time :   </font>
<input type="text" maxlength="4" name="EndTime" size="3"></input> HHMM
<br>
<font size="4">Reason :        
<textarea name="reason" wrap="HARD" rows="3"></textarea>
                
                
                
                
<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" bgcolor="#CFCFCF" width="80%" border=3 bordercolor="#000000" cellpadding="0" cellspacing="3">
<tr height="20" bgcolor="#B1724B" align="center">
<td width="10%" >
<font size="4" color="#FFFFFF"><b>ID  </b></font>
</td>
<td width="20%">
<font size="4" color="#FFFFFF"><b>Name  </b></font>
</td>
<td width="15%">
<font size="4" color="#FFFFFF"><b>Position  </b></font>
</td>
<td width="8%">
<font size="4" color="#FFFFFF"><b>Delete?  </b></font>
</td>
</tr>
<?php
if(isset($_POST['btnAdd'])){
#if(!empty($_POST['emID']) && !empty($_POST['EName']) && !empty($_POST['Rate']) && !empty($_POST['day_from']) && !empty($_POST['month_from']) && !empty($_POST['year_from']) && !empty($_POST['StartTime']) && !empty($_POST['EndTime'])&& !empty($_POST['Reason'])){
$EID = $_POST['emID'];
$Name = $_POST['EName'];
$OTR = $_POST['Rate'];
$day = $_POST['day_from'];
$month = $_POST['month_from'];
$year = $_POST['year_from'];
$StartT = $_POST['StartTime'];
$EndT = $_POST['EndTime'];
$Rsn = $_POST['reason'];
$query3 = "SELECT Position FROM employee WHERE Emp_ID = '".$EID."';";
$result3 = mysql_query($query3) or die("Unable to connect to db");
while($row3 = mysql_fetch_array($result3,MYSQL_NUM)){
$position = $row3[0];
}
echo '<tr bgcolor="#B1724B">
<td>'.$EID.'</td>
<td>'.$Name.'</td>
<td>'.$position.'</td>
<td><input type="checkbox" name="delete[]"></input></td>
</tr>';
#}
echo '</table>';
}
?>
</form>
</body>
</html>
I wan the code to do this : When the user clicks on the ADD button, it will only add a new row toend of table instead of redisplaying the table with only the added value.
It currently gives me the error of:
Undefined index : Ename
Undefined variable : $position
