Add Checkbox Column For Each Row Of Postgresql Table

[iDontKnowOfAGoodUsername]

Hello, I have a table that I read in from a postgresql database but I need to add a column that has checkboxes in the final row.

 

It is for a shop so then when the item is selected via checkbox I can then press an add to cart button and send this using an array to the cart.php page.

 

Firstly I need to be able to add checkboxes to the end of each row before I can even do that and I am struggling at how to get a checkbox at the end of each row of my table.

 

 

<form action="index.php" method="post">
<table>
<tr>
<th>ref</th>
<th>title</th>
<th>platform</th>
<th>description</th>
<th>price</th>
<th>select</th>
</tr>


<?php
$resource = pg_query ($connect, "select refnumber,title,platform,description,price from CSGames");


while ($row = pg_fetch_array ($resource)) {
$result[] = $row;
}

foreach($result as $key => $value)
{
echo "<tr>";
for ($j = 0; $j < pg_num_fields ($resource); $j++) {
echo "<td>".$a[$j]."</td>";
}
echo "</tr>";


}


?>
</table>

 

Could any help with this and explain so I can understand what is occurring in the future please?