$servername = "asdasd";
$username = "asdasd";
$password = "asdasdasd";
$dbname = "servers";



    //read the json file contents

$files = scandir('ansible/');
foreach($files as $file) {

if($file == "." || $file == ".."){
} else {
$jsondata = file_get_contents('ansible/'.$file);
$data = json_decode($jsondata, true);

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$hostname = $data['ansible_facts']['ansible_hostname'];

echo 'Data For :'.$hostname;
echo '<br />';
echo '<br />';

echo $hostname;
echo '<br />';
$domainname = $data['ansible_facts']['ansible_domain'];
echo $domainname;
echo '<br />';
$vendorname = $data['ansible_facts']['ansible_system_vendor'];
echo $vendorname;
echo '<br />';
$productname = $data['ansible_facts']['ansible_product_name'];
echo $productname;
echo '<br />';

if($vendorname == "VMware, Inc."){
$machinetype = "VMware Guest";
echo $machinetype;
echo '<br />';
} else {
$machinetype = "Standalone";
echo $machinetype;
echo '<br />';
}

$operatingsystem = $data['ansible_facts']['ansible_distribution'];
echo $operatingsystem;
echo '<br />';
$osrelease = $data['ansible_facts']['ansible_distribution_version'];
echo $osrelease;
echo '<br />';
$machineserial = $data['ansible_facts']['ansible_product_serial'];
echo $machineserial;
echo '<br />';
echo '<br />';
echo '<br />';
echo '<br />';


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO hostname (id, systemname, domain, vendor, model, machinetype, os, osrelease, machineserial)
VALUES ('NULL','$hostname', '$domainname', '$vendorname','$productname','$machinetype','$operatingsystem','$osrelease','$machineserial')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
    echo '<br />';

       mysql_connect($servername,$username,$password) or die(mysql_error());
        mysql_select_db($dbname) or die(mysql_error());
        $query = mysql_query("SELECT * FROM hostname WHERE systemname LIKE '$hostname'") or die(mysql_error());
while($row = mysql_fetch_array($query)) {



$id = $row['id'];
echo $row['systemname'];
echo '<br />';


$interfacez = $data['ansible_facts']['ansible_interfaces'];

foreach($interfacez as $interf){
if($interf == "lo"){
}else{
if($interf == "eth0"){



$idevice = $data['ansible_facts']['ansible_eth0']['device'];
$iaddress = $data['ansible_facts']['ansible_eth0']['ipv4']['address'];
$imacaddress = $data['ansible_facts']['ansible_eth0']['macaddress'];
$igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
$istatus = $data['ansible_facts']['ansible_eth0']['active'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully ".$idevice;
echo '<br />';
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();


}elseif($interf == "eth1"){

$idevice = $data['ansible_facts']['ansible_eth1']['device'];
$iaddress = $data['ansible_facts']['ansible_eth1']['ipv4']['address'];
$imacaddress = $data['ansible_facts']['ansible_eth1']['macaddress'];
$igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
$istatus = $data['ansible_facts']['ansible_eth1']['active'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully ".$idevice;
echo '<br />';
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

} elseif($interf == "eth2"){
$idevice = $data['ansible_facts']['ansible_eth2']['device'];
$iaddress = $data['ansible_facts']['ansible_eth2']['ipv4']['address'];
$imacaddress = $data['ansible_facts']['ansible_eth2']['macaddress'];
$igateway = $data['ansible_facts']['ansible_default_ipv4']['gateway'];
$istatus = $data['ansible_facts']['ansible_eth2']['active'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO network (id, interface, ipaddress, macaddress, gateway, interfacestatus)
VALUES ('$id','$idevice', '$iaddress', '$imacaddress','$igateway','$istatus')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully ".$idevice;
    echo '<br />';
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();



}
}

}
}




} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();







}
}