How to display a checked checkbox in a PHP update form? postgres sql

To begin with, you have to know how to store multiple checkbox values to database. I've added a reference if you need it.

Assuming your toppings is saved as comma-separated value like this:

1. You can use explode() function to explode comma-separated value to a flat, indexed array.

   From Chocolate,Caramel,M&M's to ["Chocolate", "Caramel", "M&M's"].

2. Then you can use in_array() function to check if the item(topping) is available or not in array.

PHP

/* Connection with PDO */
// DB details (Change it to your DB details)
$host = '127.0.0.1';
$user = 'root';
$password = 'root';
$dbname = 'test';
$port = '3306';

// DataSourceName for MySQL (The one I used for testing)
$dsn = "mysql:dbname=$dbname;host=$host;port=$port";
// DataSourceName for PostgreSQL (Use this and add port if you need)
$dsn = 'pgsql:dbname=$dbname;host=$host;';

$pdo = new PDO($dsn, $user, $password);
/* End Connection String */

// Get Toppings Value From DB
$statement = $pdo->query("SELECT `toppings` FROM toppings");
$res = $statement->fetch();

//res[0] = Comma Separated String of Toppings: 'Topping1,Topping2,Topping3'
$toppings = explode(',', $res[0]);
// $toppings = Array of toppings checked: ["Topping1", "Topping2", "Topping3" ]


/* Connection with PG */
$db = pg_connect("host=localhost port=5432 dbname=SRIS user=postgres password=password");
$result = pg_query($db, "SELECT * FROM tablename ");
$row = pg_fetch_assoc($result);

$toppings = explode(',', $row['toppings']);

HTML FORM

<label class="checkbox-container">
  <input type="checkbox" name="toping[]" <?=(in_array('Vanilla',$toppings) ? 'checked="checked"' : '')?> value="Vanilla">
  <span class="checkmark"></span>
  <span class="checkbox-txt"> Vanilla</span><br/></br>
</label>
<label class="checkbox-container">
    <input type="checkbox" name="toping[]" <?=(in_array('Chocolate',$toppings) ? 'checked="checked"' : '')?> value="Chocolate">
    <span class="checkmark"></span>
    <span class="checkbox-txt">Chocolate</span><br/></br>
</label>
<label class="checkbox-container">
    <input type="checkbox" name="toping[]" <?=(in_array('Caramel',$toppings) ? 'checked="checked"' : '')?> value="Caramel">
    <span class="checkmark"></span>
    <span class="checkbox-txt">Caramel</span><br/></br>
</label>
<label class="checkbox-container">
    <input type="checkbox" name="toping[]" <?=(in_array('Strawberry',$toppings) ? 'checked="checked"' : '')?> value="Strawberry">
    <span class="checkmark"></span>
    <span class="checkbox-txt">Strawberry</span><br/></br>
</label>
<label class="checkbox-container">
    <input type="checkbox" name="toping[]" <?=(in_array("M&M's",$toppings) ? 'checked="checked"' : '')?> value="M&M's">
    <span class="checkmark"></span>
    <span class="checkbox-txt">M&M's</span><br/></br>
</label>
<label class="checkbox-container">
    <input type="checkbox" name="toping[]" <?=(in_array('Oreo',$toppings) ? 'checked="checked"' : '')?> value="Oreo">
    <span class="checkmark"></span>
    <span class="checkbox-txt">Oreo</span><br/></br>
</label>
<label class="checkbox-container">
    <input type="checkbox" name="toping[]" <?=(in_array('Meringue',$toppings) ? 'checked="checked"' : '')?> value="Meringue">
    <span class="checkmark "></span>
    <span class="checkbox-txt">Meringue</span><br/>
</label>

Note:

• I've changed the name attribute to name=topping[], you should use field name array.
• I've also changed the value attribute, giving a predetermined value to each checkbox.

References:

• Explode : Comma-delimited string into an array?
• <?= : What does '<?=' means in PHP
• Example to store Checkbox value to DB: How to Insert Multiple Checkbox Value to Database