MagicMirror² v2.7.0 is available! For more information about this release, check out this topic.

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:
    Table

    Empty table



  • 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 with header: 'Module Title',

    Other enhancements still need attention, if anyone can help, please?