File "server4.php"
Full Path: C:/wamp64/www/INTERPRETE2/backend/node_modules/web-streams-polyfill/dist/server4.php
File size: 1.84 KB
MIME-type: text/x-php
Charset: utf-8
<?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;
}