private function getMax()
{
$query = Databaze::dotaz('SELECT COUNT(*) FROM vyhledavani');
$res = $query->fetch(PDO::FETCH_NUM);
if ($res !== false) {
$max = $res[0];
} else {
$max = 0;
}
return $max;
}
public static function pripojeni()
{
if (!isset(self::$spojeni)) {
$config = parse_ini_file('/../config.ini');
$server = $config['server'];
$user = $config['user'];
$password = $config['password'];
$db = $config['db'];
self::$spojeni = @new PDO("mysql:host={$server};dbname={$db}", $user, $password, self::$nastaveni);
}
return self::$spojeni;
}
private function auth($user, $password)
{
$query = Databaze::dotaz('SELECT password FROM pass WHERE user=?', array($user));
if ($query == false) {
return false;
}
$rowCount = $query->fetch(PDO::FETCH_NUM);
$rows = count($rowCount);
if ($rows === 1) {
$hash = $rowCount[0];
return password_verify($password, $hash);
} else {
return false;
}
}
public function handleGet()
{
if (isset($_GET['tofind'])) {
$toFind = htmlspecialchars(trim($_GET['tofind']));
if (empty($toFind)) {
$this->error_messages = "Název účtu k vyhledání chybí. Zadejte jej prosím.";
}
if (empty($this->error_messages)) {
$ip = $_SERVER['REMOTE_ADDR'];
$date = date('Y-m-d H:i:s', $_SERVER['REQUEST_TIME']);
Databaze::dotaz('INSERT INTO vyhledavani VALUES (?, ?, ?, ?)', array('', $ip, $toFind, $date));
$repos = $this->getFromGithub($toFind);
$repos = json_decode($repos, true);
//prisla-li zpet message, jmeno nema repo
if (isset($arr['message'])) {
print "Nebyly nalezeny žádné veřejné repozitáře k zadanému uživatelskému jménu.";
} else {
$this->printRepos($repos, $toFind);
}
}
}
}
public function vymazat($id)
{
$db = new Databaze();
$sql = "DELETE FROM typy\n WHERE id_typ = {$id}";
return $db->zpracovani($sql);
}
public function zmenitHeslo($id_u, $nove)
{
$db = new Databaze();
//GENEROVÁNÍ NOVÉHO SALTU
$nove_options = ['cost' => 10, 'salt' => uniqid(mt_rand(), true)];
$id = $db->pripravaProInput($id_u);
$n_heslo = $db->pripravaProInput(password_hash($nove, PASSWORD_BCRYPT, $nove_options));
$salt = $nove_options["salt"];
$sql = "UPDATE uzivatele SET heslo = '{$n_heslo}', salt = '{$salt}'\n WHERE id_uzivatel = {$id}";
return $db->zpracovani($sql);
}
public function vymazat($id)
{
$db = new Databaze();
$sql = "DELETE FROM objednavky\n WHERE id_objednavka = {$id}";
return $db->zpracovani($sql);
}
<?php
session_start();
if (isset($_SESSION['user']) && $_SESSION['timeout'] + 600 < time()) {
unset($_SESSION['user']);
session_destroy();
} else {
$_SESSION['timeout'] = time();
}
function nactiTridu($trida)
{
require "tridy/{$trida}.php";
}
spl_autoload_register("nactiTridu");
Databaze::pripojeni();
$stranka = new Strankovnik('Promazávání výpisu');
$promazavac = new Promazavac();
$stranka->printHead();
$stranka->printMenu();
if (isset($_POST['switch'])) {
$promazavac->handlePost();
}
$promazavac->setContent();
$stranka->printFooter();
