{
"tables":{
"table1":{
"columns":{
"column1":"INT(11) AUTO_INCREMENT",
"column2":"VARCHAR(255)","column3":"TEXT(14)"
},
"mods":[
"PRIMARY KEY (`1`)"
]
},
"table2":{
"columns":{
"column1":"INT(11) AUTO_INCREMENT",
"column2":"INT(11)"
}
}
}
}CREATE TABLE `one` (`1` INT(11) AUTO_INCREMENT, `2` VARCHAR(255), `3` TEXT(10), PRIMARY KEY (`1`));
CREATE TABLE `two` (`1` INT(11) AUTO_INCREMENT, `2` INT(11), ));{
"data":{
"table1":{
"column":[
"column2","column3"
],
"data":[
["Text","Some more text"],
["Text","Another text.."]
]
},
"table2":{
"column":[
"column2"
],
"data":[
"4566"
]
}
}
}INSERT INTO `table1` (`column2`, `column3`) VALUES ('Text', 'Some more text');
INSERT INTO `table2` (`column2`) VALUES (4566);
function createTableFromJson(array $json){
$result = "";
if(isset($json["tables"])){
foreach($json["tables"] as $tableName => $data){
$result .= "CREATE TABLE `".$tableName."`";
if(isset($data["columns"]) && count($data["columns"]) >= 1){
$result .= " (";
$columnDefinations = [];
foreach($data["columns"] as $columnName => $columnDefination){
$columnDefinations[] = "`".$columnName."` ".$columnDefination."";
}
$result .= implode(", ", $columnDefinations);
if(isset($data["mods"])){
$result .= ", ".implode(", ", $data["mods"]);
}
$result .= ")";
}
$result .= ";".PHP_EOL;
}
}
return $result;
}
echo createTableFromJson(json_decode($твоя_строка_с_json));