Tiny File Manager

Back Back Up Advanced Editor

<?php
$host = "localhost";
$user = "SANMARINO";
$pw = "sanmarino2021*";
$bd = "interprete";

$mysqli = new mysqli($host, $user, $pw, $bd);
$cliente = null;
$mensaje = "";

//---------------------Bloque de codigo para actualizar datos de proveedores registrados-------------------------
//----- BUSCAR PROVEEDOR POR NIT -----------------------------------------------
if ($_SERVER['REQUEST_METHOD'] === 'GET' && isset($_GET['nit'])) {
    $nit = $_GET['nit'];

$stmt = $mysqli->prepare("SELECT * FROM registros WHERE NIT = ?");
    $stmt->bind_param("s", $nit);
    $stmt->execute();
    $res = $stmt->get_result();

if ($res->num_rows > 0) {
        $cliente = $res->fetch_assoc();
        echo json_encode([
            "exito" => true,
            "cliente" => $cliente
        ]);
    } else {
        echo json_encode([
            "exito" => false,
            "mensaje" => "Proveedor no existe."
        ]);
    }
    $stmt->close();
    $mysqli->close();
    exit;
}

//----- ACTUALIZAR PROVEEDOR------------------------------//
if ($_SERVER['REQUEST_METHOD'] === 'POST' && $_POST['accion'] === 'actualizar') {
    $nit_original = $_POST['nit_original'];
    $nit = $_POST['NIT'];
    $razon = $_POST['RAZON_SOCIAL'];
    $email = $_POST['EMAIL'];

$stmt = $mysqli->prepare("UPDATE registros SET NIT = ?, RAZON_SOCIAL = ?, EMAIL = ? WHERE NIT = ?");
    $stmt->bind_param("ssss", $nit, $razon, $email, $nit_original);

if ($stmt->execute()) {
        echo json_encode([
            "exito" => true,
            "mensaje" => " ✅ Proveedor actualizado correctamente."
        ]);
    } else {
        echo json_encode([
            "exito" => false,
            "mensaje" => "Error al actualizar: " . $stmt->error
        ]);
    }

$stmt->close();
    $mysqli->close();
    exit;
}