<?php session_start(); if (empty($_SESSION['korisnicko_ime'])) { die("Niste logirani"); } require_once "korisnici.class.php"; $k = new korisnici(); $tmp = $k->uloga($_SESSION['korisnicko_ime']); $rola = $tmp[1]; $idrole = $tmp[0]; if ($idrole < 2) { die("Nemate pravo pristupa"); } function adresa($korisnicko_ime) { require_once 'baza.class.php'; if (!isset($baza)) { $baza = new baza(); } $upit = "SELECT adresa,grad from korisnici where korisnicko_ime='{$korisnicko_ime}' LIMIT 1"; $res = $baza->selectUpit($upit); $l = $res->fetch_assoc(); $zarez = " , "; $temp = $l['adresa'] . $zarez . $l['grad']; return $temp; } function vrsta($idzahtjeva) { require_once 'baza.class.php'; if (!isset($baza)) {
<?php session_start(); if (empty($_SESSION['korisnicko_ime'])) { die("Niste logirani"); } require_once "korisnici.class.php"; $k = new korisnici(); $tmp = $k->uloga($_SESSION['korisnicko_ime']); $rola = $tmp[1]; $idrole = $tmp[0]; $idkurirske = $k->ksid($_SESSION['korisnicko_ime']); if ($idrole < 2) { die("Nemate pravo pristupa"); } if ($_POST['pdf'] == 1) { $stat = $_POST['pdf']; require 'mysqlpdf.php'; class PDF extends PDF_MySQL_Table { function Header() { //Title $this->SetFont('Arial', '', 18); $this->Cell(0, 6, 'Statistika korisnika po broju poslanih paketa', 0, 1, 'C'); $this->Ln(10); //Ensure table header is output parent::Header(); } } //Connect to database
$upit = "SELECT * FROM mjesta"; $podaci = $baza->selectUpit($upit); header("Content-Type:application/xml"); echo '<?xml version="1.0" encoding="utf-8"?><mjesta>'; while ($l = $podaci->fetch_assoc()) { echo "<mjesto id='" . $l['idmjesta'] . "' ime='" . $l['postanski_broj'] . " " . $l['naziv_mjesta'] . "'/>"; } echo "</mjesta>"; die; } if ($_GET['id'] == "provjeraKorisnika") { $korisnik = $_GET['korisnik']; $upit = "select count(*) as br from korisnici WHERE korisnicko_ime='{$korisnik}' "; $podaci = $baza->selectUpit($upit); echo "<korisnici>"; $red = $podaci->fetch_array(); echo "<korisnik>" . $red['br'] . "</korisnik>"; echo "</korisnici>"; } if ($_POST['act'] == "msg") { $kome = $_POST['kome']; $naslov = $_POST['naslov']; $poruka = $_POST['poruka']; require_once "mail.class.php"; require_once "korisnici.class.php"; $k = new korisnici(); $m = new email(); foreach (explode(",", $kome) as $uname) { $m->salji($k->email($uname), $naslov, $poruka); } }
<?php session_start(); if (empty($_SESSION['korisnicko_ime'])) { die("Niste logirani"); } require_once "korisnici.class.php"; $k = new korisnici(); $tmp = $k->uloga($_SESSION['korisnicko_ime']); $rola = $tmp[1]; $idrole = $tmp[0]; if ($idrole != 3) { die("Nemate pravo pristupa"); } include "header.php"; include "izbornik.php"; require_once 'baza.class.php'; $baza = new baza(); ?> <div class="container" style="margin-top: 80px"> <h3>Odaberi odgovarajuću tablicu</h3> <select class="form-control" id="izbor"> <option>Odaberi tablicu</option> <option value="korisnici">Korisnici</option> <option value="sluzbe">Kurirske službe</option> <option value="role">Role</option> <option value="mjesta">Mjesta</option>
require_once 'baza.class.php'; $baza = new baza(); $out = ""; $upit = "SELECT * FROM rute_has_mjesta rhm LEFT JOIN mjesta m ON (rhm.mjesta_idmjesta=m.idmjesta) WHERE rhm.rute_idrute={$id} ORDER BY rhm.redosljed ASC"; $podaci = $baza->selectUpit($upit); $tmp = array(); while ($l = $podaci->fetch_array()) { $tmp[] = $l['naziv_mjesta']; } if (count($tmp) > 0) { $out = implode(' - ', $tmp); } return $out; } require_once "korisnici.class.php"; $k = new korisnici(); $idks = $k->ksid($_SESSION['korisnicko_ime']); if (!empty($idks) && !empty($_POST['idrute1'])) { $brisi = $_POST['idrute1']; $upit = "DELETE FROM rute_has_mjesta where rute_idrute='{$brisi}'"; $podaci = $baza->selectUpit($upit); $upit = "DELETE FROM rute WHERE idrute='{$brisi}' LIMIT 1;"; $podaci = $baza->selectUpit($upit); $poruka = '<div class="alert alert-success">Uspješno izbrisana kurirska služba</div>'; } if (!empty($idks) && !empty($_POST['unos'])) { $upit = "INSERT INTO rute (`vrijeme_trajanja`,`kilometraza`,`tip_dostave`,`idkurirske_sluzbe`) VALUES ({$_POST['vrijeme_trajanja']},{$_POST['km']},{$_POST['tip_dostave']},{$idks});"; $podaci = $baza->selectUpit($upit); $poruka = '<div class="alert alert-success">Uspješno dodana kurirska služba</div>'; } if (empty($idks) && !empty($_POST['idrute1']) && !empty($_POST['id_sluzbe'])) {