<?php
$_req = "UPDATE CONTACTOS ";
$_set = "SET ACTIVO = 1";
$contact_nif = $bd_conn->real_escape_string($_POST["contact_nif"]);
$_where = " WHERE NIF = '" . $contact_nif . "' ";
if (isset($_POST["contact_type"])) {
    $contact_type = $bd_conn->real_escape_string($_POST["contact_type"]);
    if ($contact_type == "CONTACTO") {
        $_set .= ", CONTACTO = 1, ORGANIZACION = 0";
    }elseif ($contact_type == "ORGANIZACION") {
        $_set .= ", ORGANIZACION = 1, CONTACTO = 0";
    }else {
        $_set .= ", CONTACTO = 1";
    }
}
foreach ($_POST as $key => $value) {
    $value = $bd_conn->real_escape_string($value);
    switch ($key) {
        case 'contact_name':
            $_set .= ", NOMBRE = '" . $value . "'"; 
            break;
        case 'contact_lastname':
            $_set .= ", APELLIDO1 = '" . $value . "'"; 
            break;
        case 'contact_lastname2':
            $_set .= ", APELLIDO2 = '" . $value . "'"; 
            break;
        case 'contact_nif':
            $_set .= ", NIF = '" . $value . "'"; 
            break;
        case 'contact_direction':
            $_set .= ", DIRECCION_PER = '" . $value . "'"; 
            break;
        case 'contact_phone':
            $_set .= ", TLFNO1 = '" . $value . "'"; 
            break;
        case 'contact_email':
            $_set .= ", EMAIL1 = '" . $value . "'"; 
            break;
        case 'contact_direction_org':
            $_set .= ", DIRECCION_TRA = '" . $value . "'"; 
            break;
    }
}
$status = queryUpdate($bd_conn, $_req, $_set, $_where);
if ($status === 1) {
    $data[] = array ( 
        "status" => "OK!",
        "message" => "success : update contact success"
    );
}elseif ($status === 0) {
    $data[] = array ( 
        "status" => "NOT OK!",
        "message" => "error : no changes detected"
    );
}else{
    $data[] = array ( 
        "status" => "NOT OK!",
        "message" => "error : update contact error"
    );
}
//FUNCIONES================================================================
function queryUpdate($bd, $_req, $_set, $_where)
{
    $query = $_req . $_set . $_where;
    mysqli_query($bd, $query);
    return mysqli_affected_rows($bd);
}
?>