projectLinuxDash/script.php at master · ali2key/projectLinuxDash · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php

$Crit = fread(fopen("CritNum.txt", "r"), filesize("CritNum.txt"));
echo $Crit;

$Gen = fread(fopen("Gen.txt", "r"), filesize("Gen.txt"));
echo $Gen;


$High = fread(fopen("HighNum.txt", "r"), filesize("HighNum.txt"));
echo $High;


$Act2 = fread(fopen("Act2.txt", "r"), filesize("Act2.txt"));
echo $Act2;


$netban = fread(fopen("netban.txt", "r"), filesize("netban.txt"));
echo $netban;


$file="newoutput13.txt";
$linecount = -1;
$handle = fopen($file, "r");
while(!feof($handle)){
  $line = fgets($handle);
  $linecount++;
}

fclose($handle);


$servername = "127.0.0.1:3308";
$database = "dashboard";
$username = "user1";
$password = "RTSwidzew";

// Create connection
date_default_timezone_set('Europe/Berlin');
$dt2=date("Ymd H:i:s");
echo $dt2; // CO DODAĆ ?

$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection

if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
}

echo "Connected successfully";

 function getDateSiur(){
}

if (mysqli_query($conn, $sql)) {
      echo "New record created successfully";
} else {
      echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
  $sql = "INSERT INTO tab1 (ID, Active, Connected, Critical, High, ActualDate)
VALUES (' ', $Act2, $Gen, $Crit, $High, CURRENT_TIMESTAMP())";
setInterval(getDateSiur(){
  $sql = "INSERT INTO tab1 (ID, Active, Connected, Critical, High, ActualDate)
VALUES (' ', $Act2, $Gen, $Crit, $High, CURRENT_TIMESTAMP())"
},1000);


?>


<!--
// $servername = "127.0.0.1:3308";
// $username = "user1";
// $password = "widzewRTS";
// $dbname = "dashboard";

// // Create connection
// $conn = mysqli_connect($servername, $username, $password, $dbname);
// // Check connection
// if (!$conn) {
//     die("Connection failed: " . mysqli_connect_error());
// }

// $sql = "INSERT INTO tab1 (ID, Active, Connected, Critical, High, Upload)
// VALUES (' ', $Act2 , $Gen, $Crit, $High, ' ')";

// if (mysqli_query($conn, $sql)) {
//     echo "New record created successfully";
// } else {
//     echo "Error: " . $sql . "<br>" . mysqli_error($conn);
// }

// mysqli_close($conn); -->