[RESOLVED] Update data in a table

rcr

Hi,

This is the scenario i am trying to work on:

I have a table called STUDENT, having columns (NAME,TA😎:
NAME TAB

Jack 0
John 0
Bob 0

I need to display a page that will allow me to see all these rows are update the table column to other values for example:
NAME TAB

Jack 3
John 5
Bob 2

These new tab column values must be updated into the table for the corresponding rows.

I have created a script that will query all the rows and populate them into an array called STUDENTS. I am then using a foreach loop so that the name column is displayed as is but the tab column is an input text item. I am able to get to that much, but I don't know what to do after this.

             <form action="tsa.php" method="post">
	<table class="stable">
          <thead>
                 <tr><th>Student Name</th><th>Table</th></tr>
               </thead>
	   <tbody>
		<?php foreach ($students as $student): ?>
		<tr>
		<td><?php echo ($student['name']); ?></td>
		<td>[B]<input type="text" value="<?php echo ($student['table']); ?>">[/B]</td>
                    <?php $students['table']=$student['table']; ?>
		</tr>
		<?php endforeach; ?>
	   </tbody>
	</table>
            <p>
            <input type="submit" name="action" value="apply"/>
	</p>
	</form>

================
I am not sure how to proceed and if this approach will get me the result. Any assistance is appreciated.

Thanks
RCR

bradgrafelman

For one, what is the point of this statement:

$students['table']=$student['table'];

Ignoring that, the first real problem is that you haven't given the text INPUT element a name. How do you expect to access the submitted data when you haven't even named the field?

Second, you need to somehow associate the data entered in each field with the name it corresponds to. One way to do that would be name the fields like tab[Jack], e.g. place the name inside of square brackets at the end of the field name. That way, $_POST['tab'] would be an associative array - one you could then use a [man]foreach[/man] loop to process and update your SQL table.

rcr

Thanks Bradgrafelman,

I don't think there was any point in that statement so I have removed it. I did specify a name for the INPUT element.

I however do not know how to proceed with the part of creating the associative array.

Second, you need to somehow associate the data entered in each field with the name it corresponds to. One way to do that would be name the fields like tab[Jack], e.g. place the name inside of square brackets at the end of the field name. That way, $_POST['tab'] would be an associative array - one you could then use a [man]foreach[/man] loop to process and update your SQL table.

If anyone can elaborate on that with an example, i would greatly appreciate it. The current state of the code is:

<form action="tsa.php" method="post">
<table class="stable">
<thead>
<tr><th>Student Name</th><th>Table</th></tr>
</thead>
<tbody>
<?php foreach ($students as $student): ?>
<tr>
<td><?php echo ($student['name']); ?></td>
<td><input type="text" name="tabl" value="<?php echo ($student['tabl']); ?>"></td>

		</tr>
		<?php endforeach; ?>
	   </tbody>
	</table>
            <p>
            <input type="submit" name="action" value="apply"/>
	</p>
	</form>

Thanks again for your help.

RCR.
Second, you need to somehow associate the data entered in each field with the name it corresponds to. One way to do that would be name the fields like tab[Jack], e.g. place the name inside of square brackets at the end of the field name. That way, $_POST['tab'] would be an associative array - one you could then use a [man]foreach[/man] loop to process and update your SQL table.[/QUOTE]

Weedpacket

Have you tried doing what bradgrafelman suggested and naming the field something like tab[Jack]? Once you've done that you'll be able to look at what you have in the $_POST array and see what he's talking about.

rcr

Hi...Thanks for your response. However, I am not too experienced with PHP and I am having trouble trying to write out what has been suggested. If someone knows how to write out this suggestion , please do help me out.

Thanks for your time and help.

RCR.

rcr

Is this how I would write it...

		<td><input type="text" name="tabl[$student['name']]"  value="<?php echo ($student['tabl']); ?>"></td>

I also don't know how to access the POST array tabl...

Thanks for all help.

rcr

Thanks for all your help.