How do i make it that when i click on a checkbox it saves it automatically into the database when the save button is pressed. It should save in the way as displayed in the screenshot of the database shown. Currently, all i can do is manually type it in the database and it reflects on the checkboxes on the order page.

save.php

query$($$sql$)$;

if $($$result$->$num$\_$rows $>0)\{$

$row $=$ $result$->$fetch$\_$assoc$()$;

$\}$ else $\{$

echo $"$No record found.";

exit$()$;

$\}$

if $($isset$($$$\_$POST$[\text{'}$saveButton$\text{'}]))\{$

if $($isset$($$$\_$POST$[\text{'}$sizes$\text{'}]))\{$

$sizes $=$ $$\_$POST$[\text{'}$sizes$\text{'}]$;

$sizeString $=$ implode$(\text{'},\text{'},$ $sizes$)$;

$query $=$ "UPDATE $`$testdatabase$3`$ SET $`$size$`=\text{'}$$sizeString' WHERE $`$id$`=$ $id$"$;

$run $=$ mysqli$\_$query$($$conn, $query$)$;

if $($$run$)\{$

header$("$Location: orders.php$")$;

exit$()$;

$\}$ else $\{$

echo "Error updating record: $".$ $conn$->$error;

$\}$

$\}$ else $\{$

echo $"$No size selected.";

$\}$

$\}$

$\}$ else $\{$

echo "Invalid request.";

exit$()$;

$\}$

$?>$

ordertable:

$//$ Fetch and display the results

while$($$row $=$ $result$->$fetch$\_$assoc$())\{$

$sizes $=$ explode$(\text{'},\text{'},$ $row$[\text{'}$size$\text{'}])$;

$sizeChecked $=$ function$($$size$)$ use $($$sizes$)\{$

return in$\_$array$($$size, $sizes$)?$ 'checked' : $\text{'}\text{'}$;

$\}$;

echo $"$