connect_error) die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); // Execute SQL statement $result = $mysqli->query("SELECT light,raindrop,moisture,temperature,humidity,tank,fan,van FROM greenhouse.sensors ORDER BY id DESC LIMIT 1"); // tin teleytaia metrisi pernw apo vasi me to limit 1 if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $LValue = $row["light"]; $RValue = $row["raindrop"]; $MValue = $row["moisture"]; $TValue = $row["temperature"]; $HValue = $row["humidity"]; $TAValue = $row["tank"]; $FValue = $row["fan"]; $VValue = $row["van"]; } } else { $LValue = 0; $RValue = 0; $MValue = 0; $TValue = 0; $HValue = 0; $TAValue = 0; $FValue = 0; $VValue = 0; } ?>
Loading...

Γραφική Αποικόνιση με Google Gauge

Η επεξεργασία των μετρήσεων, η μετάδοσή τους στο cloud ή στη τοπική βάση, η σχεδίαση των διαγραμμάτων και η παρουσίαση τους έχει γίνει από τον Δρ. Τοπάλη Ευάγγελο σε συνεργασία με τον φοιτητή Συμεωνίδη Οδυσσέα.

Στα παρακάτω γραφήματα απεικονίζονται οι τελευταίες τιμές των αισθητήρων με μορφή Gauge. Στα δύο τελευταία γραφήματα απεικονίζονται οι τιμές του ανεμιστήρα και της ηλεκτροβάνας που λειτουργούν ως αυτοματισμοί.Την στιγμή που θα ενεργοποιηθεί η συνθήκη του ανεμιστήρα ή της ηλεκτροβάνας η τιμή θα δείξει '1' και θα λειτουργήσουν τα αντίστοιχα στοιχεία.

data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="100" data-major-ticks="0,10,20,30,40,50,60,70,80,90,100" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 40, "color": "rgba(0,0,0)" }, { "from": 40, "to": 70, "color": "rgba(204, 153, 0,1)" }, { "from": 70, "to": 100, "color": "rgba(0, 153, 51,1)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="100" data-major-ticks="0,10,20,30,40,50,60,70,80,90,100" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 40, "color": "rgba(65, 65, 65)" }, { "from": 40, "to": 100, "color": "rgba(0, 0, 183)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="100" data-major-ticks="0,10,20,30,40,50,60,70,80,90,100" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 40, "color": "rgba(65, 65, 65)" }, { "from": 40, "to": 100, "color": "rgba(0, 0, 183)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="-50" data-max-value="50" data-major-ticks="[-50,-40,-30,-20,-10,0,10,20,30,40,50]" data-minor-ticks="2" data-stroke-ticks="true" data-highlights='[ {"from": -50, "to": 0, "color": "rgba(0,0, 255, .3)"}, {"from": 0, "to": 20, "color": "rgba(0, 153, 51,1)"}, {"from": 35, "to": 50, "color": "rgba(77, 0, 0,1)"}, {"from": 20, "to": 35, "color": "rgba(255, 51, 51,1)"} ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="100" data-major-ticks="0,10,20,30,40,50,60,70,80,90,100" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 40, "color": "rgba(204, 153, 0,1)" }, { "from": 40, "to": 70, "color": "rgba(0, 153, 51,1)" }, { "from": 70, "to": 100, "color": "rgba(255, 51, 51,1)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="100" data-major-ticks="0,10,20,30,40,50,60,70,80,90,100" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 50, "color": "rgba(0, 153, 51,1)" }, { "from": 50, "to": 70, "color": "rgba(60, 62, 10)" }, { "from": 70, "to": 100, "color": "rgba(204, 0, 0,1)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="1" data-major-ticks="0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 0.5, "color": "rgba(0,0,0)" }, { "from": 0.5, "to": 1, "color": "rgba(255,0,0.8)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" > data-animate-on-init="false" data-animated-value="false" data-min-value="0" data-max-value="1" data-major-ticks="0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1" data-minor-ticks="0.1" data-stroke-ticks="false" data-highlights='[ { "from": 0, "to": 0.5, "color": "rgba(0,0,0)" }, { "from": 0.5, "to": 1, "color": "rgba(255,0,0.8)" } ]' data-color-plate="#001433" data-color-major-ticks="#f5f5f5" data-color-minor-ticks="#ddd" data-color-title="#fff" data-color-units="#ccc" data-color-numbers="#eee" data-color-needle-start="rgba(240, 128, 128, 1)" data-color-needle-end="rgba(255, 160, 122, .9)" data-value-box="true" data-animation-rule="bounce" data-animation-duration="500" data-border-outer-width="3" data-border-middle-width="3" data-border-inner-width="3" >