Navigation

    MagicMirror Forum

    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • Donate
    • Discord

    MMM-MysqlQuery module just released!

    Utilities
    3
    5
    1401
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R
      ralberth last edited by

      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

      1 Reply Last reply Reply Quote 1
      • F
        Foguet last edited by

        Just what I needed. Thank you for your contribution 😉

        1 Reply Last reply Reply Quote 0
        • R
          Richard238 last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • R
            Richard238 last edited by

            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.

            R 1 Reply Last reply Reply Quote 0
            • R
              Richard238 @Richard238 last edited by

              @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?

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post
              Enjoying MagicMirror? Please consider a donation!
              MagicMirror created by Michael Teeuw.
              Forum managed by Paul-Vincent Roll and Rodrigo Ramírez Norambuena.
              This forum is using NodeBB as its core | Contributors
              Contact | Privacy Policy