Display MySQL view

I would like to display a MySQL view defined within MySQL, sure I could get the data with php, but it would be nice to display it in an openHAB manner, so… any Ideas?

We need more information. What sort of data? Is it just text, a graph, an image?

Without further information my initial response would be probably not.

Oh, it’s a simple view of a table, so text with 10 rows and 4 columns.

With some work you could probably do something, but at the end of the day it would probably be as much work and look better for you to roll your own php. Getting it to work with OH will require creating a bunch of Items, scripts to export the MySQL data to text, parsing the text, populating the Items and even then I’m not sure you will be able to reproduce the table.

1 Like