Parse multirow HTML table

Posted on 16th Feb 2014 by admin

Hello all,
I have a site I am working on. Its a sports site and I am trying to add stats to a DB. I have a table that will have varying amounts of rows depending on how many kids are on the team. I need to take the rows of the stats table and be able to add them to the DB with a single submit button. Here is the code for my table. The form is calling another php page for processing. I am thinking I will need a foreach to pull all the rows out of the table but not sure on how to reference the table in the POST.
Any help would be greatly appreciated.
Code: [Select]<table align="center" width="780 px" name="aStatsInput">
<tr>
<td align="center" colspan="14"><b>Away Team </b>Bushnell-Prairie City/Avon</td>
</tr>
<tr>
<th style="table-layout: fixed; align: left; width: 100 px;">Player</th>
<th>fgM</th>
<th> fgA</th>

<th> ftM</th>
<th> ftA</th>
<th> 3ptM</th>
<th> 3ptA</th>
<th> OReb</th>

<th> DReb</th>
<th> Assts</th>
<th> Steals</th>
<th> Fouls</th>
<th> TFouls</th>

<th> Turnovrs</th>
</tr>
<tr bgcolor="white" id="row1">
<td>Hulett Dewain</td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>

<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
</tr>
<tr bgcolor="#aaaaaa" id="row2">
<td>Powell Cory</td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>

<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
<td><INPUT name="" type="text" size="1"></td>
</tr>
</table>