link via button not working
Posted: Mon Feb 09, 2009 3:45 am
Hi all
I hope someone can help me, I’m trying to open another page by using checkboxes and JavaScript on a Button. JavaScript is fine it opens up a new page but I can NOT seem to take the checked link, it keeps on opening the last record even thou I’m checking different record. How the hell do I do it? Thanks in advance.
Page 1
Page2
Zed
I hope someone can help me, I’m trying to open another page by using checkboxes and JavaScript on a Button. JavaScript is fine it opens up a new page but I can NOT seem to take the checked link, it keeps on opening the last record even thou I’m checking different record. How the hell do I do it? Thanks in advance.
Page 1
Code: Select all
$query = "SELECT * FROM employee ORDER BY last_name";
$result = mysql_query($query)or die(mysql_error());
?>
<div class="medText">
<b>list of Employees</b>
<TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#BFB5F9">
<TR bgcolor="#D7D6D2">
<td align=center><b>ID</b></TD>
<td align=center><b>Date Reg </b></TD>
<td align=center><b>Last name</b></TD>
<td align=center><b>First name</b></TD>
<td align=center><b>Address</b></TD>
<td align=center><b>Town/City</b></TD>
<td align=center><b>Home Tel</b></TD>
<td align=center><b>Mobile Tel</b></TD>
<td align=center><b>Status</b></TD>
<td align=center></TD>
</tr>
<?
while ($row = mysql_fetch_array($result)) {
extract($row);
echo "<tr class=\"td\">
<td> " . $row['employee_id'] . "</a></td>
<td>" . $row['date_registered'] . "</td>
<td>" . $row['last_name'] ."</td>
<td>" . $row['first_name'] ."</td>
<td>" . $row['address'] . "</td>
<td>" . $row['town_city'] . "</td>
<td>" . $row['home_no'] . "</td>
<td>" . $row['mobile_no'] . "</td>
<td>" . $row['status'] . "</td>
<td>" ?>
<input type="checkbox" name="<?=$row[employee_id]?>" id="<?=$row[employee_id]?>" value="<?=$row[employee_id]?>"/>
<? "</TD>
</tr>";
}
?>
</TABLE>
<br><center>
<? echo" <input type=\"submit\" name=\"view\" id=\"view\" value=\"View Details\" onclick=\"open_win('employee_con2.php?employee_id=$employee_id');\" />" ?>
</center>
</div> Page2
Code: Select all
$employee_id = $_GET['employee_id'];
$query = "SELECT * FROM employee WHERE employee_id = '$employee_id'";
$result = mysql_query($query)or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
extract($row);
?>
<p></p>
<center><div id="display">
<?php echo $adminname ?>
Your New Employee record has been inserted into the databes Successfully. Please check below for details.
<p></p>
<TABLE BORDER="0" WIDTH="100%" bgcolor="#CFFEFD">
<TR class="td" align="left">
<TH WIDTH="36%">Employee ID</TH>
<TD WIDTH="64%"><?php echo $employee_id ?></TD>
</TR>
<TR class="td" align="left">
<TH WIDTH="36%" >Employment required As</TH>
<TD WIDTH="64%"><?php echo $employment_required ?></TD>
</TR>
<TR class="td" align="left">
<TH WIDTH="36%" >Registration Date</TH>
<TD WIDTH="64%"><?php echo $date_registered ?></TD>
</TR>
</table>
<?
}
?>