Blockly Rule with database query

[coldbringer]

Hi,

I would like to use the last time of detected motion (from my Fibaro Motion Sensor) in a blockly rule. Therefore, I have created a custom php block with the respective mySQL query. What do I need to do in order to have the custom-php-block return the query result to another funktion (e.g. the pushover message function)

Thanks!
Carlos

[K.Rens]

Hi Carlos,

I think you can put the outcome of your query in the $item variable.
Then inside blocky you can add the variable “item” as en element inside pushover.

Kind regards,
K.Rens

[Author]

Posts