function Baza_Radnje($opis, $email, $tip)
{
$baza = new baza();
$baza->spojiDB();
$vrime = vratiVrime();
$upit = "Insert into Radnje_baza (id_baza,id_kor,datum_rada,opis,tip) values ('default','{$email}','{$vrime}','{$opis}','{$tip}' )";
$baza->ostaliUpiti($upit);
}
<?php
include_once 'baza.class.php';
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
if (isset($_GET['regId'])) {
$baza = new baza();
$baza->spojiDB();
$regId = $_GET['regId'];
$sql = "INSERT INTO Air (registration_id) values ('{$regId}')";
$baza->ostaliUpiti($sql);
}
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
ob_start();
include_once 'baza.class.php';
include_once 'greske.php';
$baza = new baza();
$baza->spojiDB();
$vrsta = isset($_POST['vrsta']) ? $_POST['vrsta'] : false;
if ($vrsta) {
if ($vrsta == 2) {
$kur = isset($_POST['kur']) ? $_POST['kur'] : false;
$email = isset($_POST['email']) ? $_POST['email'] : false;
if ($kur && $email) {
$upit = "INSERT INTO Djelatinici VALUES ('{$kur}','{$email}',1)";
$baza->ostaliUpiti($upit);
if (!isset($_SESSION)) {
session_start();
}
Baza_Radnje(addslashes($upit), $_SESSION['email'], 1);
Baza_Radnje("Dodijeljen postar {$kur}, Kurirskoj sluzbi s ID: {$email} ...", $_SESSION['email'], 2);
}
//ako su dospjeli podaci koga treba dodati kome
}
//ako se radi od dodavanju
$upit = "Select Kur_sluzba.naziv AS Naziv,Kur_sluzba.id_kur AS ID from Kur_sluzba";
$podaci = $baza->selectUpit($upit);
$i = 0;
while ($red = $podaci->fetch_array()) {
$response[$i]['Naziv'] = $red['Naziv'];
$response[$i]['ID'] = $red['ID'];
}
//recaptcha
require_once 'recaptchalib.php';
$privatekey = "6Ld-8fISAAAAAB1TZVxuW-AIIBx58cweUTZIv2rM";
$resp = recaptcha_check_answer($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);
if (!$resp->is_valid) {
// What happens when the CAPTCHA was entered incorrectly
die("The reCAPTCHA wasn't entered correctly. Go back and try it again." . "(reCAPTCHA said: " . $resp->error . ")");
} else {
// Your code here to handle a successful verification
}
if ($prolazi) {
$actkod = md5(uniqid(rand(), true));
$vrime = vratiVrime();
$upit = "insert into Korisnik(email,ime,prezime,adresa,grad,kor_ime,lozinka,broj,datum_rod,spol,obavijesti,status,aktivacija,datum_reg,broj_neusp)" . "values('{$email}','{$ime}','{$prez}','{$adresa}','{$grad}','{$kor_ime}','{$lozinka}','{$broj}','{$date}','{$spol}','{$posta}','0','{$actkod}','{$vrime}','0')";
if ($baza->ostaliUpiti($upit)) {
Baza_Radnje("Registracija korisnika", $email, 2);
$mailPoruka = "Postovani, molimo vas da aktivirate vas korisnicki racun klikom na sljedeci link: \n \n http://arka.foi.hr/WebDiP/2013_projekti/WebDiP2013_079/php/aktivacija.php?kor_mail={$email}&act={$actkod} \n \n koji istice za 24 sata. \n \n Vase korisnicko ime je: {$kor_ime} \n \n Vasa lozinka je: {$lozinka} \n \n Hvala na registraciji! ";
mail($email, "Aktivacijski mail", $mailPoruka);
} else {
trigger_error("Neuspjeli zapis u bazu podataka prilikom registracije!", E_USER_ERROR);
}
}
//ako je ispravno uneseno - prolazi je true
}
//kraj ako je sve postavljeno
echo '
<!DOCTYPE html>
<html lang="hr">
<head>
include_once 'greske.php';
$baza = new baza();
$baza->spojiDB();
if (isset($_POST['buton_paket'])) {
$primatelj_email = $_POST['primatelj_paketa'] ? $_POST['primatelj_paketa'] : false;
$adresa_odred_paketa = $_POST['adresa_odred_paketa'] ? $_POST['adresa_odred_paketa'] : false;
$grad_odred_paketa = $_POST['grad_odred_paketa'] ? $_POST['grad_odred_paketa'] : false;
$tip_dostave = $_POST['dostava_odred_paketa'] ? $_POST['dostava_odred_paketa'] : false;
$kur_odred_paketa = $_POST['kur_odred_paketa'] ? $_POST['kur_odred_paketa'] : false;
$upit_broj = "Select COUNT(*)id_paket from Paket";
$podaci = $baza->selectUpit($upit_broj);
$red = $podaci->fetch_array();
$id_nex = $red['id_paket'];
$id_next = $id_nex + 1;
$upit_gal = 'Insert into Gal_slik values(' . $id_next . ',"' . $id_next . '_img1.jpg","' . $id_next . '_img2.jpg","' . $id_next . '_img3.jpg")';
$baza->ostaliUpiti($upit_gal);
$upit_paket = 'Insert into Paket (id_paket,id_kurs,id_topd,naziv,adresa_prim,grad_prim,adresa_pos,grad_pos,gal_slik) values (' . $id_next . ',' . $kur_odred_paketa . ',' . $tip_dostave . ',"naziv_' . $id_next . '","' . $adresa_odred_paketa . '","' . $grad_odred_paketa . '","' . $_SESSION['adresa'] . '","' . $_SESSION['grad'] . '",' . $id_next . ')';
$baza->ostaliUpiti($upit_paket);
$upit_pos = 'Insert into Sudionici values ("' . $_SESSION['email'] . '",' . $id_next . ',1)';
$baza->ostaliUpiti($upit_pos);
$upit_prim = "Insert into Sudionici values ((Select email from Korisnik where email='{$primatelj_email}' OR kor_ime='{$primatelj_email}'),{$id_next},2)";
$baza->ostaliUpiti($upit_prim);
$vrime = vratiVrime();
$upit_status = 'Insert into Paketi_status (paket_id_paket,datum_postavljanja,status) values (' . $id_next . ',"' . $vrime . '",1)';
$baza->ostaliUpiti($upit_status);
Baza_Radnje("Kreiran paket primatelj: {$primatelj_email}", $_SESSION['email'], 2);
echo "<img src='../img/sent.jpg' />";
header("refresh:2;url=user.php");
} else {
$primatelj = $_POST['primatelj'] ? $_POST['primatelj'] : false;
$vrsta_upit_paket = $_POST['vrsta_upit_paket'] ? $_POST['vrsta_upit_paket'] : false;
*/
ob_start();
if (!isset($_SESSION)) {
session_start();
}
include_once 'baza.class.php';
include_once 'greske.php';
$baza = new baza();
$baza->spojiDB();
$email = isset($_POST['email']) ? $_POST['email'] : false;
$status = isset($_POST['status']) ? $_POST['status'] : false;
$broj_neusp = isset($_POST['broj_neusp']) ? $_POST['broj_neusp'] : false;
if ($email && isset($status) && isset($broj_neusp)) {
if ($status >= 2) {
$upit_r = "Update Korisnik SET status=1,broj_neusp='{$status}'WHERE email = '{$email}'";
if ($baza->ostaliUpiti($upit_r)) {
Baza_Radnje(addslashes($upit_r), $_SESSION['email'], 1);
Baza_Radnje("Korisnicki racun otkljucan, racun korisnika: {$email}", $_SESSION['email'], 2);
}
$upit = "Select kor_ime,prezime,ime,email,lozinka,status,broj_neusp from Korisnik ORDER BY status";
$podaci = $baza->selectUpit($upit);
$i = 0;
while ($red = $podaci->fetch_array()) {
$response[$i]['kor_ime'] = $red['kor_ime'];
$response[$i]['prezime'] = $red['prezime'];
$response[$i]['ime'] = $red['ime'];
$response[$i]['email'] = $red['email'];
$response[$i]['lozinka'] = $red['lozinka'];
$response[$i]['status'] = $red['status'];
$response[$i]['broj_neusp'] = $red['broj_neusp'];
$i = $i + 1;
if (!isset($_SESSION)) {
session_start();
}
include_once 'baza.class.php';
$baza = new baza();
$baza->spojiDB();
if (isset($_POST['dod_rute_buton_name'])) {
$i = 0;
$polje = array();
foreach ($_POST as $kljuc => $vrijednost) {
//echo "<br> Kljuc: ".$kljuc." vrijednost: ".$vrijednost."<br>";
$polje[$i] = $vrijednost;
$i = $i + 1;
}
$upit = "INSERT INTO Ruta values(default," . $polje[1] . ",'" . $polje[0] . "','" . $polje[$i - 6] . "','" . $polje[$i - 5] . "',1)";
$baza->ostaliUpiti($upit);
$upit_2 = "INSERT INTO Cjenik values (1,(Select id_ruta from Ruta order by id_ruta DESC LIMIT 1)," . $polje[1] . ",'" . $polje[$i - 4] . "')";
$baza->ostaliUpiti($upit_2);
$upit_4 = "INSERT INTO Cjenik values (2,(Select id_ruta from Ruta order by id_ruta DESC LIMIT 1)," . $polje[1] . ",'" . $polje[$i - 3] . "')";
$baza->ostaliUpiti($upit_4);
$upit_5 = "INSERT INTO Cjenik values (3,(Select id_ruta from Ruta order by id_ruta DESC LIMIT 1)," . $polje[1] . ",'" . $polje[$i - 2] . "')";
$baza->ostaliUpiti($upit_5);
$upit_3 = "INSERT INTO Dio_rute values (default,(Select id_ruta from Ruta order by id_ruta DESC LIMIT 1)," . $polje[1] . "," . $polje[2] . ",1)";
$baza->ostaliUpiti($upit_3);
//pocinje 3 karja je i-8
for ($ll = 3; $ll < $i - 8; $ll = $ll + 1) {
$upit_z = "INSERT INTO Dio_rute values (default,(Select id_ruta from Ruta order by id_ruta DESC LIMIT 1)," . $polje[1] . "," . $polje[$ll] . ",2)";
$baza->ostaliUpiti($upit_z);
}
$upit_10 = "INSERT INTO Dio_rute values (default,(Select id_ruta from Ruta order by id_ruta DESC LIMIT 1)," . $polje[1] . "," . $polje[$i - 8] . ",3)";
$baza->ostaliUpiti($upit_10);
