<?php
    include_once("../../cfg/db.php");
    $id = $db->escape(trim($_POST['model_id']));

    $new_model_name = $db->escape(trim(strtoupper($_POST['new_model_name'])));
    //$new_model_description = $db->escape(trim(strtoupper($_POST['new_model_description'])));
    $new_models_brand = $db->escape(trim($_POST['new_models_brand']));

    if(intval($db -> select("SELECT count(1) FROM source_car_model WHERE `name` = '$new_model_name' AND id != '$id'")) > 0){
        $arr['status'] = 0; //duplicate model name
    } 
    else {
        $update_query = "UPDATE `source_car_model` SET `name`='$new_model_name', `brand_id`='$new_models_brand' WHERE `id` = '$id'";
        $db->sql_query($update_query);

        $arr['status'] = 2; //success update
    }

    echo json_encode($arr);
?>