function vymaz_vykon($id_vykon)
{
    $db = napoj_db();
    if ($db) {
        $sql = <<<EOF
          DELETE FROM VYKON WHERE VYKON.ID_VYKON = "{$id_vykon}";
EOF;
        $ret = $db->exec($sql);
        return $ret;
    }
    return 0;
}
Beispiel #2
0
        <td><label for="priezvisko">Priezvisko</label></td>
		    <td><input type="text" name="priezvisko" id="priezvisko" size="30" value="<?php 
    if (isset($_POST['priezvisko'])) {
        echo $_POST['priezvisko'];
    } else {
        echo $po->priezvisko;
    }
    ?>
"></td>
		</tr>
    <tr>
      <td><label for="oddiel">Oddiel</label></td>
      <td><select name="oddiel">
      <option value="">-</option>
      <?php 
    $db = napoj_db();
    $sql = <<<EOF
         SELECT * FROM oddiely;
EOF;
    $result = $db->query($sql);
    while ($row1 = $result->fetchArray(SQLITE3_ASSOC)) {
        echo '<option value="' . $row1['id'] . '"';
        if (isset($_POST['oddiel'])) {
            if ($_POST['oddiel'] == $row1['id']) {
                echo 'selected';
            }
        } else {
            if ($po->oddiel == $row1['id']) {
                echo 'selected';
            }
        }
Beispiel #3
0
function nazov_a_datum_pretekov($id_preteku, $typ)
{
    $db = napoj_db();
    if ($db) {
        //echo $db->lastErrorMsg();
        $sql = <<<EOF
      SELECT
        NAZOV, DATUM FROM PRETEKY
        WHERE ID = "{$id_preteku}";
EOF;
        $ret = $db->query($sql);
        $row = $ret->fetchArray(SQLITE3_ASSOC);
        if ($typ == "nazov") {
            echo '<input type="hidden" name="' . $typ . '" id="' . $typ . '" value="' . $id_preteku . '">' . $row["NAZOV"];
        } elseif ($typ == "datum") {
            echo '<input type="hidden" name="' . $typ . '" id="' . $typ . '" value="' . $id_preteku . '">' . $row["DATUM"];
        }
        $db->close();
    } else {
        $db->close();
        return;
    }
    return;
}
Beispiel #4
0
    function uprav_pouzivatela($MENO, $PRIEZVISKO, $oddiel, $OS_I_C, $CHIP, $POZNAMKA, $uspech)
    {
        $db = napoj_db();
        $MENO2 = $MENO;
        $PRIEZVISKO2 = $PRIEZVISKO;
        $OS_I_C2 = $OS_I_C;
        $CHIP2 = strtoupper($CHIP);
        $POZNAMKA2 = $POZNAMKA;
        $uspech2 = htmlentities($uspech, ENT_QUOTES, "UTF-8");
        $sql = <<<EOF
       UPDATE POUZIVATELIA set MENO = "{$MENO2}" where ID="{$this->id}";
       UPDATE POUZIVATELIA set PRIEZVISKO = "{$PRIEZVISKO2}" where ID="{$this->id}";
       UPDATE POUZIVATELIA set ID_ODDIEL = "{$oddiel}" where ID="{$this->id}";
       UPDATE POUZIVATELIA set OS_I_C = "{$OS_I_C2}" where ID="{$this->id}";
       UPDATE POUZIVATELIA set CHIP = "{$CHIP2}" where ID="{$this->id}";
       UPDATE POUZIVATELIA set POZNAMKA = "{$POZNAMKA2}" where ID="{$this->id}";
       UPDATE POUZIVATELIA set USPECH = "{$uspech2}" where ID="{$this->id}";
EOF;
        $ret = $db->exec($sql);
        if (!$ret) {
            echo $db->lastErrorMsg();
        } else {
            //echo $db->changes(), " Record updated successfully\n";
        }
        $db->close();
    }
Beispiel #5
0
    static function odstran_duplicity()
    {
        $db = napoj_db();
        $sql = <<<EOF
           CREATE TABLE duplicity
      (ID INTEGER PRIMARY KEY   AUTOINCREMENT,
      ID_POUZ              TEXT    NOT NULL,
      ID_PRET        TEXT    NOT NULL,
      KAT        TEXT    NOT NULL,
      POZNAMKA TEXT
      );
EOF;
        $db->exec($sql);
        $sql = <<<EOF
          INSERT INTO duplicity(ID_POUZ, ID_PRET, KAT,POZNAMKA) SELECT PRIHLASENY.ID_POUZ, PRIHLASENY.ID_PRET, PRIHLASENY.KAT, PRIHLASENY.POZNAMKA FROM PRIHLASENY GROUP BY ID_PRET, ID_POUZ;
EOF;
        $db->exec($sql);
        $sql = <<<EOF
         DROP TABLE PRIHLASENY;
EOF;
        $db->exec($sql);
        $sql = <<<EOF
         ALTER TABLE duplicity RENAME to PRIHLASENY;
EOF;
        $db->exec($sql);
        // echo "Operation done successfully"."<br>";      ////////////////////////////
        $db->close();
    }
Beispiel #6
0
function Pridaj_do_tab_prihlas()
{
    $db = napoj_db();
    $sql = <<<EOF
      INSERT INTO POUZIVATELIA (
         MENO,PRIEZVISKO,OS_I_C,CHIP,POZNAMKA)
      VALUES ('jana', 'omg','asdasd',99,'omfg');
EOF;
    $ret = $db->exec($sql);
    if (!$ret) {
        echo $db->lastErrorMsg();
    } else {
        echo "Records created successfully" . "<br>";
    }
    $db->close();
}