{"id":1617,"date":"2025-09-30T09:25:32","date_gmt":"2025-09-30T07:25:32","guid":{"rendered":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/?page_id=1617"},"modified":"2025-09-30T09:26:15","modified_gmt":"2025-09-30T07:26:15","slug":"sonastik-2","status":"publish","type":"page","link":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/","title":{"rendered":"S\u00f5nastik"},"content":{"rendered":"<div class=\"dictionary\">\n<nav class=\"letters\"><a href=\"?letter=10\" class=\"letter \">$<\/a><a href=\"?letter=14\" class=\"letter \">B<\/a><a href=\"?letter=12\" class=\"letter \">C<\/a><a href=\"?letter=25\" class=\"letter \">D<\/a><a href=\"?letter=27\" class=\"letter \">E<\/a><a href=\"?letter=11\" class=\"letter \">F<\/a><a href=\"?letter=30\" class=\"letter \">G<\/a><a href=\"?letter=15\" class=\"letter \">I<\/a><a href=\"?letter=20\" class=\"letter \">J<\/a><a href=\"?letter=18\" class=\"letter \">M<\/a><a href=\"?letter=17\" class=\"letter \">N<\/a><a href=\"?letter=23\" class=\"letter \">P<\/a><a href=\"?letter=28\" class=\"letter \">R<\/a><a href=\"?letter=16\" class=\"letter \">S<\/a><a href=\"?letter=13\" class=\"letter \">T<\/a><a href=\"?letter=24\" class=\"letter \">V<\/a><\/nav><div class=\"terms-by-tags\" style=\"display: flex; flex-direction: column; gap: 40px\"><div class=\"tag-group\"><h3 class=\"tag-title\" style=\"background-color: #222222; color: white; padding: 10px\">CSS<\/h3><div class=\"terms\"><div class=\"term\"><strong>Border<\/strong><br>Joon v\u00f5i raam, mis \u00fcmbritseb HTML-i elementi.<\/div><div class=\"term\"><strong>Class<\/strong><br>CSS-i valija, mida saab kasutada mitmel elemendil sama stiili rakendamiseks.<\/div><div class=\"term\"><strong>CSS<\/strong><br>Cascading stylesheets (CSS) - veebilehe kujunduse loomiseks loodud fail.<\/div><div class=\"term\"><strong>Margin<\/strong><br>Ruumi hulk elemendi v\u00e4lisk\u00fcljel, mis eraldab seda teistest elementidest.<\/div><div class=\"term\"><strong>Media Query<\/strong><br>CSS-i reegel, mis rakendab stiile vastavalt seadme suurusele.<\/div><div class=\"term\"><strong>Padding<\/strong><br>Ruumi hulk elemendi sees, sisu ja piiri vahel.<\/div><div class=\"term\"><strong>Pseudo-class<\/strong><br>CSS-i valija, mis kirjeldab elemendi olekut, n\u00e4iteks hiirega \u00fcle minemist.<\/div><\/div><\/div><div class=\"tag-group\"><h3 class=\"tag-title\" style=\"background-color: #222222; color: white; padding: 10px\">HTML<\/h3><div class=\"terms\"><div class=\"term\"><strong>Body<\/strong><br><code>&lt;body&gt;<\/code> - element sisaldab kogu HTML-dokumendi sisu, nagu pealkirjad, l\u00f5igud, pildid, h\u00fcperlingid, tabelid, loendid jne.<\/div><div class=\"term\"><strong>Br<\/strong><br><code>&lt;br&gt;<\/code> - element reavahetuse lisamiseks.<\/div><div class=\"term\"><strong>Button<\/strong><br><code>&lt;button&gt;<\/code> - silt m\u00e4\u00e4rab veebilehel kl\u00f5psatava nupu, millega kasutajad saavad suhelda.\r\n<br><br>\r\n<pre>\r\n&lt;button type=\"button\"&gt;Kl\u00f5psake mind!&lt;\/button&gt;\r\n<\/pre><\/div><div class=\"term\"><strong>Comment<\/strong><br><code>&lt;!-- kommentaar --&gt;<\/code> Brauser ignoreerib teksti.<\/div><div class=\"term\"><strong>Doctype<\/strong><br><\/div><div class=\"term\"><strong>Footer<\/strong><br><code>&lt;footer&gt;<\/code> - HTML element, kus pannakse veebilehe jalus.<\/div><div class=\"term\"><strong>Form<\/strong><br><code>&lt;form&gt;<\/code> - silt HTML-is kasutatakse kasutaja sisendi kogumiseks.<\/div><div class=\"term\"><strong>H1<\/strong><br><code>&lt;h1&gt;<\/code> - silt on veebilehe suurim ja t\u00e4htsaim pealkiri. Seda kasutatakse tavaliselt lehe pealkirja v\u00f5i p\u00f5hiteema n\u00e4itamiseks.<\/div><div class=\"term\"><strong>Header<\/strong><br><code>&lt;header&gt;<\/code> - HTML element, kuhu pannakse veebilehe p\u00e4is.<\/div><div class=\"term\"><strong>HTML<\/strong><br>Hypertext Markup Language - veebisisu loomiseks ja struktureerimiseks kasutatav standardkeel.<\/div><div class=\"term\"><strong>Input<\/strong><br><code>&lt;input&gt;<\/code> - HTML-elementi kasutatakse veebivormides interaktiivsete v\u00e4ljade loomiseks, et v\u00f5tta kasutajalt andmeid vastu.\r\n<br><br>\r\n<pre>\r\n&lt;input type=\u201dtext\u201d name=\u201deesnimi\u201d placeholder=\u201dSisesta eesnimi\u201d\r\n&lt;input type=\u201demail\u201d name=\u201demail\u201d placeholder=\u201dSisesta e-post\u201d&gt;\r\n&lt;input type=\u201dpassword\u201d name=\u201dparool\u201d placeholder=\u201dSisesta parool\u201d&gt;\r\n<\/pre>\r\n\r\n&nbsp;<\/div><div class=\"term\"><strong>Main<\/strong><br><code>&lt;main&gt;<\/code> - silt on struktuurne element, mis esindab dokumendi p\u00f5hisisu.<\/div><div class=\"term\"><strong>Nav<\/strong><br><code>&lt;nav&gt;<\/code> - HTML-element t\u00e4histab lehe osa, mis on m\u00f5eldud navigeerimislinkide jaoks, kas sama dokumendi sees v\u00f5i teistele dokumentidele.<\/div><div class=\"term\"><strong>Select\/option<\/strong><br><code>&lt;select&gt;<\/code> \/ <code>&lt;option&gt;<\/code> \u2013 rippmen\u00fc\u00fc valikute esitamiseks.\r\n<br><br>\r\n<pre>\r\n&lt;select name=\"cars\" id=\"cars\"&gt;\r\n    &lt;option value=\"volvo\"&gt;Volvo&lt;\/option&gt;\r\n    &lt;option value=\"saab\"&gt;Saab&lt;\/option&gt;\r\n    &lt;option value=\"mercedes\"&gt;Mercedes&lt;\/option&gt;\r\n    &lt;option value=\"audi\"&gt;Audi&lt;\/option&gt;\r\n&lt;\/select&gt;\r\n<\/pre><\/div><div class=\"term\"><strong>Textarea<\/strong><br><code>&lt;textarea&gt;<\/code> - silt m\u00e4\u00e4rab mitmerealise tekstisisestusv\u00e4lja.<\/div><div class=\"term\"><strong>Title<\/strong><br><code>&lt;title&gt;<\/code> - m\u00e4\u00e4rab HTML-dokumendi pealkirja.<\/div><div class=\"term\"><strong>Viewport<\/strong><br>Brauseri n\u00e4htav ala, kuhu veebileht kuvatakse.<\/div><\/div><\/div><div class=\"tag-group\"><h3 class=\"tag-title\" style=\"background-color: #222222; color: white; padding: 10px\">IT<\/h3><div class=\"terms\"><div class=\"term\"><strong>Backend<\/strong><br>Rakenduse serveripoolne osa, mis tegeleb andmebaaside, \u00e4riloogika ja turvalisusega (nt PHP, Python).<\/div><div class=\"term\"><strong>CI (continuous integration)<\/strong><br>Pidev integreerimine - arendusprotsess, kus koodimuudatused testitakse ja liidetakse automaatselt \u00fchtsesse hoidlasse.<\/div><div class=\"term\"><strong>Code refactoring<\/strong><br>Koodi korrastamine ja t\u00e4iustamine ilma selle v\u00e4list toimimist muutmata (loetavuse ja efektiivsuse parandamine).<\/div><div class=\"term\"><strong>Compiler<\/strong><br>Programm, mis t\u00f5lgib programmeerimiskeeles kirjutatud koodi masinkoodiks, mida arvuti protsessor suudab t\u00e4ita.<\/div><div class=\"term\"><strong>Debugger<\/strong><br>Abiprogramm (silur), mis v\u00f5imaldab koodi samm-sammult l\u00e4bi k\u00e4ia ja uurida muutujate v\u00e4\u00e4rtusi vea leidmiseks.<\/div><div class=\"term\"><strong>Debugging<\/strong><br>Silumine ehk tarkvarast vigade otsimise ja eemaldamise protsess.<\/div><div class=\"term\"><strong>Deploy<\/strong><br>Koodi sisestamine\/paigaldamine serverisse, et see oleks l\u00f5ppkasutajatele k\u00e4ttesaadav ja k\u00e4ivitatav.<\/div><div class=\"term\"><strong>Event driven language<\/strong><br>S\u00fcndmusp\u00f5hine keel, kus programmi kulgu m\u00e4\u00e4ravad s\u00fcndmused (nt hiireklikk, klahvivajutus). N\u00e4iteks JavaScript.<\/div><div class=\"term\"><strong>Framework<\/strong><br>Raamistik ehk tarkvaraplatvorm, mis pakub valmis t\u00f6\u00f6riistu ja struktuuri rakenduse kiiremaks arendamiseks (nt React).<\/div><div class=\"term\"><strong>Frontend<\/strong><br>Rakenduse kliendipoolne osa, mida kasutaja n\u00e4eb ja millega suhtleb (nt HTML, CSS, JavaScript).<\/div><div class=\"term\"><strong>git<\/strong><br>Versioonihalduss\u00fcsteem, mis v\u00f5imaldab j\u00e4lgida failide muudatusi ja teha koost\u00f6\u00f6d mitme arendaja vahel.<\/div><\/div><\/div><div class=\"tag-group\"><h3 class=\"tag-title\" style=\"background-color: #222222; color: white; padding: 10px\">PHP<\/h3><div class=\"terms\"><div class=\"term\"><strong>$_POST[?]<\/strong><br>Superglobaalne massiiv andmete saamiseks, mis saadeti vormi kaudu POST-meetodiga.\r\n<br><br>\r\n<pre>\r\n$nimi = $_POST['kasutaja'];\r\n<\/pre><\/div><div class=\"term\"><strong>$_REQUEST[?]<\/strong><br>Massiiv, mis sisaldab nii <code>$_GET<\/code>, <code>$_POST<\/code> kui ka <code>$_COOKIE<\/code> andmeid.\r\n<br><br>\r\n<pre>\r\necho $_REQUEST[\"linn\"].\" on \u00f5ige\";\r\n<\/pre><\/div><div class=\"term\"><strong>bind_param(?)<\/strong><br>Seob muutujad ettevalmistatud p\u00e4ringu k\u00fcsim\u00e4rkidega (?).\r\ns - string\r\ni - integer\r\nd - double\/float\r\n\r\n<br><br>\r\n<pre>\r\n$query = $connect->prepare(\"INSERT INTO valimised (president, pilt, punktid, avalik, lisamisaeg) VALUES (?, ?, ?, ?, NOW())\");\r\n$query->bind_param(\"ssii\", $president, $pilt, $punktid, $avalik);\r\n<\/pre><\/div><div class=\"term\"><strong>bind_result(?)<\/strong><br>Seob p\u00e4ringu tulemused konkreetsete muutujatega.\r\n<br><br>\r\n<pre>\r\n$query = $connect->prepare(\"SELECT id, president, pilt, punktid, lisamisaeg FROM valimised\");\r\n$query->bind_result($id, $president, $pilt, $punktid, $lisamisaeg);\r\n<\/pre><\/div><div class=\"term\"><strong>echo<\/strong><br><code>echo<\/code> on m\u00e4rks\u00f5na, mida kasutatakse stringide, muutujate ja HTML-sisu otse brauserisse v\u00f5i standardv\u00e4ljundisse v\u00e4ljastamiseks.\r\n<br><br>\r\n<pre>echo \"Tere!\";<\/pre><\/div><div class=\"term\"><strong>execute()<\/strong><br>K\u00e4ivitab eelnevalt ettevalmistatud p\u00e4ringu.\r\n<br><br>\r\n<pre>\r\n$query->execute();\r\n<\/pre><\/div><div class=\"term\"><strong>fetch()<\/strong><br><\/div><div class=\"term\"><strong>include(?)<\/strong><br>Kaasab faili. Kui faili ei leita, v\u00e4ljastatakse hoiatus, kuid skript t\u00f6\u00f6tab edasi.\r\n<br><br>\r\n<pre>\r\ninclude (\"header.php\");\r\n<\/pre><\/div><div class=\"term\"><strong>new mysqli(hostname,?,?,?)<\/strong><br>Loeb uue \u00fchenduse MySQL andmebaasiga (serverinimi, kasutaja, parool, andmebaasinimi)\r\n<br><br>\r\n<pre>\r\n    $servername = \"localhost\";\r\n    $username = \"nikita\";\r\n    $password = \"1234\";\r\n    $dbname = \"nikita\";\r\n    $connect = new mysqli($servername, $username, $password, $dbname);\r\n    $connect->set_charset(\"utf8\");\r\n<\/pre><\/div><div class=\"term\"><strong>prepare(?)<\/strong><br>Valmistab ette SQL-p\u00e4ringu (turvalisuse huvides, kaitseb SQL-s\u00fcstide eest).\r\n<br><br>\r\n<pre>\r\n$query = $connect->prepare(\"SELECT id, president, pilt, punktid, lisamisaeg FROM valimised\");\r\n<\/pre><\/div><div class=\"term\"><strong>require_once(?)<\/strong><br>Sama mis <code>require<\/code>, kuid kontrollib, et faili kaasataks ainult \u00fcks kord.\r\n<br><br>\r\n<pre>\r\nrequire_once \"functions.php\";\r\n<\/pre><\/div><div class=\"term\"><strong>require(?)<\/strong><br>Kaasab faili. Kui faili ei leita, tekkib viga (fatal error) ja skript seiskub.\r\n<br><br>\r\n<pre>\r\nrequire (\"config.php\");\r\n<\/pre><\/div><\/div><\/div><\/div><\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1617","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>S\u00f5nastik - Nikita Litvinenko Portfoolio<\/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:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"S\u00f5nastik - Nikita Litvinenko Portfoolio\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Litvinenko Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-30T07:26:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/sonastik-2\\\/\",\"url\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/sonastik-2\\\/\",\"name\":\"S\u00f5nastik - Nikita Litvinenko Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2025-09-30T07:25:32+00:00\",\"dateModified\":\"2025-09-30T07:26:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/sonastik-2\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/sonastik-2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/sonastik-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"S\u00f5nastik\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/\",\"name\":\"Nikita Litvinenko Portfoolio\",\"description\":\"Noorem tarkvaraarendaja\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitalitvinenko24.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":"S\u00f5nastik - Nikita Litvinenko Portfoolio","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:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/","og_locale":"et_EE","og_type":"article","og_title":"S\u00f5nastik - Nikita Litvinenko Portfoolio","og_url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/","og_site_name":"Nikita Litvinenko Portfoolio","article_modified_time":"2025-09-30T07:26:15+00:00","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/","url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/","name":"S\u00f5nastik - Nikita Litvinenko Portfoolio","isPartOf":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/#website"},"datePublished":"2025-09-30T07:25:32+00:00","dateModified":"2025-09-30T07:26:15+00:00","breadcrumb":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/sonastik-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"S\u00f5nastik"}]},{"@type":"WebSite","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/#website","url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/","name":"Nikita Litvinenko Portfoolio","description":"Noorem tarkvaraarendaja","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1617"}],"version-history":[{"count":2,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1617\/revisions"}],"predecessor-version":[{"id":1619,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1617\/revisions\/1619"}],"wp:attachment":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}