json parser by link with data entry in mysql?

Question

PHP

Good day, I'm trying to parse Json data from a url, I
wrote a small fragment of json_decode

<?php
$content = file_get_contents("https://hubofdata.ru/dataset/e7416648-e1f4-4feb-bc8a-454de729ab25/resource/2028ea46-cd87-45bb-ab39-4d68fb7082b6/download/edu.gov_2885_27.12.2011_recommended-books.json");

foreach (json_decode($content, true) as $eventrType => $events) {
    echo "<h1>Type: {$eventrType}</h1>";
foreach($events as $brand => $massiv)
print_r($massiv);

}
?>

Everything outputs, everything displays
I can’t figure out how to parse everything through an associative array in order to further write everything to the database

Answer 1

In recent versions of mysql there is a json data type.
What is the format of the array? you can make a recursive function that forms a single-level array ['full_name' => '...', ..., 'indx' => '...'] path "Primary general education" > "Textbooks, the content of which corresponds to the federal state educational standard of primary general education" > "Russian language" to be transmitted by id'shnik