29 lines
894 B
PHP
29 lines
894 B
PHP
<?php
|
|
include("../db.php");
|
|
|
|
$table = isset($_GET['table']) ? $_GET['table'] : '';
|
|
if (!preg_match('/^[a-zA-Z0-9_]+$/', $table)) {
|
|
die("Nombre de tabla no permitido.");
|
|
}
|
|
|
|
if (!isset($_POST['json'])) {
|
|
die("No se recibió JSON.");
|
|
}
|
|
|
|
$data = json_decode($_POST['json'], true);
|
|
if (!is_array($data)) {
|
|
die("JSON inválido.");
|
|
}
|
|
|
|
$inserted = 0;
|
|
foreach ($data as $row) {
|
|
$instruction = isset($row['instruction']) ? mysqli_real_escape_string($conn, $row['instruction']) : '';
|
|
$input = isset($row['input']) ? mysqli_real_escape_string($conn, $row['input']) : '';
|
|
$output = isset($row['output']) ? mysqli_real_escape_string($conn, $row['output']) : '';
|
|
$query = "INSERT INTO `$table` (instruction, input, output) VALUES ('$instruction', '$input', '$output')";
|
|
if (mysqli_query($conn, $query)) {
|
|
$inserted++;
|
|
}
|
|
}
|
|
echo "Se importaron $inserted registros.";
|