Example #1
0
    static function vrat_pouzivatela($ID)
    {
        $db = napoj_db();
        $sql = <<<EOF
       SELECT * FROM POUZIVATELIA WHERE ID = {$ID};
EOF;
        $sql1 = <<<EOF
         SELECT * from POUZIVATELIA WHERE ID={$ID};
EOF;
        $count = 0;
        if (is_numeric($ID)) {
            $ret = $db->query($sql);
            $ret2 = $db->query($sql1);
            $count = $ret2->fetchArray(PDO::FETCH_NUM);
        }
        if ($count > 0) {
            //echo "Records got successfully\n";
            while ($row = $ret->fetchArray(SQLITE3_ASSOC)) {
                $p = new self();
                $p->nacitaj($row['ID'], $row['MENO'], $row['PRIEZVISKO'], $row['ID_ODDIEL'], $row['OS_I_C'], $row['CHIP'], $row['POZNAMKA'], $row['USPECH']);
                return $p;
            }
            $db->close();
        } else {
            echo 'Zvoleny pouzivatel neexistuje';
        }
    }