<?php
$xml=simplexml_load_file("demo_xml.xml") or die("Error: Cannot create object"); // Get All Files AS Object

// Get All Files AS Array
//$path = "demo_xml.xml";
//$file_get = file_get_contents($path);
//$load = simplexml_load_string($file_get);
//$get_json = json_encode($load);
//$result = json_decode($get_json, true);

$id = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->ID;
$name = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->Name;
$room_caption = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->SingleAcc;
$mainBed = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->MainBed;
$extraBed = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->ExtraBed;
$minimumStay = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->MinimumStay;


$start_date = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->Season[0]->Period->Begin;
$end_date = $xml->City[0]->Hotel->Pricelist[0]->Room[0]->Season[0]->Period->End;
$begin = strtotime($start_date);
$end = strtotime($end_date);
$date = $end - $begin;
$results = $date / 86400;


$maximumStay = $results;


$servername = "localhost";
$username = "frodo";
$password = "qwerty";
$dbname = "xml_db";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed:");
}


$sql = "CREATE TABLE xml (
room_id  INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
room_caption VARCHAR(30) NOT NULL,
mainBed VARCHAR(30) NOT NULL,
extraBed VARCHAR(30) NOT NULL,
minimumStay VARCHAR(30) NOT NULL,
maximumStay VARCHAR(30) NOT NULL,
)";



$msql = "INSERT INTO xml (room_id, `name`, room_caption, mainBed, extraBed, minimumStay, maximumStay) VALUES ($id, $name, $room_caption, $mainBed, $extraBed, $minimumStay, $maximumStay)";

if ($conn->query($msql) === true) {
    echo "Ok";
} else {
    echo "Error";
}


$get_sql = "SELECT * FROM xml";
$result = $conn->query($get_sql);

if ($result->num_rows > 0) {

    while($row = $result->fetch_assoc()) {
        echo "room_id: " . $row["room_id"]. " name: " . $row["name"]. " room_caption: " . $row["room_caption"]. "mainBed: " . $row["mainBed"]. " extraBed: " . $row["extraBed"]. " minimumStay: " . $row["minimumStay"]. "maximumStay: " . $row["maximumStay"]."<br>";
    }
} else {
    echo "no results";
}