{"id":340,"date":"2023-03-29T11:07:52","date_gmt":"2023-03-29T11:07:52","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=340"},"modified":"2023-04-04T19:06:43","modified_gmt":"2023-04-04T19:06:43","slug":"ulesanded-6","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/ulesanded-6\/","title":{"rendered":"T\u00e4nav"},"content":{"rendered":"\n

T\u00e4navas\u00f5idule lastakse siis, kui m\u00f5lemad platsiharjutused edukalt l\u00e4bitud. Seet\u00f5ttu ka vastav pikem kontroll sealjuures. <\/p>\n\n\n

\n $kask=$yhendus->prepare("SELECT id, eesnimi, perekonnanimi   FROM jalgrattaeksam WHERE slaalom=1 AND ringtee=1 AND t2nav=-1"); \n<\/pre><\/div>\n\n\n
Muu osa aga eelmistele failidele suhteliselt sarnane.<\/p>\n\n\n\n
T\u00e4nav.php<\/strong><\/p>\n\n\n
\n<?php  \n require_once("konf.php");  \n if(!empty($_REQUEST["korras_id"])){ \n $kask=$yhendus->prepare( \n "UPDATE jalgrattaeksam SET t2nav=1 WHERE id=?"); \n$kask->bind_param("i", $_REQUEST["korras_id"]); \n$kask->execute(); \n } \n if(!empty($_REQUEST["vigane_id"])){ \n $kask=$yhendus->prepare( \n "UPDATE jalgrattaeksam SET t2nav=2 WHERE id=?"); \n$kask->bind_param("i", $_REQUEST["vigane_id"]); \n$kask->execute(); \n } \n $kask=$yhendus->prepare("SELECT id, eesnimi, perekonnanimi   FROM jalgrattaeksam WHERE slaalom=1 AND ringtee=1 AND t2nav=-1");  $kask->bind_result($id, $eesnimi, $perekonnanimi); \n $kask->execute(); \n?> \n<!doctype html> \n<html> \n <head> \n <title>T\u00e4navas\u00f5it<\/title> \n <\/head> \n <body> \n <h1>T\u00e4navas\u00f5it<\/h1> \n <table> \n <?php \n while($kask->fetch()){ \n echo " \n <tr> \n <td>$eesnimi<\/td> \n <td>$perekonnanimi<\/td> \n <td> \n <a href='?korras_id=$id'>Korras<\/a> \n <a href='?vigane_id=$id'>Eba\u00f5nnestunud<\/a> \n <\/td> \n<\/tr>\n "; \n} \n ?> \n<\/table> \n <\/body> \n<\/html> \n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Lubadeleht.php<\/strong><\/p>\n\n\n\n
L\u00f5petuslaua juures tasub k\u00f5iki eelnevaid andmeid n\u00e4ha. Et kui m\u00f5nel osalejal tekib k\u00fcsimusi, et kuhu maani ta v\u00e4lja j\u00f5udis, siis seal on paras koht tulemusi vaadata. Lihtsamal juhul kuvatakse tabeli sisu veebilehele. Ning piisavalt teadlik asjaosaline juba teab sealt v\u00e4lja vaadata, et milline number mida t\u00e4hendab.<\/p>\n\n\n
\n<?php  \n require_once("konf.php");  \n $kask=$yhendus->prepare( \n "SELECT id, eesnimi, perekonnanimi, teooriatulemus,  \n slaalom, ringtee, t2nav, luba FROM jalgrattaeksam;");  $kask->bind_result($id, $eesnimi, $perekonnanimi, $teooriatulemus,   $slaalom, $ringtee, $t2nav, $luba); \n $kask->execute(); \n?> \n<!doctype html> \n<html> \n <head> \n <title>L\u00f5petamine<\/title> \n <\/head> \n <body> \n <h1>L\u00f5petamine<\/h1> \n<table> \n <?php \n while($kask->fetch()){ \n echo " \n <tr> \n <td>$eesnimi<\/td> \n <td>$perekonnanimi<\/td> \n <td>$teooriatulemus<\/td> \n <td>$slaalom<\/td> \n <td>$ringtee<\/td> \n <td>$t2nav<\/td> \n <td>$luba<\/td> \n <\/tr> \n "; \n}\n ?> \n<\/table> \n <\/body> \n<\/html> \n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Lubadeleht.php ilusamalt<\/strong><\/p>\n\n\n\n
L\u00f5petaja t\u00f6\u00f6\u00fclesannete hulka kuulub ka lubade v\u00e4ljastamine – j\u00e4relikult ka see toimetus sobib siinse lehe juurde. Ning esimesi p\u00e4evi t\u00f6\u00f6l oleval ametnikul on mugavam vaadata selges\u00f5nalisi seletusi, kellel mis on korras ja mis mitte. Selle tarvis lisati v\u00e4ike alamprogramm asenduste tarbeks – numbrile vastavalt antakse v\u00e4lja sobiv tekst. N\u00f5nda n\u00e4eb allolev leht juba m\u00e4rgatavalt ametlikum v\u00e4lja. <\/p>\n\n\n
\n<?php  \n require_once("konf.php");  \n if(!empty($_REQUEST["vormistamine_id"])){ \n $kask=$yhendus->prepare( \n "UPDATE jalgrattaeksam SET luba=1 WHERE id=?"); \n$kask->bind_param("i", $_REQUEST["vormistamine_id"]); \n$kask->execute(); \n } \n $kask=$yhendus->prepare( \n "SELECT id, eesnimi, perekonnanimi, teooriatulemus,  \n slaalom, ringtee, t2nav, luba FROM jalgrattaeksam;"); \n $kask->bind_result($id, $eesnimi, $perekonnanimi, $teooriatulemus,   $slaalom, $ringtee, $t2nav, $luba); \n $kask->execute(); \n  \n function asenda($nr){ \n if($nr==-1){return ".";} \/\/tegemata \n if($nr== 1){return "korras";} \n if($nr== 2){return "eba\u00f5nnestunud";}\nreturn "Tundmatu number"; \n } \n?> \n<!doctype html> \n<html> \n <head> \n <title>L\u00f5petamine<\/title> \n <\/head> \n <body> \n <h1>L\u00f5petamine<\/h1> \n<table> \n <tr> \n <th>Eesnimi<\/th> \n <th>Perekonnanimi<\/th> \n <th>Teooriaeksam<\/th> \n <th>Slaalom<\/th> \n <th>Ringtee<\/th> \n <th>T\u00e4navas\u00f5it<\/th> \n <th>Lubade v\u00e4ljastus<\/th> \n <\/tr> \n <?php \n while($kask->fetch()){ \n $asendatud_slaalom=asenda($slaalom); \n $asendatud_ringtee=asenda($ringtee); \n $asendatud_t2nav=asenda($t2nav); \n $loalahter="."; \n if($luba==1){$loalahter="V\u00e4ljastatud";} \n if($luba==-1 and $t2nav==1){ \n $loalahter="<a href='?vormistamine_id=$id'>Vormista load<\/a>";  } \n echo " \n <tr> \n <td>$eesnimi<\/td> \n <td>$perekonnanimi<\/td> \n <td>$teooriatulemus<\/td> \n <td>$asendatud_slaalom<\/td> \n <td>$asendatud_ringtee<\/td> \n <td>$asendatud_t2nav<\/td> \n <td>$loalahter<\/td> \n <\/tr> \n "; \n} \n ?> \n<\/table> \n <\/body> \n<\/html>\n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
T\u00e4navas\u00f5idule lastakse siis, kui m\u00f5lemad platsiharjutused edukalt l\u00e4bitud. Seet\u00f5ttu ka vastav pikem kontroll sealjuures.  Muu osa aga eelmistele failidele suhteliselt sarnane. T\u00e4nav.php Lubadeleht.php L\u00f5petuslaua juures tasub k\u00f5iki eelnevaid andmeid n\u00e4ha. Et kui m\u00f5nel osalejal tekib k\u00fcsimusi, et kuhu maani ta v\u00e4lja j\u00f5udis, siis seal on paras koht tulemusi vaadata. Lihtsamal juhul kuvatakse tabeli sisu veebilehele. … Loe edasi T\u00e4nav<\/span> →<\/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-340","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":11,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/340\/revisions"}],"predecessor-version":[{"id":408,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/340\/revisions\/408"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}