Posting updates to multiple rows?

[beteb]

I'm using Smarty with PHP, and I'm trying to post updates to multiple rows at a time. I've tried several methods, but nothing seems to work and I've been stuck staring at this code so long it's blurring. If anyone can help, I'd really appreciate it.

The TPL File

         <form name="frmInputData" action='user_teacherlogs.php?week_selected={$week_selected}' method='POST'>
         <br />
<table width="100%" class='list'>
	<tr>
    	<td class='header'>First Name</td>
        <td class='header'>Last Name</td>
        <td class='header'>Monday</td>
        <td class='header'>Tuesday</td>
        <td class='header'>Wednesday</td>
        <td class='header'>Thursday</td>
        <td class='header'>Friday</td>
    </tr>

   {* LIST STUDENTS *}
  {foreach from=$displaystudents key=k item=student}
        <tr><input type="hidden" name="stulog_id[{$k}]" value="{$student.stulog_id}"/>
       <td class="item">{$student.user_lname}</td>
        <td class="item">{$student.user_fname}</td>
        <td class="item"><input name="D1[{$k}]" value="{$student.D1}" size="7"/></td>
        <td class="item"><input name="D2[{$k}]" value="{$student.D2}" size="7"/></td>
        <td class="item"><input name="D3[{$k}]" value="{$student.D3}" size="7"/></td>
        <td class="item"><input name="D4[{$k}]" value="{$student.D4}" size="7"/></td>
        <td class="item"><input name="D5[{$k}]" value="{$student.D5}" size="7"/></td>
        </tr>
   {/foreach}

<tr>
	<td colspan="7" align="right">
            <input type="hidden" name="task" value="save"/>
    	<input type="submit" name="submit" class="button" value="Update" />
    </td>
</table>
</form>

The PHP File

//Update Records when Button is Pushed
if($task == 'save');
	{
/*  $stulog_id = $_POST['stulog_id'];
  $D1 = $_POST['D1'];
  $D2 = $_POST['D2'];
  $D3 = $_POST['D3'];
  $D4 = $_POST['D4'];
  $D5 = $_POST['D5'];

for ($i=0; $i<$numrows; $i++) */
foreach($_POST['stulog_id'] as $key => $value)
	{
		$stulog_id = $_POST['stulog_id'][$key];
  $D1 = $_POST['D1'][$key];
  $D2 = $_POST['D2'][$key];
  $D3 = $_POST['D3'][$key];
  $D4 = $_POST['D4'][$key];
  $D5 = $_POST['D5'][$key];
		$sqlupd="UPDATE tfk_stu_training SET D1 = '$D1', D2 = '$D2', D3 = '$D3', D4 = '$D4', D5 = '$D5' 
			WHERE stulog_id = '$stulog_id'";
			$database->database_query($sqlupd);
			}

}

[sfullman]

I don't know smarty, but I can certainly visualize what your form would do and it seems like it would produce a valid array. I suggest you troubleshoot!

On the receiving end, do this:

echo '<pre>';
print_r($_POST);
echo '</pre>';

the node stulog_id, D1, D2, D3 etc.. should be keys from k-sub-zero to k-sub-n where 0->n represents your keys.

Then in your code do this:

echo '<pre>';
print_r($sqlupd);
echo '</pre>';

does it look like the query should update your code? copy and test it in phpMyAdmin.

I'm not solving your problem, only teaching you how to troubleshoot. If you learn this then you'll need the forum less, 2) you'll gain skills to help others on the forum and 3) the questions you DO ask on the forum will be more specific and usually higher-level questions.

In summary, TROUBLESHOOT - learn how.

Best,
Samuel

[beteb]

Thanks for the tips on troubleshooting. I'd already done a lot of that, and it turns out the code above actually works. What's happening is that when it posts it doesn't pull up the updated values until I refresh the page yet again (which is why I thought it wasn't working). Any tips for that?

[sfullman]

there are several ways to approach. you can post to a hidden iframe and use javascript to update the data

or just post to a page, but if the user refreshes the page they'll get that annoying " this will cause postdata to be sent twice, are you sure?" message.

one way you might consider is, have the action of the form be the same page, process the post data before anything else on the page (very top of the page in other words), and then do this:

header('Location: thispage.php');
exit;

after the form post. That way they cannot double submit a post and will not get the message

[anoopmail]

can u do a print_r($_POST) and paste the content here?