How To Submit Table/form With Grouping/id To Retrieve Later

I'm trying to write html5 and PHP for a form that the user can fill out. When they hit submit, I want there to be an overall evaluation category that every 5 columns are grouped u

Solution 1:

You can use array like names in your input elements like:

<table id="bigTable" border="1">
    <thead>
     <tr>
     <th id="bandY" class="col3">Bands @263mm Y</th>
     <th id="bandM" class="col3">Bands @263mm M</th>
     <th id="bandC" class="col3">Bands @263mm C</th>
     <th id="bandK" class="col3">Bands @263mm K</th>
     <th id="Comments" class="col3">Comments</th>
     </tr>
    </thead>
    <tbody>
        <tr>
            <td><input name="MCBands[]" value="9214" id="MCBands" type="hidden"> 
            <td><input name="Yevaluation[]" value=""></td>  //Row 0 Column 1
            <td><input name="Mevaluation[]" value=""></td>  //Row 0 Column 2
            <td><input name="Cevaluation[]" value=""></td>  //Row 0 Column 3
            <td><input name="Kevaluation[]" value=""></td>  //Row 0 Column 4
            <td><input name="comment[]" value=""></td>  //Row 0 Column 4
        </tr>
        <tr>
            <td><input name="MCBands[]" value="9215" id="MCBands" type="hidden">
            <td><input name="Yevaluation[]" value=""></td>  //Row 0 Column 1
            <td><input name="Mevaluation[]" value=""></td>  //Row 0 Column 2
            <td><input name="Cevaluation[]" value=""></td>  //Row 0 Column 3
            <td><input name="Kevaluation[]" value=""></td>  //Row 0 Column 4
            <td><input name="comment[]" value=""></td>  //Row 0 Column 4
        </tr>
        <tr>
            <td><input name="MCBands[]" value="9214" id="MCBands" type="hidden">
            <td><input name="Yevaluation[]" value=""></td>  //Row 0 Column 1
            <td><input name="Mevaluation[]" value=""></td>  //Row 0 Column 2
            <td><input name="Cevaluation[]" value=""></td>  //Row 0 Column 3
            <td><input name="Kevaluation[]" value=""></td>  //Row 0 Column 4
            <td><input name="comment[]" value=""></td>  //Row 0 Column 4
        </tr>
    </tbody>

</table>

And on backend, you can use:

if (isset($_GET['submit'])){
    $arr = array();   
    foreach($_POST["MCBands"] as $key => $val) {
        $arr[] = array(
            "MCBands" => $_POST["MCBands"][$key],
            "Yevaluation" => $_POST["Yevaluation"][$key],
            "Mevaluation" => $_POST["Mevaluation"][$key],
            "Cevaluation" => $_POST["Cevaluation"][$key],
            "Kevaluation" => $_POST["Kevaluation"][$key],
            "comment" => $_POST["comment"][$key]
        );    //semicolon added here ~M
    }

}