Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- const DB_HOST = 'localhost';
- const DB_USERNAME = 'pi_select';
- const DB_PASSWORD = 'RaspPi';
- function getData() {
- try {
- $dbh = new PDO('mysql:host='.DB_HOST.';dbname=measurements', DB_USERNAME, DB_PASSWORD);
- $sth = $dbh->prepare('SELECT dtg, vel FROM sensors');
- $sth->execute();
- return $sth->fetchAll(PDO::FETCH_ASSOC);
- }
- catch(PDOException $e)
- {
- echo $e->getMessage();
- }
- }
- $data = getData();
- ?>
- <!DOCTYPE html>
- <meta charset="utf-8">
- <style> /* set the CSS */
- body { font: 12px Arial;}
- path {
- stroke: steelblue;
- stroke-width: 2;
- fill: none;
- }
- .axis path,
- .axis line {
- fill: none;
- stroke: grey;
- stroke-width: 1;
- shape-rendering: crispEdges;
- }
- </style>
- <body>
- <!-- load the d3.js library -->
- <script src="http://d3js.org/d3.v3.min.js"></script>
- <script>
- // Set the dimensions of the canvas / graph
- var margin = {top: 30, right: 20, bottom: 30, left: 50},
- width = 800 - margin.left - margin.right,
- height = 270 - margin.top - margin.bottom;
- // Parse the date / time
- var parseDate = d3.time.format("%Y-%m-%d %H:%M:%S").parse;
- // Set the ranges
- var x = d3.time.scale().range([0, width]);
- var y = d3.scale.linear().range([height, 0]);
- // Define the axes
- var xAxis = d3.svg.axis().scale(x)
- .orient("bottom");
- var yAxis = d3.svg.axis().scale(y)
- .orient("left").ticks(5);
- // Define the line
- var valueline = d3.svg.line()
- .x(function(d) { return x(d.dtg); })
- .y(function(d) { return y(d.vel); });
- // Adds the svg canvas
- var svg = d3.select("body")
- .append("svg")
- .attr("width", width + margin.left + margin.right)
- .attr("height", height + margin.top + margin.bottom)
- .append("g")
- .attr("transform",
- "translate(" + margin.left + "," + margin.top + ")");
- // Get the data
- <?php
- echo "data=".$json_data.";" ?>
- data.forEach(function(d) {
- d.dtg = parseDate(d.dtg);
- d.vel = +d.vel;
- });
- // Scale the range of the data
- x.domain(d3.extent(data, function(d) { return d.dtg; }));
- y.domain([0, d3.max(data, function(d) { return d.vel; })]);
- // Add the valueline path.
- svg.append("path")
- .attr("class", "line")
- .attr("d", valueline(data));
- // Add the X Axis
- svg.append("g")
- .attr("class", "x axis")
- .attr("transform", "translate(0," + height + ")")
- .call(xAxis);
- // Add the Y Axis
- svg.append("g")
- .attr("class", "y axis")
- .call(yAxis);
- // ** Update data section (Called from the onclick)
- function updateData() {
- // Get the data again
- <?php
- getData();
- echo "data=".$json_data.";"
- ?>
- data.forEach(function(d) {
- d.dtg = parseDate(d.dtg);
- d.vel = +d.vel;
- });
- // Scale the range of the data again
- x.domain(d3.extent(data, function(d) { return d.dtg; }));
- y.domain([0, d3.max(data, function(d) { return d.vel; })]);
- // Select the section we want to apply our changes to
- var svg = d3.select("body").transition();
- // Make the changes
- svg.select(".line") // change the line
- .duration(750)
- .attr("d", valueline(data));
- svg.select(".x.axis") // change the x axis
- .duration(750)
- .call(xAxis);
- svg.select(".y.axis") // change the y axis
- .duration(750)
- .call(yAxis);
- }
- </script>
- <div id="option">
- <input name="updateButton"
- type="button"
- value="Update"
- onclick="updateData()" />
- </div>
- </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement