MMM-MysqlQuery module just released!
-
I just finished a new MySQL module, available at MMM-MysqlQuery.
This queries a MySQL database you have access to on a regular basis, and displays the results as an HTML table on MagicMirror.
Screenshots:
-
Just what I needed. Thank you for your contribution
-
Had to add a line:
position: 'bottom_right'
Now to make the SQL work with the Mysqli db I have running on an adjacent pi.
-
I have this module working quite well, just a couple of queries:
How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]Thank you.
-
@Richard238 said in MMM-MysqlQuery module just released!:
I have this module working quite well, just a couple of queries:
How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]Thank you.
How do you get the title “______________MYSQL SPICES” line displayed?
Fixed that one in config.js withheader: 'Module Title',
Other enhancements still need attention, if anyone can help, please?