{"id":2082,"date":"2025-09-25T07:56:49","date_gmt":"2025-09-25T07:56:49","guid":{"rendered":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082"},"modified":"2025-09-25T10:19:22","modified_gmt":"2025-09-25T10:19:22","slug":"dfandmevahetusvormingud-xml-json-yamldf","status":"publish","type":"page","link":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082","title":{"rendered":"Andmevahetusvormingud XML\/JSON\/YAML"},"content":{"rendered":"\n

PHP ja json<\/strong><\/p>\n\n\n\n

<?php\n$xml = simplexml_load_file("autod.xml");\n$json = json_encode($xml, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE);\nfile_put_contents("autod.json", $json);\necho "Konverteerimine valmis Vaata faili autod json";<\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
XML andmete lugemine jQuery abil<\/strong><\/p>\n\n\n\n
<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="UTF-8">\n    <meta name="viewport" content="width=device-width, initial-scale=1.0">\n    <title>jquery ja XML<\/title>\n    <script src="\/\/code.jquery.com\/jquery-1.11.2.min.js"><\/script>\n    <script>\n        $(document).ready(function(){\n            $.ajax({\n                type: "GET",\n                url: "autod.xml", \n                dataType: "xml",\n                success: kuvaXML,\n                error: vigaXML\n            });\n        });\n\n        function vigaXML(){\n            $("#container").append('<p style="color:red;">Probleemid XML failiga!<\/p>');\n        }\n\n        function kuvaXML(xml){\n            $(xml).find("Reis").each(function(){\n                var sihtkoht = $(this).find("Sihtkoht").text();\n                var lennujaam = $(this).find("Lennujaam").text();\n                var hind = $(this).find("Hind").text();\n                var alguskuupaev = $(this).find("Transport Alguskuup\u00e4ev").text();\n                var kirjeldus = $(this).find("Transport Kirjeldus").text();\n                var loppkuupaev = $(this).find("L\u00f5ppkuup\u00e4ev").text();\n                var reisikorraldaja = $(this).find("Reisikorraldaja").text();\n                var transport = $(this).find("Transport").attr("type");\n                \n                $("#container").append(\n                    '<h2>' + sihtkoht + '<\/h2>' +\n                    'Lennujaam: ' + lennujaam + '<br>' +\n                    'Hind: ' + hind + ' EUR<br>' +\n                    'Transport: ' + transport + '<br>' +\n                    'Alguskuup\u00e4ev: ' + alguskuupaev + '<br>' +\n                    'L\u00f5ppkuup\u00e4ev: ' + loppkuupaev + '<br>' +\n                    'Kirjeldus: ' + kirjeldus + '<br>' +\n                    'Reisikorraldaja: ' + reisikorraldaja + '<br><br>'\n                );\n            });\n        }\n    <\/script>\n<\/head>\n<body>\n<div id="container">\n<\/div>\n<\/body>\n<\/html>\n<\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
JSON<\/strong> andmete lugemine jQuery abi<\/strong><\/p>\n\n\n\n
<!DOCTYPE html>\n<html lang="et">\n<head>\n    <meta charset="UTF-8">\n    <meta name="viewport" content="width=device-width, initial-scale=1.0">\n    <title>Reiside Info - JSON<\/title>\n    <script src="\/\/code.jquery.com\/jquery-1.11.2.min.js"><\/script>\n    <script>\n        $(document).ready(function(){\n            $.ajax({\n                type: "GET",\n                url: "autod.json",  \n                dataType: "json",   \n                success: kuvaJSON,\n                error: vigaJSON\n            });\n        });\n\n        function vigaJSON(){\n            $("#container").append('<p style="color:red;">Probleemid JSON failiga!<\/p>');\n        }\n\n        function kuvaJSON(json){\n            var table = '<table border="1" cellpadding="5" cellspacing="0">' +\n                '<thead>' +\n                '<tr>' +\n                '<th>Sihtkoht<\/th>' +\n                '<th>Lennujaam<\/th>' +\n                '<th>Hind (EUR)<\/th>' +\n                '<th>Transport<\/th>' +\n                '<th>Alguskuup\u00e4ev<\/th>' +\n                '<th>L\u00f5ppkuup\u00e4ev<\/th>' +\n                '<th>Kirjeldus<\/th>' +\n                '<th>Reisikorraldaja<\/th>' +\n                '<\/tr>' +\n                '<\/thead>' +\n                '<tbody>';\n            \n            $.each(json.Reis, function(index, reis){\n                var sihtkoht = reis.Sihtkoht;\n                var lennujaam = reis.Lennujaam;\n                var hind = reis.Hind;\n                var alguskuupaev = reis.Transport.Alguskuup\u00e4ev;\n                var kirjeldus = reis.Transport.Kirjeldus;\n                var loppkuupaev = reis.L\u00f5ppkuup\u00e4ev;\n                var reisikorraldaja = reis.Reisikorraldaja;\n                var transport = reis.Transport['@attributes'].type;  \n\n                table += '<tr>' +\n                    '<td>' + sihtkoht + '<\/td>' +\n                    '<td>' + lennujaam + '<\/td>' +\n                    '<td>' + hind + '<\/td>' +\n                    '<td>' + transport + '<\/td>' +\n                    '<td>' + alguskuupaev + '<\/td>' +\n                    '<td>' + loppkuupaev + '<\/td>' +\n                    '<td>' + kirjeldus + '<\/td>' +\n                    '<td>' + reisikorraldaja + '<\/td>' +\n                    '<\/tr>';\n            });\n\n            table += '<\/tbody><\/table>';\n            $("#container").append(table);\n        }\n    <\/script>\n<\/head>\n<body>\n<div id="container">\n<\/div>\n<\/body>\n<\/html>\n<\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
PHP + JSON veebileht <\/strong><\/p>\n\n\n\n
<?php\n$json = file_get_contents('autod.json');\n$data = json_decode($json, true);\n?>\n\n<!DOCTYPE html>\n<html lang="et">\n<head>\n    <meta charset="UTF-8">\n    <meta name="viewport" content="width=device-width, initial-scale=1.0">\n    <title>Reiside Info<\/title>\n    <style>\n        table {\n            width: 100%;\n            border-collapse: collapse;\n        }\n        th, td {\n            padding: 10px;\n            border: 1px solid #ddd;\n            text-align: left;\n        }\n        th {\n            background-color: #f2f2f2;\n        }\n    <\/style>\n<\/head>\n<body>\n\n<div id="container">\n    <h2>Reiside Info<\/h2>\n    <table>\n        <thead>\n        <tr>\n            <th>Sihtkoht<\/th>\n            <th>Lennujaam<\/th>\n            <th>Hind (EUR)<\/th>\n            <th>Transport<\/th>\n            <th>Alguskuup\u00e4ev<\/th>\n            <th>L\u00f5ppkuup\u00e4ev<\/th>\n            <th>Kirjeldus<\/th>\n            <th>Reisikorraldaja<\/th>\n        <\/tr>\n        <\/thead>\n        <tbody>\n        <?php\n        foreach ($data['Reis'] as $reis) {\n            $transportType = isset($reis['Transport']['@attributes']['type']) ? $reis['Transport']['@attributes']['type'] : '\u041d\u0435 \u0443\u043a\u0430\u0437\u0430\u043d\u043e';\n\n            echo "<tr>";\n            echo "<td>" . htmlspecialchars($reis['Sihtkoht']) . "<\/td>";\n            echo "<td>" . htmlspecialchars($reis['Lennujaam']) . "<\/td>";\n            echo "<td>" . htmlspecialchars($reis['Hind']) . "<\/td>";\n            echo "<td>" . htmlspecialchars($transportType) . "<\/td>";\n            echo "<td>" . htmlspecialchars($reis['Transport']['Alguskuup\u00e4ev']) . "<\/td>";\n            echo "<td>" . htmlspecialchars($reis['L\u00f5ppkuup\u00e4ev']) . "<\/td>";\n            echo "<td>" . htmlspecialchars($reis['Transport']['Kirjeldus']) . "<\/td>";\n            echo "<td>" . htmlspecialchars($reis['Reisikorraldaja']) . "<\/td>";\n            echo "<\/tr>";\n        }\n        ?>\n        <\/tbody>\n    <\/table>\n<\/div>\n\n<\/body>\n<\/html>\n<\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Lisame CSS ja teeme v\u00f5imalus lisada uued andmed<\/strong><\/p>\n\n\n\n
if ($_SERVER['REQUEST_METHOD'] === 'POST') {\n    $newReis = [\n        "@attributes" => ["id" => (count($data['Reis']) + 1)],\n        "Sihtkoht" => $_POST['sihtkoht'],\n        "Lennujaam" => $_POST['lennujaam'],\n        "Hind" => $_POST['hind'],\n        "Transport" => [\n            "@attributes" => ["type" => $_POST['transport']],\n            "Alguskuup\u00e4ev" => $_POST['alguskuupaev'],\n            "Kirjeldus" => $_POST['kirjeldus']\n        ],\n        "L\u00f5ppkuup\u00e4ev" => $_POST['loppkuupaev'],\n        "Reisikorraldaja" => $_POST['reisikorraldaja']\n    ];\n\n\n    $data['Reis'][] = $newReis;\n\n    file_put_contents($jsonFile, json_encode($data, JSON_PRETTY_PRINT));\n\n    header('Location: ' . $_SERVER['PHP_SELF']);\n    exit();\n}<\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Vaata tulemus<\/a><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
PHP ja json XML andmete lugemine jQuery abil JSON andmete lugemine jQuery abi PHP + JSON veebileht Lisame CSS ja teeme v\u00f5imalus lisada uued andmed Vaata tulemus<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2082","page","type-page","status-publish","hentry"],"yoast_head":"\nAndmevahetusvormingud XML\/JSON\/YAML - Marija Gorbunova portfoolio TARpv23<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Andmevahetusvormingud XML\/JSON\/YAML - Marija Gorbunova portfoolio TARpv23\" \/>\n<meta property=\"og:description\" content=\"PHP ja json XML andmete lugemine jQuery abil JSON andmete lugemine jQuery abi PHP + JSON veebileht Lisame CSS ja teeme v\u00f5imalus lisada uued andmed Vaata tulemus\" \/>\n<meta property=\"og:url\" content=\"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082\" \/>\n<meta property=\"og:site_name\" content=\"Marija Gorbunova portfoolio TARpv23\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-25T10:19:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/marijagorbunova23.thkit.ee\/wp\/wp-content\/uploads\/2025\/09\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png\" \/>\n\t<meta property=\"og:image:width\" content=\"772\" \/>\n\t<meta property=\"og:image:height\" content=\"757\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082\",\"url\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082\",\"name\":\"Andmevahetusvormingud XML\\\/JSON\\\/YAML - Marija Gorbunova portfoolio TARpv23\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png\",\"datePublished\":\"2025-09-25T07:56:49+00:00\",\"dateModified\":\"2025-09-25T10:19:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082#primaryimage\",\"url\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png\",\"contentUrl\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png\",\"width\":772,\"height\":757},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?page_id=2082#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Andmevahetusvormingud XML\\\/JSON\\\/YAML\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/\",\"name\":\"Marija Gorbunova portfoolio TARpv23\",\"description\":\"Järgmine WordPress veebileht\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/marijagorbunova23.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Andmevahetusvormingud XML\/JSON\/YAML - Marija Gorbunova portfoolio TARpv23","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082","og_locale":"et_EE","og_type":"article","og_title":"Andmevahetusvormingud XML\/JSON\/YAML - Marija Gorbunova portfoolio TARpv23","og_description":"PHP ja json XML andmete lugemine jQuery abil JSON andmete lugemine jQuery abi PHP + JSON veebileht Lisame CSS ja teeme v\u00f5imalus lisada uued andmed Vaata tulemus","og_url":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082","og_site_name":"Marija Gorbunova portfoolio TARpv23","article_modified_time":"2025-09-25T10:19:22+00:00","og_image":[{"width":772,"height":757,"url":"https:\/\/marijagorbunova23.thkit.ee\/wp\/wp-content\/uploads\/2025\/09\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082","url":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082","name":"Andmevahetusvormingud XML\/JSON\/YAML - Marija Gorbunova portfoolio TARpv23","isPartOf":{"@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082#primaryimage"},"image":{"@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082#primaryimage"},"thumbnailUrl":"https:\/\/marijagorbunova23.thkit.ee\/wp\/wp-content\/uploads\/2025\/09\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png","datePublished":"2025-09-25T07:56:49+00:00","dateModified":"2025-09-25T10:19:22+00:00","breadcrumb":{"@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082#primaryimage","url":"https:\/\/marijagorbunova23.thkit.ee\/wp\/wp-content\/uploads\/2025\/09\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png","contentUrl":"https:\/\/marijagorbunova23.thkit.ee\/wp\/wp-content\/uploads\/2025\/09\/2D7D9916-90A7-404E-87C1-FBF3348B2566.png","width":772,"height":757},{"@type":"BreadcrumbList","@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?page_id=2082#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/marijagorbunova23.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Andmevahetusvormingud XML\/JSON\/YAML"}]},{"@type":"WebSite","@id":"https:\/\/marijagorbunova23.thkit.ee\/wp\/#website","url":"https:\/\/marijagorbunova23.thkit.ee\/wp\/","name":"Marija Gorbunova portfoolio TARpv23","description":"Järgmine WordPress veebileht","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/marijagorbunova23.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/2082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2082"}],"version-history":[{"count":6,"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/2082\/revisions"}],"predecessor-version":[{"id":2099,"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/2082\/revisions\/2099"}],"wp:attachment":[{"href":"https:\/\/marijagorbunova23.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}