| 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: LogDogPlan
File :
Version: 2021-10-25
Author : M. Kukic
Note : PHP + MySQL v5/7 + Apache
**************************************
//http://net-tim/www/logdogplan/sastavi.php
-->
<html>
<link rel="stylesheet" href="lgdgstil.css">
<head>
<!--
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel='shortcut icon' type='image/png' href='favicon.ico'/>
<title>LogDogPlan</title>
</head>
<body>
<?php
include "config.php";
$_SESSION["sti"] = "";
$tabela=$u_dbp."_logdog";
//
echo"<div style='width:800px; word-wrap:break-word;'>";
echo "<fieldset>";
echo "<legend><h3>LogDogPlan - Sabiranje podataka</h3></legend>";
echo "<table border=\"0\">";
echo "</fieldset>";
//
echo "<br>User: <b>".$u_ime."</b> - ".$u_sts." / ".$u_elmail."<br><br>";
//
// ---------- tab1 = tab1 + tab2 ------ bezuslovno ---
$tabela1="mk_logdog";
$tabela2="mk_logdog2";
//db tab2
$sql = "SELECT * FROM $tabela2 ORDER BY datum, vreme ASC";
if ($ver==4) {
$result = mysql_query($sql,$dbh) or die (mysql_error($dbh));
$nuz = mysql_num_rows($result);
}else{
$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
$nuz = mysqli_num_rows($result);
}
echo "Dogadjaja LogDog: ".$nuz."<br>";
//
// ---------- tab1 = tab1 + tab2 ------ bezuslovno ---
if ($ver==4) {
while ($row = mysql_fetch_row($result)) {
$sql = "INSERT INTO $tabela1 VALUES (NULL, '$row[1]', '$row[2]','$row[3]', '$row[4]','$row[5]', '$row[6]')";
mysql_query($sql) or die(mysql_error());
}
}else{
while ($row = mysqli_fetch_row($result)) {
$sql = "INSERT INTO $tabela1 VALUES (NULL, '$row[1]', '$row[2]','$row[3]', '$row[4]','$row[5]', '$row[6]')";
mysqli_query($sql) or die(mysqli_error());
}
}
// ---------------------------------------------------
//
$tabela1="mk_klase";
$tabela2="mk_klase2";
//db tab2
$sql = "SELECT * FROM $tabela2 ORDER BY imklas";
if ($ver==4) {
$result = mysql_query($sql,$dbh) or die (mysql_error($dbh));
$nuz = mysql_num_rows($result);
}else{
$result = mysqli_query($dbh, $sql) or die (mysqli_error($dbh));
$nuz = mysqli_num_rows($result);
}
echo "Dogadjaja Klase: ".$nuz."<br>";
//
// ---------- tab1 = tab1 + tab2 ------ bezuslovno ---
if ($ver==4) {
while ($row = mysql_fetch_row($result)) {
$sql = "INSERT INTO $tabela1 VALUES (NULL, '$row[1]', '$row[2]')";
mysql_query($sql) or die(mysql_error());
}
}else{
while ($row = mysqli_fetch_row($result)) {
$sql = "INSERT INTO $tabela1 VALUES (NULL, '$row[1]', '$row[2]'";
mysqli_query($sql) or die(mysqli_error());
}
}
// ---------------------------------------------------
//
include "close_db.php";
//
echo "</div>";
?>
</body>
</html>