<<<'PHP' PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ] ); } catch (PDOException $e) { die('Database connection failed: ' . $e->getMessage()); } PHP , 'index.php' => <<<'PHP' JSON → MySQL Importer

Upload JSON Files

PHP , 'import.php' => <<<'PHP' $tmpName) { $fileName = $_FILES['json_files']['name'][$index]; $tableName = preg_replace('/[^a-zA-Z0-9_]/', '_', pathinfo($fileName, PATHINFO_FILENAME)); $json = file_get_contents($tmpName); $data = json_decode($json, true); if (!is_array($data) || empty($data)) { echo "

❌ {$fileName}: Invalid or empty JSON

"; continue; } if (!is_array($data[0])) { echo "

❌ {$fileName}: JSON must be an array of objects

"; continue; } $columns = array_keys($data[0]); $colsSql = []; foreach ($columns as $col) { $colSafe = preg_replace('/[^a-zA-Z0-9_]/', '_', $col); $colsSql[] = "`$colSafe` TEXT"; } $pdo->exec("CREATE TABLE IF NOT EXISTS `$tableName` ( id INT AUTO_INCREMENT PRIMARY KEY, " . implode(',', $colsSql) . " )"); $placeholders = implode(',', array_fill(0, count($columns), '?')); $colNames = '`' . implode('`,`', $columns) . '`'; $stmt = $pdo->prepare("INSERT INTO `$tableName` ($colNames) VALUES ($placeholders)"); foreach ($data as $row) { $stmt->execute(array_values($row)); } echo "

✅ {$fileName}: Imported into table {$tableName}

"; } PHP ]; foreach ($files as $filename => $content) { if (file_exists($filename)) { echo "⚠️ {$filename} already exists — skipped
"; continue; } file_put_contents($filename, $content); echo "✅ {$filename} created
"; } echo "
Done. You can now delete unpack.php.";