Hello. I am working with node-red and mysql database. I would like to fill a form and send the data from the form to the database.
The flow :
So I just have a form where I fill my data, then I have the function node which holds the query for the mysql.
I can already insert data to mysql data if I define the function as such:
msg.topic="INSERT INTO users (Name,Surname,Age,City)VALUES('test_name','test_surname','10','test_city')";
However, what I actually need, is take the variables from the form and insert them into the querry as such:
msg.topic="INSERT INTO users (Name,Surname,Age,City)VALUES(variable1,variable2,variable3,variable4)";
Im just not too sure how do I pass the form variables into the querry?