<?php  
    include_once("../../cfg/db.php");

    if(!isset($_SESSION['user'])){
        exit();
    }

    $field_names = $_POST['field_names'];
    $bank_field_id = $_POST['bank_field_id'];  
    
    $db->sql_query("DELETE FROM `source_bank_fields_name` WHERE `bank_field_id` = '$bank_field_id'");

    foreach ($field_names as $data){
        $insert_data = $db->escape(strtoupper(trim($data)));
        $insert = "INSERT INTO `source_bank_fields_name`(`bank_field_id`, `name`) VALUES ('$bank_field_id','$insert_data')";
        // echo $insert; return;
        $db->sql_query($insert);
    }
?>