function __construct() { $this->DBconnect = DBconnect::getInstance(); $this->personal['surname'] = $_SESSION['surname']; $this->personal['name'] = $_SESSION['name']; $this->personal['id'] = $_SESSION['id']; $this->terminy = TerminDAO::getTerminyPedagoga($this->personal['id']); }
function __construct() { $this->DBconnect = DBconnect::getInstance(); $this->personal['surname'] = $_SESSION['surname']; $this->personal['name'] = $_SESSION['name']; $this->personal['id'] = $_SESSION['id']; $this->terminyVypsane = StudentDAO::getVypsaneTerminy($this->personal['id']); $this->terminyZapsane = StudentDAO::getZapsaneTerminy($this->personal['id']); }
public static function getMistnosti() { $rooms = array(); $DBconnect = DBconnect::getInstance(); $query = 'SELECT * FROM mistnosti m'; $table_result = $DBconnect->query($query); while ($row = $table_result->fetch_assoc()) { array_push($rooms, $row); } return $rooms; }
public static function getTerminyProId($id) { $terminy = array(); $DBconnect = DBconnect::getInstance(); $query = 'SELECT * FROM Vypsane_terminy v WHERE v.id_terminu = ' . $id; $table_result = $DBconnect->query($query); while ($row = $table_result->fetch_assoc()) { array_push($terminy, $row); } return $terminy; }
public static function getSubjects($id) { $subjects = array(); $DBconnect = DBconnect::getInstance(); $query = 'SELECT * FROM pedagogove_predmety p WHERE p.Pedagogove_kod_pedagoga = ' . $id; $table_result = $DBconnect->query($query); while ($row = $table_result->fetch_assoc()) { array_push($subjects, $row); } return $subjects; }
<?php include_once '../Controler/DBconnect.php'; $connect = DBconnect::getInstance(); session_start(); $table = getTable(); $query = 'SELECT * FROM ' . getTable() . ' WHERE prijmeni = \'' . $_POST['username'] . '\' AND heslo = \'' . $_POST['password'] . '\''; $redirectTo = ''; $table_result = $connect->query($query); if ($table_result->num_rows > 0) { $_SESSION['logged'] = 1; $table_row = $table_result->fetch_assoc(); if ($table == 'studenti') { $redirectTo = $_POST['role']; $_SESSION['id'] = $table_row['kod_studenta']; $_SESSION['name'] = $table_row['jmeno']; $_SESSION['surname'] = $table_row['prijmeni']; $_SESSION['page'] = "student"; } else { $redirectTo = $_POST['role']; $_SESSION['id'] = $table_row['kod_pedagoga']; $_SESSION['name'] = $table_row['jmeno']; $_SESSION['surname'] = $table_row['prijmeni']; $_SESSION['page'] = "teacher"; } print 'Přihlášení úspěšné'; } else { print 'Přihlášení neúspěšné, zkuste se přihlásit znovu prosím.'; } header("Refresh:2; url=../index.php?page=" . $redirectTo, true, 303); function getTable()