将表列转换为另一个表

Question

I have a html table like below,

<table>
<tbody>
<tr><th>Manufacturer</th><th>Model Number</th><th>Description</th></tr>
<tr>
<td>Frigidaire</td>
<td><a href="/parts-for-frigidaire-fef368ccbb.html">FEF368CCBB</a></td>
<td>Frg(v1) / Electric Range</td>
</tr>
<tr>
<td>Frigidaire</td>
<td><a href="/parts-for-frigidaire-fef377cfbb.html">FEF377CFBB</a></td>
<td>Frg(v1) / Electric Range</td>
</tr>
<tr>
<td>Frigidaire</td>
<td><a href="/parts-for-frigidaire-fef368ccbf.html">FEF368CCBF</a></td>
<td>Frg(v1) / Electric Range</td>
</tr>
<tr>
<td>Frigidaire</td>
<td><a href="/parts-for-frigidaire-fef377cfbd.html">FEF377CFBD</a></td>
<td>Frg(v1) / Electric Range</td>
</tr>
<tr>
<td>Frigidaire</td>
<td><a href="/parts-for-frigidaire-fef368ccba.html">FEF368CCBA</a></td>
<td>Frg(v1) / Electric Range</td>
</tr>
<tr>
<td>Frigidaire</td>
<td><a href="/parts-for-frigidaire-fef368ccbc.html">FEF368CCBC</a></td>
<td>Frg(v1) / Electric Range</td>
</tr>
</tbody>
</table>

I want all second column values to be created another table like below. (3 columns)

<table>
<tbody>
<tr>
<td>FEF368CCBB</td>
<td>FEF377CFBB</td>
<td>FEF368CCBF</td>
</tr>
<tr>
<td>FEF377CFBD</td>
<td>FEF368CCBA</td>
<td>FEF368CCBC</td>
</tr>
</tbody>
</table>

I tried to do using foreach, but it becomes complicated and messy now.

How can I do this in php? any help would be appreciated.

</div>

Answer 1

Please try following snippet of jQuery which will read all values from second cell of each row and create new table at the end of your webpage.

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script type="text/javascript">
    $(document).ready(function(){
      var html = '<table>';
      $('tr').each(function(){
        var cellVALUE = $(this).find("td:nth-child(2) a").html();
        if($(this).find("td:nth-child(2) a").length > 0){
        html += '<tr><td>'+cellVALUE+'</td></tr>';
      }
        console.log(cellVALUE);
      });
      html += '</table>';
      $('body').append(html); // append this string wherever you want to create table.
    });
</script>