PHPize Online / SQLize Online  /  SQLtest Online

<?php $defaults = [ "shoes" => 'no', "pants" => 'no', "skirt" => 'no', "socks" => 'no', "jacket" => 'no', ]; $_POST['id'] = '1'; $_POST['clothes'] = "shoes, socks, jacket"; $ticked = array_fill_keys(explode(', ', $_POST['clothes']), 'yes'); $yesses = array_intersect_key($ticked, $defaults); $row = $yesses + $defaults; var_export($row); $sql = sprintf( 'INSERT INTO clothes (customer_id,%s) VALUES (?,%s)', implode(',', array_keys($defaults)), implode(',', array_fill(0, count($defaults), '?')) ); $stmt = $pdo->prepare($sql); $stmt->execute($row); var_export( $pdo->query('SELECT * FROM clothes')->fetchAll(PDO::FETCH_ASSOC) );