File "update_user.php"

Full Path: C:/wamp64/www/PERSONAL/Personal/update_user.php
File size: 1 KB
MIME-type: text/x-php
Charset: utf-8

<?php
include('../connection.php');

$id          = $_POST['id'];
$cedula      = $_POST['cedula'];
$nombre      = $_POST['nombre'];
$apellido    = $_POST['apellido'];
$rh          = $_POST['rh'];
$ccosto      = $_POST['ccosto'];
$descripcion = $_POST['descripcion'];
$cargo       = $_POST['cargo'];
$area        = $_POST['area'];
$rango       = $_POST['rango'];

$sql = "UPDATE `empleados` SET 
        `cedula`      = '$cedula',
        `nombre`      = UPPER('$nombre'),
        `apellido`    = UPPER('$apellido'),
        `rh`          = UPPER('$rh'),
        `ccosto`      = UPPER('$ccosto'),
        `descripcion` = UPPER('$descripcion'),
        `cargo`       = UPPER('$cargo'),
        `area`        = UPPER('$area'),
        `rango`       = '$rango'
        WHERE id = '$id'";

$query = mysqli_query($con, $sql);
if ($query == true) {
    $data = array('status' => 'success');
    echo json_encode($data);
} else {
    $data = array('status' => 'failed');
    echo json_encode($data);
}