{"id":336,"date":"2023-03-29T11:07:16","date_gmt":"2023-03-29T11:07:16","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=336"},"modified":"2023-04-04T18:56:34","modified_gmt":"2023-04-04T18:56:34","slug":"ulesanded-5","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/ulesanded-5\/","title":{"rendered":"Teooriaeksam"},"content":{"rendered":"\n

J\u00e4rgmisena on vaja registreerunud eksamituppa kutsuda. K\u00f5igepealt n\u00e4ha, et kes \u00fcldse tulemas on. Ning p\u00e4rast \u00fclesannete lahendamist ja kontrollimist tuleb m\u00e4rkida, millised tulemused saadi. Selleks siis k\u00f5igepealt SELECT-lause nende registreerunute leidmiseks, kel veel teooriaeksam tegemata (punktide arv -1). Ning p\u00e4rast iga\u00fche juures UPDATE-lause, mis osalise punktid paika m\u00e4\u00e4rab. Et iga\u00fche andmed saaks mugavasti eraldi saata, selleks on iga nime taga olev sisestusv\u00e4li eraldi vormis, kus pannakse varjatud v\u00e4ljana kaasa ka vastava registreerunu id-number.\u00a0<\/p>\n\n\n\n

Teooriaeksam.php<\/strong><\/p>\n\n\n

\n<?php  \n require_once("konf.php");  \n if(!empty($_REQUEST["teooriatulemus"])){ \n $kask=$yhendus->prepare( \n "UPDATE jalgrattaeksam SET teooriatulemus=? WHERE id=?"); \n$kask->bind_param("ii", $_REQUEST["teooriatulemus"], $_REQUEST["id"]); $kask->execute(); \n } \n $kask=$yhendus->prepare("SELECT id, eesnimi, perekonnanimi   FROM jalgrattaeksam WHERE teooriatulemus=-1"); \n $kask->bind_result($id, $eesnimi, $perekonnanimi); \n $kask->execute(); \n?> \n<!doctype html> \n<html> \n <head> \n <title>Teooriaeksam<\/title> \n <\/head> \n <body> \n <table> \n <?php \n while($kask->fetch()){ \n echo " \n <tr> \n <td>$eesnimi<\/td> \n <td>$perekonnanimi<\/td> \n <td><form action=''> \n <input type='hidden' name='id' value='$id' \/> \n <input type='text' name='teooriatulemus' \/>\n <input type='submit' value='Sisesta tulemus' \/> \n <\/form> \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
Slaalom.php<\/strong><\/p>\n\n\n\n
Platsieksami juures \u00fcheks punktiks on slaalomis\u00f5it. Sinna p\u00e4\u00e4sevad need registreerunud, kes kogusid teooriaeksamil v\u00e4hemasti 9 punkti ning kes pole veel slaalomitulemust kirja saanud. Tulemus t\u00e4hendaks seda, et slaalomis\u00f5it on kas korras v\u00f5i eba\u00f5nnestunud. Kasutajaliides on <\/p>\n\n\n\n
inspektorile v\u00f5imalikult lihtne, et seda suudaks kergesti ka platsil kaasas oleva miniseadme pealt vaadata. <\/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 slaalom=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 slaalom=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 teooriatulemus>=9 AND slaalom=-1");  $kask->bind_result($id, $eesnimi, $perekonnanimi); \n $kask->execute(); \n?> \n<!doctype html> \n<html> \n <head> \n <title>Slaalom<\/title> \n <\/head> \n <body> \n <h1>Slaalom<\/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
Ringtee.php<\/strong><\/p>\n\n\n\n
Ringteeharjutus on korraldusliku poole pealt slaalomiga sarnane. Kuna platsiharjutuste l\u00e4bimise j\u00e4rjekord pole t\u00e4htis, siis ringteeharjutusele p\u00e4\u00e4semiseks on sama tingimus kui slaalomi puhul – ehk siis peab teooriaeksam tehtud olema.\u00a0<\/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 ringtee=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 ringtee=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 teooriatulemus>=9 AND ringtee=-1");  $kask->bind_result($id, $eesnimi, $perekonnanimi); \n $kask->execute(); \n?> \n<!doctype html> \n<html> \n <head> \n <title>Ringtee<\/title> \n <\/head> \n <body> \n <h1>Ringtee<\/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","protected":false},"excerpt":{"rendered":"
J\u00e4rgmisena on vaja registreerunud eksamituppa kutsuda. K\u00f5igepealt n\u00e4ha, et kes \u00fcldse tulemas on. Ning p\u00e4rast \u00fclesannete lahendamist ja kontrollimist tuleb m\u00e4rkida, millised tulemused saadi. Selleks siis k\u00f5igepealt SELECT-lause nende registreerunute leidmiseks, kel veel teooriaeksam tegemata (punktide arv -1). Ning p\u00e4rast iga\u00fche juures UPDATE-lause, mis osalise punktid paika m\u00e4\u00e4rab. Et iga\u00fche andmed saaks mugavasti eraldi saata, … Loe edasi Teooriaeksam<\/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-336","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/336","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=336"}],"version-history":[{"count":12,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/336\/revisions"}],"predecessor-version":[{"id":399,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/336\/revisions\/399"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}