Hi everyone I'm new here ! I'm wondering how I can insert the values of a printed row when it's specific checkbox is ticked.
here is my code:
<?php
$query = "SELECT * FROM phpmyreservation_forvalidation";
$result = mysql_query($query);
?>
<form action='insertrecords.php' method='post'>
<?php
echo "<table cellpadding='0' cellspacing='0' border='1'>";
echo "<tr> <th>reservation_id</th> <th>reservation_user_name</th> <th>reservation_day</th> <th>reservation_week</th>
<th> # </th></tr>";
while($row = mysql_fetch_array( $result )) {
echo "<tr><td>";
echo $row['reservation_id'];
echo "</td><td>";
echo $row['reservation_user_name'];
echo "</td><td>";
echo $row['reservation_day'];
echo "</td><td>";
echo $row['reservation_week'];
echo "</td><td align='center'>";
echo "</td>";
?>
<td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?= $row['id'] ?>" ></td>
<?php
}
echo "</table>";
?>
<input type='submit' value='Submit' />
</form>
I'm not sure if what i've done is correct, I also don't have an insert records.php yet, I tried to make one but it didn't work and now I'm really confused. Does anyone know how I can do this ? Thank you !
additional notes: What I'm doing is a validation system the schedules that are not yet validated are on a separate table, when the admin validates them it gets inserted into the phpmyreservation_reservations table.
Thanks !