Untitled

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <?php
        // put your code here
        $servername = "localhost";
        $username = "root";
        $password = "";
        $database = "exercici4";

        // Create connection
        $conn = new mysqli($servername, $username, $password, $database);

        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
        echo "Connected successfully";
        echo "<br>";

        // Store XML
        $xml = simplexml_load_file("menu.xml");
        foreach ($xml->menjar as $val) {
            $sql = "INSERT INTO apartatb VALUES ('$val->nom', '$val->preu', '$val->categoria', '$val->descripcio', $val->calories)";

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

        // Load XML
        $sql = "SELECT * FROM apartatb";
        $result = $conn->query($sql);

        echo sqlToXml($result, "menu", "menjar");

        function sqlToXml($queryResult, $rootElementName, $childElementName) {
            $xmlData = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
            $xmlData .= "<" . $rootElementName . "> \n";

            while ($record = mysqli_fetch_object($queryResult)) {
                /* Create the first child element */
                $xmlData .= "\t <" . $childElementName . "> \n";

                for ($i = 0; $i < mysqli_num_fields($queryResult); $i++) {
                    $fieldName = mysqli_fetch_field_direct($queryResult, $i)->name;

                    /* The child will take the name of the table column */
                    $xmlData .= "\t\t <" . $fieldName . ">";

                    /* We set empty columns with NULL, or you could set
                      it to '0' or a blank. */
                    if (!empty($record->$fieldName)) {
                        $xmlData .= $record->$fieldName;
                    } else {
                        $xmlData .= "null";
                    }
                    $xmlData .= "</" . $fieldName . "> \n";
                }
                $xmlData .= "\t</" . $childElementName . "> \n";
            }
            $xmlData .= "</" . $rootElementName . "> \n";

            return $xmlData;
        }
        ?>
    </body>
</html>