update records with php mysql

keikei

I have successfully 🙂 displayed records from my database using

   <table border="1" width="400" align="center" cellpadding="2" cellspacing="0">
      <tr bgcolor="#CCCCCC" height="25">
         <td width="15"><font size="2"><b>&nbsp;</b></font></td>
         <td><font size="2"><b>Employee ID</b></font></td>
         <td><font size="2"><b>Last Name</b></font></td>
         <td><font size="2"><b>First Name</b></font></td>
         <td><font size="2"><b>Action</b></font></td>   

      </tr>
<?php
   for($i=0; $i<$count; $i++){
      $a=$i+1;
      $rows=mysql_fetch_array($rs);
      $emp_lname=$rows['emp_lname'];
      $emp_fname=$rows['emp_fname'];
      $emp_ID=$rows['emp_ID'];

  echo"<tr>";
  echo"<td><font size=\"2\">$a</font></td>";
  echo"<td><font size=\"2\">$emp_ID</font></td>";
  echo"<td><font size=\"2\">$emp_lname</font></td>";
  echo"<td><font size=\"2\">$emp_fname</font></td>";
  echo"<td><div align=\"center\">
  <font face=\"verdana,arial\" size=\"1\"><a href=\"editemp.php\">edit</a></font>
  echo"</tr>";
   }?>
      <tr>
      <td bgcolor="#CCCCCC" colspan="5" height="30">
         <div align="center"><font face="verdana,arial" size="1"><a href="addemp.php">add</a> | <a href ="deleteemp.php">delete</a></div>
      </td>
      </tr>
<?php }?>

The add and delete works fine, however, I would like to make the edit record work for each row, lets say if the user clicks on the edit on the third row, how would I create a form that would automatically show the data of the row that the user wishes to edit?? 😕

melody

Try appending the ID to the URI, then getting the edittemp.php page to pull that data "WHERE id='" . $_GET['id'] . "'"

i.e. replace:

 echo "<font face=\"verdana,arial\" size=\"1\"><a href=\"editemp.php\">edit</a></font>"

with:

echo "<font face=\"verdana,arial\" size=\"1\"><a href=\"editemp.php?id=" . $emp_ID . "\">edit</a></font>"

You'll end up with a URI looking like:
edittemp.php?id=100

Then on the edittemp.php page, use the passed variable to pull the row from the database with the associated ID. This assumes though, that you want to grant the ability to users using this page to be able to change any record, since it's easy to change an ID on the URI and hence change the record you're looking at.

HTH

Melody