<?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);
?>