Help needed with webhook/php inserting data in MySQL table

[Hootie81]

I always found the easiest way to find what was happening was to write to a file. similar to debugging using serial, or returning things to the webhook.. my computer crashed last week so i cant share the whole code...
have a look at this thread..

Get variables from a MySQL database

Here is an example bit of code i very quickly whipped up, the query part is missing some bits as its a cut and paste from another PHP script, but you will get the idea. you will see right at the end there is ‘addmessage’ in the send curl function call, thats the name of the function on the core (it sends a new comment to the spark message torch so have a look at the functions in that to see the core side of things). the PHP script has a security check to make sure the right thing is calling it, …