{"id":313,"date":"2024-03-21T12:28:22","date_gmt":"2024-03-21T10:28:22","guid":{"rendered":"https:\/\/kirillsats.wordpress.com\/?page_id=313"},"modified":"2024-10-14T07:29:41","modified_gmt":"2024-10-14T07:29:41","slug":"ab-kinoteatr","status":"publish","type":"page","link":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313","title":{"rendered":"AB Kinoteatr"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image.png?w=1024\" alt=\"\" class=\"wp-image-314\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Protseduurid<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li> Andmete lisamine tabelisse FilmType (filmType ja Kirjeldus sisestab kasutaja kui k\u00e4ivatab protseduuri)<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-1.png?w=976\" alt=\"\" class=\"wp-image-318\"\/><\/figure>\n\n\n\n<p>Protseduuri k\u00e4ivitamine:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-3.png?w=529\" alt=\"\" class=\"wp-image-322\"\/><\/figure>\n\n\n\n<p>Tulemus:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-4.png?w=507\" alt=\"\" class=\"wp-image-323\"\/><\/figure>\n\n\n\n<p>2. Kustutamis protseduur, kustutab filmit\u00fc\u00fcp tema id j\u00e4rgi (kasutaja sisestab id ja siis filmt\u00fc\u00fcp kustutakse)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-9.png?w=636\" alt=\"\" class=\"wp-image-331\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-5.png?w=707\" alt=\"\" class=\"wp-image-325\"\/><\/figure>\n\n\n\n<p>3. Otsing sisestatud t\u00e4hte j\u00e4rgi (kasutaja sisestab filmit\u00fc\u00fcpi Esimine t\u00e4ht ja siis n\u00e4idetakse k\u00f5ik  filmit\u00fc\u00fcbifd)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-6.png?w=503\" alt=\"\" class=\"wp-image-327\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-7.png?w=451\" alt=\"\" class=\"wp-image-328\"\/><\/figure>\n\n\n\n<p>4. Uuendamis protseduur Kasutaja sisestab uuendatud filmit\u00fc\u00fcbi sisestatud id j\u00e4rgi<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-8.png?w=656\" alt=\"\" class=\"wp-image-330\" style=\"width:670px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-10.png?w=651\" alt=\"\" class=\"wp-image-333\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>ALTER TABLE <\/p>\n\n\n\n<p>ALTER TABLE tabelinimi ADD veergunimi t\u00fc\u00fcp &#8211; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8211; \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043d\u043e\u0432\u043e\u0433\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u0430 <\/p>\n\n\n\n<p>ALTER TABLE tabelinimi ADD veergunimi t\u00fc\u00fcp &#8211; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8211; \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u043e\u043b\u0431\u0446\u0430 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-11.png?w=561\" alt=\"\" class=\"wp-image-336\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-12.png?w=512\" alt=\"\" class=\"wp-image-338\"\/><\/figure>\n\n\n\n<p>5. Tabeli struktuur Muutmine<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-17.png?w=1017\" alt=\"\" class=\"wp-image-348\"\/><\/figure>\n\n\n\n<p>add:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-14.png?w=1024\" alt=\"\" class=\"wp-image-342\"\/><\/figure>\n\n\n\n<p>drop:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-15.png?w=1024\" alt=\"\" class=\"wp-image-344\"\/><\/figure>\n\n\n\n<p>6. hinne kategooria<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-18.png?w=673\" alt=\"\" class=\"wp-image-349\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-19.png?w=885\" alt=\"\" class=\"wp-image-350\"\/><\/figure>\n\n\n\n<p>\u0437\u0430\u0434\u0430\u043d\u0438\u0435 \u043d\u0430 \u043e\u0446\u0435\u043d\u043a\u0443 3:<\/p>\n\n\n\n<p>1.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-21.png?w=653\" alt=\"\" class=\"wp-image-353\" style=\"width:549px;height:auto\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-20.png?w=717\" alt=\"\" class=\"wp-image-352\" style=\"width:487px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-22.png?w=293\" alt=\"\" class=\"wp-image-355\" style=\"width:185px;height:auto\"\/><\/figure>\n\n\n\n<p>2. ZANR:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-24.png?w=643\" alt=\"\" class=\"wp-image-359\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-23.png?w=682\" alt=\"\" class=\"wp-image-357\"\/><\/figure>\n\n\n\n<p>3. kustutamine tabel nimega<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-25.png?w=475\" alt=\"\" class=\"wp-image-361\" style=\"width:620px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-26.png?w=678\" alt=\"\" class=\"wp-image-362\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u0417\u0430\u0434\u0430\u043d\u0438\u044f \u043d\u0430 \u043e\u0446\u0435\u043d\u043a\u0443 4:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-28.png?w=610\" alt=\"\" class=\"wp-image-365\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-27.png?w=1024\" alt=\"\" class=\"wp-image-364\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>2. alter <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-29.png?w=656\" alt=\"\" class=\"wp-image-367\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image-30.png?w=741\" alt=\"\" class=\"wp-image-368\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Kasutatud lingid:<\/p>\n\n\n\n<p><a href=\"https:\/\/moodle.edu.ee\/\">moodle<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><a href=\"https:\/\/kirillsats23.thkit.ee\/wp\">Kodulehele<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Protseduurid Protseduuri k\u00e4ivitamine: Tulemus: 2. Kustutamis protseduur, kustutab filmit\u00fc\u00fcp tema id j\u00e4rgi (kasutaja sisestab id ja siis filmt\u00fc\u00fcp kustutakse) 3. Otsing sisestatud t\u00e4hte j\u00e4rgi (kasutaja sisestab filmit\u00fc\u00fcpi Esimine t\u00e4ht ja siis n\u00e4idetakse k\u00f5ik filmit\u00fc\u00fcbifd) 4. Uuendamis protseduur Kasutaja sisestab uuendatud filmit\u00fc\u00fcbi sisestatud id j\u00e4rgi ALTER TABLE ALTER TABLE tabelinimi ADD veergunimi t\u00fc\u00fcp &#8211; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b [&hellip;]<\/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-313","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AB Kinoteatr - Kirill Sats &otilde;pimapp | portfoolio<\/title>\n<meta name=\"description\" content=\"Kinoteatr AB loomine\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB Kinoteatr - Kirill Sats &otilde;pimapp | portfoolio\" \/>\n<meta property=\"og:description\" content=\"Kinoteatr AB loomine\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313\" \/>\n<meta property=\"og:site_name\" content=\"Kirill Sats &otilde;pimapp | portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-14T07:29:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image.png?w=1024\" \/>\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=\"7 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313\",\"url\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313\",\"name\":\"AB Kinoteatr - Kirill Sats &otilde;pimapp | portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kirillsats.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image.png?w=1024\",\"datePublished\":\"2024-03-21T10:28:22+00:00\",\"dateModified\":\"2024-10-14T07:29:41+00:00\",\"description\":\"Kinoteatr AB loomine\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313#primaryimage\",\"url\":\"https:\\\/\\\/kirillsats.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image.png?w=1024\",\"contentUrl\":\"https:\\\/\\\/kirillsats.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image.png?w=1024\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/?page_id=313#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB Kinoteatr\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/kirillsats23.thkit.ee\\\/wp\\\/\",\"name\":\"Kirill Sats &otilde;pimapp | portfoolio\",\"description\":\"Noorem Tarkvaarendaja eriala\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kirillsats23.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":"AB Kinoteatr - Kirill Sats &otilde;pimapp | portfoolio","description":"Kinoteatr AB loomine","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:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313","og_locale":"et_EE","og_type":"article","og_title":"AB Kinoteatr - Kirill Sats &otilde;pimapp | portfoolio","og_description":"Kinoteatr AB loomine","og_url":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313","og_site_name":"Kirill Sats &otilde;pimapp | portfoolio","article_modified_time":"2024-10-14T07:29:41+00:00","og_image":[{"url":"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image.png?w=1024","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313","url":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313","name":"AB Kinoteatr - Kirill Sats &otilde;pimapp | portfoolio","isPartOf":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313#primaryimage"},"image":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313#primaryimage"},"thumbnailUrl":"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image.png?w=1024","datePublished":"2024-03-21T10:28:22+00:00","dateModified":"2024-10-14T07:29:41+00:00","description":"Kinoteatr AB loomine","breadcrumb":{"@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313#primaryimage","url":"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image.png?w=1024","contentUrl":"https:\/\/kirillsats.wordpress.com\/wp-content\/uploads\/2024\/03\/image.png?w=1024"},{"@type":"BreadcrumbList","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/?page_id=313#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kirillsats23.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"AB Kinoteatr"}]},{"@type":"WebSite","@id":"https:\/\/kirillsats23.thkit.ee\/wp\/#website","url":"https:\/\/kirillsats23.thkit.ee\/wp\/","name":"Kirill Sats &otilde;pimapp | portfoolio","description":"Noorem Tarkvaarendaja eriala","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kirillsats23.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=313"}],"version-history":[{"count":3,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/313\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/313\/revisions\/1019"}],"wp:attachment":[{"href":"https:\/\/kirillsats23.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}