Clash Royale CLAN TAG#URR8PPP

inserting 4 different files into 1 SQL table row in php

As the title says, i want to parse 4 different files and insert them into 1 sql row. I have parsed the files so i have the information, however its not inserting into my table.
This is the code I have. I eliminated the actual sql names and values to save time. My two main questions are 1) is this the right way to do this and 2) is there a better way.

<?php

$connect = mysqli_connect("reserve1", "root", "","server_31");
$dir = "/Users/Administrator/Desktop/Reserve1";
if (is_dir($dir))
if ($dh = opendir($dir))

foreach(glob("*.json") as $filename)
$data = file_get_contents($filename);
$array = json_decode($data, true);
foreach($array[0]as $row)
$sql = "INSERT INTO servers_updated (---)
VALUES ('---)";
$connect->query($sql);



foreach(glob("*_processor.json") as $filename)
$data = file_get_contents($filename);
$info = json_decode($data, true);
foreach($info[1] as $row)
$sql = "INSERT INTO servers_updated
(--- ) VALUES (---)";
$connect->query($sql);


foreach(glob("*_drives.json") as $filename)
$data = file_get_contents($filename);
$info = json_decode($data, true);
foreach($info[1] as $row)
$sql=" INSERT INTO servers_updated (---) VALUES (---)";
$connect->query($sql);


foreach(glob("*_memory.json") as $filename)
$data = file_get_contents($filename);
$stuff = json_decode($data, true);
foreach($stuff[1] as $row)
$sql =" INSERT INTO servers_updated
(--- ) VALUES (----)";
$connect->query($sql);







?>


}

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.