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()
