<?php

$json = json_decode(file_get_contents("categories.json"), true)['categories'];
foreach ($json as $elem) {
    print_r($elem);
}

$link = mysqli_connect('localhost', 'root', '');

$sql = "DROP DATABASE categories";
mysqli_query($link, $sql);

$sql = "CREATE DATABASE cats";
mysqli_query($link, $sql);

$sql = "CREATE TABLE cats.categories (id INT NOT NULL AUTO_INCREMENT, id_category INT, name VARCHAR(255), alias VARCHAR(255))";
mysqli_query($link, $sql);
$sql = "CREATE TABLE cats.category_child (id INT NOT NULL AUTO_INCREMENT, id_category INT, id_child INT)";
mysqli_query($link, $sql);

foreach ($json as $elem) {
    $stmt = mysqli_prepare($link, "INSERT INTO cats.categories (id_category, name, alias) VALUES (?, ?, ?)");
    mysqli_stmt_bind_param($stmt, "iss", $elem['id'], $elem['name'], $elem['alias']);
    mysqli_stmt_execute($stmt);
    var_dump(mysqli_error($link));
    mysqli_stmt_close($stmt);

}

?>