Guest User

Untitled

a guest
Sep 9th, 2010
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.77 KB | None | 0 0
  1. I'm trying to update table I've created, and I can't seem to get it to post the updated values back to the table.  I'm sure it's something basic I'm missing, but it's driving me crazy.  Any ideas?
  2.  
  3. PHP Code
  4.  
  5. //Get Records to Display for Data Entry
  6. $displaystudents = array();
  7.  
  8.     $sqldisp = "SELECT su.user_lname, su.user_fname, su.user_id, trn.log_date, trn.D1, trn.D2, trn.D3, trn.D4, trn.D5
  9. FROM se_users su JOIN tfk_stu_training trn ON su.user_id = trn.student_id
  10. JOIN tfk_stu_teacher tch ON trn.student_id = tch.student_id
  11. WHERE trn.log_date = '$week_selected ' and tch.teacher_id = '$teacher_id' ORDER BY su.user_lname";
  12.  
  13.  
  14. $numrows = $database->database_num_rows($sqldisp);
  15.  
  16. $rows2 = $database->database_query($sqldisp);
  17.  
  18. while($row2 = $database->database_fetch_assoc($rows2) ) {
  19.  
  20.                    $row2['user_lname'] = $row2['user_lname'];
  21.                   $row2['user_fname'] = $row2['user_fname'];
  22.                   $row2['student_id'] = $row2['user_id'];
  23.                   $row2['log_week'] = $row2['log_date'];
  24.                   $row2['D1'] = $row2['D1'];
  25.                   $row2['D2'] = $row2['D2'];
  26.                   $row2['D3'] = $row2['D3'];
  27.                   $row2['D4'] = $row2['D4'];
  28.                   $row2['D5'] = $row2['D5'];
  29.         array_push($displaystudents, $row2);
  30.                  }
  31.  
  32. //Update Records when Button is Pushed
  33. if ($_POST["Submit"]) {
  34.  
  35.     for ($i=0; $i<$numrows; $i++)
  36.         {
  37.           // GET POST VARIABLES
  38.  $D1 = $_POST['D1'][$i];
  39.  $D2 = $_POST['D2'][$i];
  40.  $D3 = $_POST['D3'][$i];
  41.  $D4 = $_POST['D4'][$i];
  42.  $D5 = $_POST['D5'][$i];
  43.  $student_id = $_POST['student_id'][$i];
  44.  $log_week = $_POST['log_week'][$i];
  45.  
  46.         $sqlupd="UPDATE tfk_stu_training SET D1 = '$D1[$i]', D2 = '$D2[$i]', D3 = '$D3[$i]', D4 = '$D4[$i]', D5 = '$D5[$i]'
  47.             WHERE student_id = '$student_id[$i]' AND log_date = '$log_week[$i]'";
  48.             $database->database_query($sqlupd);
  49.             }
  50.  
  51. }
  52. // ASSIGN VARIABLES AND INCLUDE FOOTER
  53. $smarty->assign('today', $today);
  54. $smarty->assign('error_message', $error_message);
  55. $smarty->assign('teacher_id', $teacher_id);
  56. $smarty->assign('displaystudents', $displaystudents);
  57. $smarty->assign('week_selected', $week_selected);
  58. $smarty->assign('D1', $D1);
  59. $smarty->assign('D2', $D2);
  60. $smarty->assign('D3', $D3);
  61. $smarty->assign('D4', $D4);
  62. $smarty->assign('D5', $D5);
  63. $smarty->assign('student_id', $student_id);
  64. $smarty->assign('log_week', $log_week);[/code]
  65.  
  66.  
  67. TPL Code
  68.  
  69.         <form name="frmInputData" action='user_teacherlogsmine.php' method='POST'>
  70.         <br />
  71. <table width="100%" class='list'>
  72.     <tr>
  73.         <td class='header'>First Name</td>
  74.        <td class='header'>Last Name</td>
  75.        <td class='header'>Monday</td>
  76.        <td class='header'>Tuesday</td>
  77.        <td class='header'>Wednesday</td>
  78.        <td class='header'>Thursday</td>
  79.        <td class='header'>Friday</td>
  80.    </tr>
  81.  
  82.   {* LIST STUDENTS *}
  83.  {foreach from=$displaystudents[t] item=student}
  84.        <tr>
  85.       <td class="item">{$student.user_lname}</td>
  86.        <td class="item">{$student.user_fname}</td>
  87.        <td class="item"><input name="D1[t]" value="{$student.D1}" size="7"/></td>
  88.        <td class="item"><input name="D2[t]" value="{$student.D2}" size="7"/></td>
  89.        <td class="item"><input name="D3[t]" value="{$student.D3}" size="7"/></td>
  90.        <td class="item"><input name="D4[t]" value="{$student.D4}" size="7"/></td>
  91.        <td class="item"><input name="D5[t]" value="{$student.D5}" size="7"/></td>
  92.       <input type="hidden" name="student_id[t]" value="{$student.student_id}"/>
  93.        <input type="hidden" name="log_week[t]"value="'{$week_selected}'"/>
  94.        </tr>
  95.   {/foreach}
  96.  
  97.    <tr>
  98.         <td colspan="7" align="right">
  99.             <input type="submit" name="Submit" class="button" value="Update" />
  100.        </td>
  101. </table>
  102. </form>
Advertisement
Add Comment
Please, Sign In to add comment