Read the statement by Michael Teeuw here.
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 :winking_face:
-
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?
-
Hello.
Unfortunately, I only see my headings. The contents of my database are not displayed.{ module: 'MMM-MysqlQuery', position: "top_right", header: "Test", config: { connection: { host: "192.168.2.1", port: 3306, user: "test", password: "test", database: "test" }, query: `select titel, jahr from test order by titel limit 3`, intervalSeconds: 15 * 60, emptyMessage: "No spices", columns: [ { name: "titel", title: "Titel", cssClass: "right" }, { name: "jahr", title: "Jahr", cssClass: "right" }, ] } },
-
@chris47803
I have the same issue. Only the headings are displayed