public static function brojKazniDnevno()
{
$id = $_SESSION["ID"];
$baza = new Baza();
$upit = "select parking from korisnik where idkorisnik='{$id}';";
$rezultat = $baza->selectDB($upit);
$red = $rezultat->fetch_row();
$id_parking = $red[0];
$tablica = "<div class=\"container\"></div><table class=\"table table-striped table-hover\"><caption><h2><strong>Broj kazni dnevno</strong></h2></caption>";
$tablica .= "<thead><tr><th>Datum</th><th>Broj kazni</th></tr></thead><tbody>";
$upit = "select date(vrijeme), count(date(vrijeme))from kazna where parking='{$id_parking}' group by date(vrijeme) limit 30;";
$rezultat = $baza->selectDB($upit);
while ($red = $rezultat->fetch_row()) {
$tablica .= "<tr><td>{$red['0']}</td>";
$tablica .= "<td>{$red['1']}</td></tr>";
}
$tablica .= "</tbody></table>";
echo $tablica;
}
public static function autentikacija($korIme, $lozinka)
{
$baza = new Baza();
$korisnik = new Korisnik();
$upit = "SELECT tip_korisnika, idkorisnik, korisnicko_ime,ime,prezime,email,lozinka,zakljucan FROM korisnik where korisnicko_ime = '{$korIme}' or email='{$korIme}'";
$rezultat = $baza->selectDB($upit);
if ($rezultat->num_rows == 1) {
list($tip_korisnika, $id_korisnika, $korIme, $ime, $prezime, $email, $lozinka2, $zakljucan) = $rezultat->fetch_array();
$korisnik->set_podaci($tip_korisnika, $id_korisnika, $korIme, $ime, $prezime, $email);
if ($zakljucan == 1) {
Dnevnik::prijava($korIme, -1);
return -1;
}
if ($lozinka == $lozinka2) {
self::kreirajSesiju($tip_korisnika, $id_korisnika, $korIme, $ime, $prezime, $email);
$upit2 = "update korisnik set pokusaj = 0 where idkorisnik ='{$id_korisnika}'";
$rezultat2 = $baza->selectDB($upit2);
Dnevnik::prijava($korIme, 1);
return $tip_korisnika;
}
if ($lozinka != $lozinka2) {
Dnevnik::prijava($korIme, -1);
$upit2 = "update korisnik set pokusaj = pokusaj+1 where idkorisnik = '{$id_korisnika}'";
$rezultat2 = $baza->selectDB($upit2);
$upit3 = "select pokusaj from korisnik where idkorisnik = '{$id_korisnika}'";
$rezultat3 = $baza->selectDB($upit3);
$broj = $rezultat3->fetch_array();
$broj2 = $broj['pokusaj'];
if ($broj2 >= 3) {
$kljucaj = "update korisnik set zakljucan = 1 where idkorisnik ='{$id_korisnika}'";
$rezultat4 = $baza->selectDB($kljucaj);
}
return 0;
} else {
header("Location: greske.php?id=0");
}
}
}
public static function otkljucani()
{
$tablica = "<table class=\"table table-striped table-hover\"><caption><h2><strong>Otkljucani korisnici</strong></h2></caption>";
$tablica .= "<thead><tr><th>Korisnicko ime</th><th>Ime</th><th>Prezime</th><th>Email</th><th>Tip korisnika</th></tr></thead><tbody>";
$baza = new Baza();
$upit = "select korisnicko_ime,ime,prezime,email,tip_korisnika,idkorisnik from korisnik where zakljucan = 0 order by korisnicko_ime";
$rezultat = $baza->selectDB($upit);
while ($red = $rezultat->fetch_row()) {
$tablica .= "<tr><td>{$red['0']}</td><td>{$red['1']}</td><td>{$red['2']}</td><td>{$red['3']}</td><td>{$red['4']}</td>";
$tablica .= "<td><a href=\"controler/otkljucaj_zakljucaj.php?id={$red['5']}&tip=0\">Zakljucaj</a></td></tr>";
}
$tablica .= "</tbody></table>";
echo $tablica;
}
<?php
// session_start();
include './baza.class.php';
$baza = new Baza();
header('charset=utf-8');
$datum = date('Y-m-d H:i:s');
if (isset($_REQUEST['UserName'])) {
$UserName = $_REQUEST['UserName'];
} else {
$UserName = null;
}
if ($UserName != null) {
$upit = "SELECT * FROM user WHERE username='******'";
$rezultat = $baza->selectDB($upit);
$nesto = $rezultat->fetch_array();
if ($rezultat->num_rows != 0) {
echo json_encode(array("id" => $nesto['iduser'], "Ime" => $nesto['ime'], "Prezime" => $nesto['prezime'], "Dob" => $nesto['datum_rod'], "Status" => $nesto['status']), JSON_UNESCAPED_UNICODE);
} else {
$ispis = "profil_neuspjeh";
}
echo $ispis;
} else {
$ispis = "profil_nepostojeci";
echo $ispis;
}
header("Location: greske.php?id_greske=14");
exit;
}
if (isset($_POST['kreiraj'])) {
$baza = new Baza();
$parking = $_POST['parking'];
$broj_mjesta = $_POST['broj'];
$broj_mjesta = $_POST['broj'] == "" ? "NULL" : "'{$broj_mjesta}'";
$opis = $_POST['opis'];
$opis = $_POST['opis'] == "" ? "NULL" : "'{$opis}'";
$cijena = $_POST['cijena'];
$cijena = $_POST['cijena'] == "" ? "NULL" : "'{$cijena}'";
$vrijeme = $_POST['vrijeme'];
$vrijeme = $_POST['vrijeme'] == "" ? "NULL" : "'{$vrijeme}'";
$upit = "insert into parking values(default, '{$parking}',{$opis},{$broj_mjesta},{$cijena},{$vrijeme});";
$rezutlat = $baza->selectDB($upit);
header("Location: administrator.php");
}
//
?>
<div class="container">
<h1 class="page-header">Uredi parkiralište</h1>
<div class="col-md-6" role="main">
<div class="forma_okvir">
<form role="form" class="form-horizontal" id="forma" name="froma"
action="<?php
echo $_SERVER['PHP_SELF'];
?>
"
<?php
include './baza.class.php';
$baza = new Baza();
$json = $_GET['json'];
$data = json_decode($json, true);
$name = $data['Name'];
$lastname = $data['Lastname'];
$username = $data['Username'];
$password = $data['Password'];
$dob = $data['DOB'];
$email = $data['Email'];
$greska = 0;
$rezultat = "error";
$upit = "select * from user where username ='******'";
$rezultat_korime = $baza->selectDB($upit);
if ($rezultat_korime->num_rows != 0) {
$greska = 1;
$rezultat = "username exists";
}
$upit = "select * from user where email ='" . $email . "'";
$rezultat_email = $baza->selectDB($upit);
if ($rezultat_email->num_rows != 0) {
$greska = 2;
$rezultat = "email taken";
}
if ($greske == 0) {
$upitB = "insert into user(ime, prezime, email, username, password, datum_rod, tip_korisnika_idtip_korisnika)" . "values ('{$name}','{$lastname}','{$email}','{$username}','{$password}','{$dob}', 1)";
if ($baza->updateDB($upitB)) {
$rezultat = "uspjeh";
} else {
} elseif ($tablica2 == "tip_cijene") {
$upit2 .= " where idtip_cijene = {$id2}";
} elseif ($tablica2 == "tip_dogadjaja") {
$upit2 .= " where idtip_dogadjaja = {$id2}";
} elseif ($tablica2 == "tip_karte") {
$upit2 .= " where idtip_karte = {$id2}";
} elseif ($tablica2 == "tip_korisnika") {
$upit2 .= " where idtip_korisnika = {$id2}";
} elseif ($tablica2 == "tip_vremena_naplate") {
$upit2 .= " where idtip_vremena_naplate = {$id2}";
} elseif ($tablica2 == "vozilo") {
$upit2 .= " where registracijske_oznake = {$id2}";
} else {
$upit2 .= " where id = {$id2}";
}
$baza->selectDB($upit2);
header("Location: tablice.php");
exit;
}
$header_upit = "show columns from {$tablica}";
$headeri = $baza->selectDB($header_upit);
$upit = "select * from {$tablica} where id = {$id}";
if ($tablica == "korisnik") {
$upit = "select * from {$tablica} where idkorisnik = {$id}";
} elseif ($tablica == "kazna") {
$upit = "select * from {$tablica} where idkazna = {$id}";
} elseif ($tablica == "parking") {
$upit = "select * from {$tablica} where idparking = {$id}";
} elseif ($tablica == "slike") {
$upit = "select * from {$tablica} where id = {$id}";
} elseif ($tablica == "tip_cijene") {
public static function sveKarte()
{
$id = $_SESSION["ID"];
$baza = new Baza();
$upit = "select registracijske_oznake from vozilo where korisnik='{$id}';";
$rezultat = $baza->selectDB($upit);
$red = $rezultat->fetch_row();
$oznake = $red[0];
$tablica = "<div class=\"container\"></div><table id=\"tablica\" class=\"table table-striped table-hover\"><caption><h2><strong>Sve kupljene karte</strong></h2></caption>";
$tablica .= "<thead><tr><th>Vrijeme kupnje</th><th>Vrijeme prodaje</th><th>Parking</th><th>Iznos</th></tr></thead><tbody>";
$upit = "select k.vrijeme_kupnje,k.vrijeme_isteka,p.ime,k.iznos,id from karta as k, parking as p where k.vozilo='{$oznake}' and k.parking=p.idparking; ";
$rezultat = $baza->selectDB($upit);
while ($red = $rezultat->fetch_row()) {
$tablica .= "<tr><td>{$red['0']}</td>";
$tablica .= "<td>{$red['1']}</td>";
$tablica .= "<td>{$red['2']}</td>";
$tablica .= "<td>{$red['3']}</td>";
}
$tablica .= "</tbody></table>";
echo $tablica;
}
include './baza.class.php';
$baza = new Baza();
$datum = date('Y-m-d H:i:s');
if (isset($_REQUEST['UserName'])) {
$UserName = $_REQUEST['UserName'];
} else {
$UserName = null;
}
if (isset($_REQUEST['Password'])) {
$Password = $_REQUEST['Password'];
} else {
$Password = null;
}
if ($UserName != null && $Password != null) {
$upit = "SELECT * FROM user WHERE username='******'";
$rezultat = $baza->selectDB($upit);
$nesto = $rezultat->fetch_array();
if ($rezultat->num_rows != 0 && $nesto['password'] == $Password) {
$id = $nesto['iduser'];
$upit_hash = "SELECT * FROM hashbase WHERE naziv='login_uspjeh'";
$rezultat_hash = $baza->selectDB($upit_hash);
$dohvat = $rezultat_hash->fetch_array();
$hash = $dohvat['vrijednost'];
} else {
$upit_hash = "SELECT * FROM hashbase WHERE naziv='login_neuspjeh'";
$rezultat_hash = $baza->selectDB($upit_hash);
$dohvat = $rezultat_hash->fetch_array();
$hash = $dohvat['vrijednost'];
}
echo json_encode(array("Status" => $hash, "Id" => $id), JSON_UNESCAPED_UNICODE);
} else {
<?php
// session_start();
header('charset=utf-8');
include './baza.class.php';
$baza = new Baza();
$datum = date('Y-m-d H:i:s');
header('charset=utf-8');
if (isset($_REQUEST['sezona'])) {
$sezona = $_REQUEST['sezona'];
} else {
$sezona = null;
}
if ($sezona != null) {
$upit = "SELECT * FROM sezone_has_lovina WHERE id_sezona ='{$sezona}'";
$rezultat = $baza->selectDB($upit);
while ($nesto = $rezultat->fetch_array()) {
$temp = $nesto['id_lovina'];
$upit2 = "SELECT * FROM lovina WHERE idlovina ='{$temp}'";
$rezultat2 = $baza->selectDB($upit2);
$nesto2 = $rezultat2->fetch_array();
$sezona_info[] = array("Lovina" => $nesto['id_lovina'], "Naziv" => $nesto2['naziv'], "Link" => $nesto2['link']);
}
echo json_encode($sezona_info);
} else {
$ispis = "Error";
echo $ispis;
}
public static function ostalo($korIme, $radnja, $izcontrolera)
{
if ($izcontrolera == 1) {
include_once 'baza.class.php';
} else {
include_once './controler/baza.class.php';
}
$baza = new Baza();
$upit = "SELECT idkorisnik FROM korisnik where korisnicko_ime = '{$korIme}';";
$rezultat = $baza->selectDB($upit);
$red = $rezultat->fetch_row();
$id_kor = $red[0];
$baza = new Baza();
$upit = "insert into dnevnik_rada values(default,now(),1,'{$id_kor}','{$radnja}',null);";
$rezultat = $baza->selectDB($upit);
}
public static function Vrijeme()
{
$baza = new Baza();
$upit = "select korisnicko_ime from korisnik where tip_korisnika=3 order by korisnicko_ime;";
$rezultat = $baza->selectDB($upit);
$polje = array();
while ($red = $rezultat->fetch_assoc()) {
$polje[] = $red[korisnicko_ime];
}
$reg_json = json_encode($polje);
echo $reg_json;
return $reg_json;
}
<?php
/**
* Created by PhpStorm.
* User: Prima
* Date: 13.06.14.
* Time: 23:16
*/
session_start();
if (!isset($_SESSION["PzaWeb"])) {
header("Location: greske.php?id_greske=12");
exit;
}
if ($_SESSION["TIP"] != 3) {
header("Location: greske.php?id_greske=13");
exit;
}
include_once 'baza.class.php';
include_once 'dnevnik.php';
$idkazna = $_GET['id'];
$baza = new Baza();
$upit = "update kazna set placena=1 where idkazna='{$idkazna}'";
if ($rezulat = $baza->selectDB($upit)) {
$id = $_SESSION["ID"];
Dnevnik::update($id, $upit, 1);
header("Location: ../vlasnik.php");
}
<?php
/**
* Created by PhpStorm.
* User: Prima
* Date: 31.05.14.
* Time: 23:55
*/
include_once "baza.class.php";
include_once "dnevnik.php";
$baza = new Baza();
$tablica2 = $_POST['tablica'];
$broj = $_POST['broj'];
$upit2 = "insert into {$tablica2} values (";
$imena = array();
foreach ($_POST as $key => $value) {
array_push($imena, $key);
}
for ($k = 0; $k < $broj; $k++) {
$param = $imena[$k];
$upit2 .= "'{$_POST[$param]}',";
}
$upit2 = substr($upit2, 0, -1);
$upit2 .= ");";
$baza->selectDB($upit2);
$id = $_SESSION["ID"];
Dnevnik::insert($id, $upit, 1);
header("Location: ../tablice.php");
exit;
