Пример #1
0
 /**
  * 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();
 }
Пример #2
0
 /**
  * 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();
 }