{"id":156,"date":"2023-03-10T12:51:01","date_gmt":"2023-03-10T12:51:01","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=156"},"modified":"2023-03-10T12:51:01","modified_gmt":"2023-03-10T12:51:01","slug":"uue-laulu-lisamine","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/uue-laulu-lisamine\/","title":{"rendered":"Uue laulu lisamine"},"content":{"rendered":"\n<p>Lisamiseks on vaja lisamisvormi ja salvestuskohta. Kui \u00fclalpoolses n\u00e4ites kippus m\u00f5nev\u00f5rra segadust tekitama, et lisamisvorm avanes vaid vastaval viitel vajutades, siis siin p\u00fc\u00fctud lisamine v\u00f5imalikult lihtsaks teha. Lisamislahter on kohe lehe avamisel olemas. Ning samal lehel p\u00fc\u00fctakse pealkiri kinni ja lisatakse andmed tabelisse. Lisamisaja v\u00e4\u00e4rtuseks NOW() annab serverikella praeguse aja. Kommentaariks lisatakse algul t\u00fchi tekst, p\u00e4rast saab sinna kasutajate juttu juurde paigutada.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n&lt;?php \n $yhendus=new mysqli(&quot;localhost&quot;, &quot;juku&quot;, &quot;kala&quot;, &quot;jukubaas1&quot;);  if(!empty($_REQUEST&#x5B;&quot;uuepealkiri&quot;])){ \n $kask=$yhendus-&gt;prepare( \n &quot;INSERT INTO laulud(pealkiri, lisamisaeg, kommentaarid) VALUES(?, NOW(), &#039; &#039;)&quot;); \n $kask-&gt;bind_param(&quot;s&quot;, $_REQUEST&#x5B;&quot;uuepealkiri&quot;]); \n $kask-&gt;execute(); \n echo $yhendus-&gt;error; \n header(&quot;Location: $_SERVER&#x5B;PHP_SELF]&quot;); \n $yhendus-&gt;close(); \n exit(); \n } \n?&gt; \n&lt;!doctype html&gt; \n&lt;html&gt; \n &lt;head&gt; \n &lt;title&gt;Laulud&lt;\/title&gt; \n &lt;\/head&gt; \n &lt;body&gt; \n &lt;h1&gt;Laulud&lt;\/h1&gt; \n&lt;form action=&quot;?&quot;&gt; \n Uue laulu pealkiri:  \n &lt;input type=&quot;text&quot; name=&quot;uuepealkiri&quot; \/&gt; \n &lt;input type=&quot;submit&quot; value=&quot;Lisa laul&quot; \/&gt; \n&lt;\/form&gt; \n &lt;\/body&gt; \n&lt;\/html&gt; \n&lt;?php \n $yhendus-&gt;close(); \n?&gt; \n\n<\/pre><\/div>\n\n\n<p>K\u00f5igepealt ilmub pealkirja lisamise lahter<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/03\/laul2.png\" alt=\"\" class=\"wp-image-157\" \/><\/figure>\n\n\n\n<p>Sinna v\u00f5ib kirjutada uue laulu pealkirja, vajutada lisamisnuppu ning ongi see laul tabelis kirjas.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/03\/laul1.png\" alt=\"\" class=\"wp-image-158\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Lisamiseks on vaja lisamisvormi ja salvestuskohta. Kui \u00fclalpoolses n\u00e4ites kippus m\u00f5nev\u00f5rra segadust tekitama, et lisamisvorm avanes vaid vastaval viitel vajutades, siis siin p\u00fc\u00fctud lisamine v\u00f5imalikult lihtsaks teha. Lisamislahter on kohe lehe avamisel olemas. Ning samal lehel p\u00fc\u00fctakse pealkiri kinni ja lisatakse andmed tabelisse. Lisamisaja v\u00e4\u00e4rtuseks NOW() annab serverikella praeguse aja. Kommentaariks lisatakse algul t\u00fchi tekst, &hellip; <a href=\"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/uue-laulu-lisamine\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Uue laulu lisamine<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/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-156","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/pages\/156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/comments?post=156"}],"version-history":[{"count":0,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/pages\/156\/revisions"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/eng\/wp-json\/wp\/v2\/media?parent=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}