File "get_empleados.php"

Full Path: C:/wamp64/www/Identifica_Piku/Carnet/get_empleados.php
File size: 2.03 KB
MIME-type: text/x-php
Charset: utf-8

<?php
header('Content-Type: application/json; charset=utf-8');
require_once '../connection.php';

$response = [
    "success" => false
];

// 1️⃣ SI NO HAY PARÁMETROS → MOSTRAR TODAS LAS BASES DE DATOS
if (!isset($_GET['db'])) {

    $databases = [];
    $result = mysqli_query($con, "SHOW DATABASES");

    while ($row = mysqli_fetch_row($result)) {
        $databases[] = $row[0];
    }

    $response["success"] = true;
    $response["mode"] = "list_databases";
    $response["databases"] = $databases;

    echo json_encode($response, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);
    exit;
}

$db = $_GET['db'];

// 2️⃣ SI SOLO HAY "db" → MOSTRAR TABLAS DE ESA BASE
if (!isset($_GET['table'])) {

    if (!mysqli_select_db($con, $db)) {
        $response["error"] = "No se pudo seleccionar la base '$db'";
        echo json_encode($response, JSON_PRETTY_PRINT);
        exit;
    }

    $tables = [];
    $result = mysqli_query($con, "SHOW TABLES");

    while ($row = mysqli_fetch_row($result)) {
        $tables[] = $row[0];
    }

    $response["success"] = true;
    $response["mode"] = "list_tables";
    $response["database"] = $db;
    $response["tables"] = $tables;

    echo json_encode($response, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);
    exit;
}

$table = $_GET['table'];

// 3️⃣ SI HAY db + table → DUMPEAR TABLA
if (!mysqli_select_db($con, $db)) {
    $response["error"] = "No se pudo seleccionar la base '$db'";
    echo json_encode($response, JSON_PRETTY_PRINT);
    exit;
}

$query = "SELECT * FROM `$table`";
$result = mysqli_query($con, $query);

if (!$result) {
    $response["error"] = "Error consultando la tabla: " . mysqli_error($con);
    echo json_encode($response, JSON_PRETTY_PRINT);
    exit;
}

$rows = [];
while ($row = mysqli_fetch_assoc($result)) {
    $rows[] = $row;
}

$response["success"] = true;
$response["mode"] = "dump_table";
$response["database"] = $db;
$response["table"] = $table;
$response["rows"] = $rows;

echo json_encode($response, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);
mysqli_close($con);
?>