mySql Functions, Tables and Extensions
Posted: Thu Mar 09, 2023 4:33 pm
Hi, I have a mySql db which stores data from over a dozen sensors and display the data on a web page hosted by my website using the Chart.js extension with no problem.
In mySql I have several function's which checks the data and sets various flags in an error table if the sensor readings move outside a defined range, again no issues here.
My question is, is there a way to have an object (Editbox, Shape, Button etc) on my webpage (WYSIWYG) change color depending on a mySqli query of the error table?
Other than possible modify the webpage php code which I am not keen on doing, is there an extension which exists to do this??
In mySql I have several function's which checks the data and sets various flags in an error table if the sensor readings move outside a defined range, again no issues here.
My question is, is there a way to have an object (Editbox, Shape, Button etc) on my webpage (WYSIWYG) change color depending on a mySqli query of the error table?
Other than possible modify the webpage php code which I am not keen on doing, is there an extension which exists to do this??