Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Sep 9th, 2010 | Syntax: PHP | Size: 3.77 KB | Hits: 30 | Expires: Never
Copy text to clipboard
  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>