'supply_and_install', 'SUPPLY' => 'supply', 'SUPPLY & DELIVERY' => 'supply_and_delivery', ]; foreach ($order_types as $order_type) { $key = $key_map[$order_type]; $terms_val = addslashes($_POST[$key . '_terms'] ?? ''); $notes_val = addslashes($_POST[$key . '_notes'] ?? ''); $res = $db->query("terms", "SELECT record_id FROM `terms` WHERE `document_type` = '$doc' AND `order_type` = '$order_type'"); if ($res && $res->num_rows > 0) { $row = $res->fetch_assoc(); $db->query("terms", "UPDATE `terms` SET `terms` = '$terms_val', `notes` = '$notes_val' WHERE `record_id` = '{$row['record_id']}'"); } else { $db->query("terms", "INSERT INTO `terms` (`document_type`, `order_type`, `terms`, `notes`) VALUES ('$doc', '$order_type', '$terms_val', '$notes_val')"); } } echo ""; exit(); } $html = new html("QUOTE TERMS"); $app = new inner_app(); $app->quick_bar("/app/quotes/"); $app->app_start(); $terms_res = $db->query("terms", "SELECT * FROM `terms` WHERE `document_type` = 'quote'"); $terms_by_type = []; while ($t = $terms_res->fetch_assoc()) { $terms_by_type[$t['order_type']] = $t; } ?>

EDIT QUOTE TERMS

✓ QUOTE terms saved successfully.
'supply_and_install', 'SUPPLY' => 'supply', 'SUPPLY & DELIVERY' => 'supply_and_delivery', ]; foreach ($sections as $order_type => $key): $row = $terms_by_type[$order_type] ?? ['terms' => '', 'notes' => '']; ?>