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;