如何连续创建提交表单并将输入与该行相关联？

Question

Hey Guys, I have a question for you.

Imagine that I wanted to be able to keep track of how many miles I've ran every week, so that I could compare it to the goals I've set for each week. So i've created this table by the use of mysql_fetch_row.

$result=mysql_query("SELECT * FROM randomtable ORDER BY week ASC");

echo "<Table id='result' cellspacing='0'>
    <tr class='toprow'>
    <th>Week</th>
    <th>Goal</th>
    <th>Actual Number of Miles</th>
    </tr>";

while($row = mysql_fetch_row($result))
{
    echo "<tr class='standardrow'>";
    echo "<td>$row[0]</td>";
    echo "<td>$row[1]</td>";
    echo "<td><form><input method='post' type='number'></form></td>";
    echo "</tr>";
}

echo "</table>";

This piece of code resultet in a table with 10 weeks with 10 goals - and a column for the actual number of miles. This column should include 10 input forms where the actual number of miles can be submitted. But how do I relate the input from the submit form to the row in which the submit form is positioned? The primary key is the week - so this would be the one to relate to.

Hope you understand what my problem is:)

Answer 1

To do this you would use a hidden input field.

When you echo each row, and the form in that row, you would simply add an extra line:

`<input type="hidden" name="row_id" value="' . $row['id_column'] . '" />';

In full, your code would be:

$result=mysql_query("SELECT * FROM randomtable ORDER BY week ASC");

echo "<Table id='result' cellspacing='0'>
    <tr class='toprow'>
    <th>Week</th>
    <th>Goal</th>
    <th>Actual Number of Miles</th>
    </tr>";

while($row = mysql_fetch_row($result))
{
    echo "<tr class='standardrow'>";
    echo "<td>$row[0]</td>";
    echo "<td>$row[1]</td>";
    echo "<td>
            <form>
                <input method='post' type='number'>
                <input type='hidden' name='row_id' value='" . $row['id_column'] . "' />
            </form>
          </td>";
    echo "</tr>";
}

echo "</table>";