| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/radvre/admin/ |
Upload File : |
<!DOCTYPE html>
<!--
******************************
Project: Radno vreme, 2023.
Version: PHP 5-7
Author : M. Kukic
Note :
Link: http://net-nas/w3/radvre_v7/admin/upd_izl.php
******************************
-->
<html>
<link rel="stylesheet" href="lgdgstil.css">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel='shortcut icon' type='image/png' href='favicon.png'/>
<meta http-equiv="refresh" content="120">
<title>Radno vreme</title>
<link rel="stylesheet" href="forma.css">
</head>
<body>
<?php
//
$id=$_GET["id"];
$st=$_GET["st"];
//
$idio = $_GET["idio"];
$punc = $_GET["punc"];
$color = $_GET["color"];
$in_or_out = $_GET["in_or_out"];
//
include "../config.php";
//
$tabela="opisio";
//
echo"<div style='width:480px; word-wrap:break-word;'>";
echo "<fieldset>";
echo "<legend><h3>RADNO VREME - Ulaz/Izlaz</h3></legend>";
echo "<table border=\"0\">";
echo "</fieldset>";
//
// ****************** Interni poziv INSERT
if ($sti=="in"){
$sql = "INSERT INTO $tabela (id, idio, punc, color, in_or_out) VALUES ('0', '$idio', '$punc', '$color', '$in_or_out' )";
if ($db==5) {
mysql_query($sql, $dbh) or die (mysql_error($dbh));
}else{
mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
}
$ok=" OK!";
$_SESSION["sti"] = "";
}
// ******************** Interni poziv UPDATE
if ($sti=="up"){
$sql = "UPDATE $tabela SET idio='$idio', punc='$punc', color='$color', in_or_out='$in_or_out' WHERE id='$id'";
if ($db==5) {
mysql_query($sql, $dbh) or die (mysql_error($dbh));
}else{
mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
}
$ok=" OK!";
$_SESSION["sti"] = "";
}
// ******************** Interni poziv DELETE
if ($sti=="dl"){
$sql = "DELETE FROM $tabela WHERE id ='".$id."'";
if ($db==5) {
$result = mysql_query($sql, $dbh) or die (mysql_error($dbh));
}else{
$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
}
$id="0";
$idio="-";
$punc="-";
$color="-";
$in_or_out="-";
$ok=" OK!";
$_SESSION["sti"] = "";
}
//
//
// ********************* Eksterni poziv INSERT
if ($st=="ins"){
$id="0";
$ok="Ins";
$ct="in";
$_SESSION["sti"] = "in";
}
//
// ********************* Eksterni poziv UPDATE
if ($st=="upd"){
$sql = "SELECT * FROM $tabela WHERE id=".$id;
if ($db==5) {
$result = mysql_query($sql,$dbh) or die (mysql_error($dbh));
$row = mysql_fetch_array($result);
}else{
$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
$row = mysqli_fetch_array($result);
}
$id=$row['id'];
$idio=$row['idio'];
$punc=$row['punc'];
$color=$row['color'];
$in_or_out=$row['in_or_out'];
$ok="Upd";
$ct="up";
$_SESSION["sti"] = "up";
}
//
// ********************** Eksterni poziv DELETE
if ($st=="del"){
$sql = "SELECT * FROM $tabela WHERE id=".$id;
if ($db==5) {
$result = mysql_query($sql,$dbh) or die (mysql_error($dbh));
$row = mysql_fetch_array($result);
}else{
$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
$row = mysqli_fetch_array($result);
}
$id=$row['id'];
$idio=$row['idio'];
$punc=$row['punc'];
$color=$row['color'];
$in_or_out=$row['in_or_out'];
$ok="Del";
$ct="dl";
$_SESSION["sti"] = "dl";
}
//
include "form_izl.php";
include "close_db.php";
echo "<hr>";
//echo "<a href='javascript:history.go(-1)'><img src='img/rw.png' width='' height=''></a>";
//echo "<a href='index_adm.php'><img src='img/hom.png' width='' height=''</a>";
echo "<img src='img/sivobl.png' width='' height=''>";
echo "<a href='adm_izl.php'><img src='img/retv.png' width='' height=''</a>";
echo "<img src='img/sivobl.png' width='' height=''>";
echo "<a href='upd_izl.php?id=0&st=ins'><img src='img/plusv.png' width='' height=''</a>";
?>
</div>
</body>
</html>