PHP Set Value From Database To Textbox

[davidalwis]

Hi... Need your help with my case below :

1. Index.php

   <table>
   											<tr>
   												<td>Badge ID</td>
   												<td>Employee Name</td>
   												<td>Department</td>
   												<td>Overtime Date</td>
   												<td>From</td>
   												<td>To</td>
   												<td>Remarks</td>
   											</tr>
   
   								<?php
   									$n = $_POST['jum'];
   									for ($i=1; $i<=$n; $i++)
   									{
   
   									echo '
   									<tr>
   										<td><input type="text" size="7" name="badgeid' . $i .'" maxlength="6" 
   										onchange="javascript:this.value=this.value.toUpperCase();"
   										onkeyup="getCity(\'search.php?badgeid=\'+this.value, \'name' . $i . '\',\'dept' . $i . '\');"></td>
   										<td><input type="text" size="15" name="name' . $i . '" id="name' . $i . '" readonly></td>
   										<td><input type="text" size="12" name="dept' . $i . '" id="dept' . $i . '"></td>
   										<!-- -->
   										<td><input type="text" size="12" name="otdate' . $i .'" id="date" class="date-pick" 
   										onChange="javascript:this.value=this.value.toUpperCase();" readonly></td>
   										<td><input type="text" size="4" name="otfrom' . $i . '" id="time1" value=\'\' readonly ></td>
   										<td><input type="text" size="4" name="otto' . $i . '" id="time2" value=\'\' readonly ></td>
   										<td><input type="text" size="25" name="remarks' . $i . '" ></td>
   
   									</tr>';
   									}
   								?>
   								</table>

2.

<?php
	include_once('config.php');
	if (isset($_GET['badgeid']))
	{
		$qry = "SELECT name,dept FROM employee WHERE badgeid = '" . $_GET['badgeid'] . "' ";
		$sql = mysql_query($qry);
		$ary = mysql_fetch_array($sql);
		echo $ary['name'];
		echo $ary['dept'];
	}
?>

I want to set the value name and department to each textbox, that's textbox_name and textbox_dept.

The one value was correct, when I input the badge ID then the value name show in textbox_name. But textbox_dept not change.

The value of dept also filled in textbox_name.

Appreciate with your helps. 😃
Thanks.

[KingWylim]

I'm not 100% sure of what your trying to accomplish but if your looking for javascript to modify a readonly box your out of luck you need to make the input boxes disabled not readonly or the javascript can not make changes since you have specified the box as readonly which means it was done being working with on the server. If you could clarify what your working on that would be exstreamly helpful.

I'm not clear if your having trouble incrementing the id's and names of the boxes or if your having some sort of trouble with the actual values of the box. Because as far as I can tell I don't see you doing anything with the values except for on post.

I'm also unclear of what the $_POST["jum"] is coming from but I can see clearly that all of your variables are going to be incremented up to that number.