Fórum | MyPower.CZ | Obnovitelné zdroje energie - energetická soběstačnost | Právě je pát úno 22, 2019 10:48 am
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Temp demo</title>
<h1>Arduino Page 4</h1>
<!--Load the AJAX API-->
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load("visualization", "1", {packages:["line"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var jsonData = $.ajax({
url: "getData.php",
dataType: "json",
async: false
}).responseText;
// Create our data table out of JSON data loaded from server.
var data = new google.visualization.DataTable(jsonData);
}
var options = {
width: 7200,
chart: {
title: 'Day energy production',
subtitle: 'Panels Trackers/Solid'
},
series: {
0: { axis: 'watts' }, // Bind series 0 to an axis named 'voltage1'.
1: { axis: 'watts' }, // Bind series 0 to an axis named 'voltage2'.
},
axes: {
y: {
watts: {side: 'right', label: 'W'}, // Right y-axis.
watts: {side: 'right', label: 'W'} // Right y-axis.
}
}
};
var chart = new google.charts.Line(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="chart_div" style="width: 7200px; height: 1200px;"></div>
<p>Go back to <a href="index.htm">main page</a>.</p>
</body>
</html>
<?php
require_once 'dbconfig.php';
try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$sql = 'SELECT
timestamp,
batt_v,
Wp_W,
SOC_Ah
FROM stats2
ORDER BY timestamp';
$q = $pdo->query($sql);
$q->setFetchMode(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
die("Could not connect to the database $dbname :" . $e->getMessage());
}
?>
<!DOCTYPE html>
<html>
<head>
<title>PHP MySQL Query Data Demo</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
</head>
<body>
<div id="container">
<h1>Arduino Data</h1>
<table class="table table-bordered table-condensed">
<thead>
<tr>
<th>timestamp</th>
<th>Pb Batt V</th>
<th>PV W</th>
<th>SOC Ah</th>
</tr>
</thead>
<tbody>
<?php while ($row = $q->fetch()): ?>
<tr>
<td><?php echo htmlspecialchars($row['timestamp']) ?></td>
<td><?php echo htmlspecialchars($row['batt_v']) ?></td>
<td><?php echo htmlspecialchars($row['Wp_W']); ?></td>
<td><?php echo htmlspecialchars($row['SOC_Ah']); ?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</body>
</div>
</html>
rottenkiwi píše:ako z timestamp položky urobiť čas v sekundách
select HOUR(FROM_UNIXTIME(timestamp))*3600+MINUTE(FROM_UNIXTIME(timestamp))+SECOND(FROM_UNIXTIME(timestamp)), Batt_V, Wp_W, SOC_Ah from stats2 where timestamp - UNIX_TIMESTAMP (NOW()) > -1800;
try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$sql = 'SELECT timestamp,
batt_v,
Wp_W,
SOC_Ah
FROM stats2
ORDER BY timestamp where timestamp - UNIX_TIMESTAMP (NOW()) > -1800';
$q = $pdo->query($sql);
$q->setFetchMode(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
die("Could not connect to the database $dbname :" . $e->getMessage());
}
[Wed Jan 16 15:52:31.335565 2019] [:error] [pid 17634] [client ::1:33920] PHP Fatal error: Uncaught Error: Call to a member function setFetchMode() on boolean in /var/www/html/phpquery.php:15\nStack trace:\n#0 {main}\n thrown in /var/www/html/phpquery.php on line 15
rottenkiwi píše:a dat to zobraziť za posledných 10 hod, ale meniť to ľubovoľne
dotazom do MySQL, aby to bolo NOW () - x hodín ?
... where (timestamp>UNIX_TIMESTAMP()-(H*3600)) and (timestamp<=UNIX_TIMESTAMP())
... where (timestamp>UNIX_TIMESTAMP()-(H*3600)-X) and (timestamp<=UNIX_TIMESTAMP()-X)
rottenkiwi píše:
- Kód: Vybrat vše
select HOUR(FROM_UNIXTIME(timestamp))*3600+MINUTE(FROM_UNIXTIME(timestamp))+SECOND(FROM_UNIXTIME(timestamp)), Batt_V, Wp_W, SOC_Ah from stats2 where timestamp - UNIX_TIMESTAMP (NOW()) > -1800;
![]() |
|
Uživatelé procházející toto fórum: Cyberon a 0 návštevníků