[RESOLVED] Displaying form element values for multiple rows

[revez2002]

Hello,

I have been using the code below successfully for some time now to insert multiple rows into a table. Now I would like to extend it so that if the form is submitted before all of the required fields are completed (some of these fields are not displayed in the code I have posted here), then the values that have been been input by the user should still be displayed. However, I have been unable to figure out how to echo the name of the form element to display the proper value for each row.

As always, any hints or suggestions are greatly appreciated.

Revez

<?php 
    if (!isset($_POST['submit'])) { 
    echo ' 
            <tr> 
            <td width=10></td> 
            <td class=main_content_02>Firstname</td> 
            <td class=main_content_02>Lastname</td> 
            <td class=main_content_02>Phone Number</td> 
            <td class=main_content_02>Email</td> 
            <td class=main_content_02>Team Number</td> 
            </tr> 
    '; 

for ($i = 1; $i <= 3; $i++) { 
    echo ' 
    <tr> 
            <td width="10"></td> 
    <td class="lite_green_02"><input type="text" name="row['.$i.'][firstname]" value="$HTTP_POST_VARS["row"]["i"]["firstname"]" size="10"></td> 
    <td class="lite_green_02"><input type="text" name="row['.$i.'][lastname]" value="$HTTP_POST_VARS["row"]["i"]["lastname"]" size="10"></td> 
    <td class="lite_green_02"><input type="text" name="row['.$i.'][phone_number]" size="10"></td> 
    <td class="lite_green_02"><input type="text" name="row['.$i.'][email]" size="10"></td> 
    <td class="lite_green_02"><input type="text" name="row['.$i.'][team_number]" size="5"></td> 
    </tr> 
    '; 
} 

echo '   
<tr> 
    <td colspan="6" height="40" width="100%" align="center" valign="middle"><input type="submit" name="submit" value="Enter"></td> 
    </tr> 
'; 

} else { 

  foreach($_POST['row'] as $value) {
    $check = false; 
      foreach ($value as $field) { 
        if ($field != '') { 
          $check = true; 
          break; 
        } 
      } 

      if ($check) {          

          $sql = mysql_query("INSERT INTO TEST_ROSTER SET 
          roster_ID=NULL, 
          firstname='".$value['firstname']."', 
          lastname='".$value['lastname']."', 
          phone_number='".$value['phone_number']."', 
          email='".$value['email']."', 
          team_number='".$value['team_number']."', 
          created_by='$username'");       
      } 
   } 
}
?> 

[Clarkey_Boy]

The foreach statement at the bottom of the code does not look like it could possibly work... shoult there not be something for $i in there to make it work?

Clarkey Boy

[revez2002]

You're correct, the code as it previously appeared would not work (I got sloppy cutting and pasting from an earlier posting). The code below does work.

revez

[revez2002]

The answer is as follows:

<input class="lite_green_02" type="text" name="<?php echo 'row['.$i.'][firstname]'; ?>" value="<?php echo $row[$i]["firstname"]; ?>" style="width:180px;" maxlength="120">

Now I get to go to sleep

revez 🙂