/** * Nacita data daneho semestra * @param $semesterID - id semestra * @return array */ public function load($semesterID) { $sql = "SELECT id, year, semester_order, "; $sql .= DateConvert::DBtoSK("tuition_start") . " AS zac_uc,"; $sql .= DateConvert::DBtoSK("tuition_end") . " AS kon_uc,"; $sql .= DateConvert::DBtoSK("exam_start") . " AS zac_skus,"; $sql .= DateConvert::DBtoSK("exam_reparat_start") . " AS zac_opr,"; $sql .= DateConvert::DBtoSK("exam_end") . " AS kon_skus "; $sql .= "FROM semester\n WHERE id=\$1"; $this->dbh->query($sql, $semesterID); return $this->dbh->fetch_assoc(); }
/** * Nacita data daneho semestra * @param $semesterID - id semestra * @return array */ public function load($semesterID) { $sql = "SELECT id, rok, semester, "; $sql .= DateConvert::DBtoSK("zac_uc") . " AS zac_uc,"; $sql .= DateConvert::DBtoSK("kon_uc") . " AS kon_uc,"; $sql .= DateConvert::DBtoSK("zac_skus") . " AS zac_skus,"; $sql .= DateConvert::DBtoSK("zac_opr") . " AS zac_opr,"; $sql .= DateConvert::DBtoSK("kon_skus") . " AS kon_skus "; $sql .= "FROM semester\n WHERE id=\$1"; $this->dbh->query($sql, $semesterID); return $this->dbh->fetch_assoc(); }