Hello,
I want to ask how can i get/display data from MySQL database to a webpage?
Which part don't you know how to do?
What do you mean by 'a webpage`?
webpage means template node.
i am able to send data from html form from webpage.
but i want to show that data also in the same webpage.
pasting my code
[{"id":"20b712ef.404aa6","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"75c1029e.0df62c","type":"mqtt in","z":"20b712ef.404aa6","name":"","topic":"data","qos":"2","datatype":"auto","broker":"31cc7922.cfe9d6","x":90,"y":440,"wires":[["a1b9c876.554fd8"]]},{"id":"5876306b.084108","type":"debug","z":"20b712ef.404aa6","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":410,"y":440,"wires":[]},{"id":"e963eb80.fbf7b","type":"mqtt out","z":"20b712ef.404aa6","name":"","topic":"data","qos":"","retain":"","broker":"31cc7922.cfe9d6","x":250,"y":380,"wires":[]},{"id":"a1b9c876.554fd8","type":"function","z":"20b712ef.404aa6","name":"","func":"var data = JSON.parse(msg.payload);\nmsg.payload = data;\n//if(msg.payload === \"true\"){\n // msg.payload = \"connected\";\n//}else{\n // msg.payload = \"Disconnected\"\n//}\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":240,"y":440,"wires":[["5876306b.084108"]]},{"id":"8ddd4a8.380a338","type":"inject","z":"20b712ef.404aa6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"false","payloadType":"bool","x":110,"y":380,"wires":[["e963eb80.fbf7b"]]},{"id":"2effe6a0.43f20a","type":"http in","z":"20b712ef.404aa6","name":"","url":"/webpage","method":"get","upload":false,"swaggerDoc":"","x":120,"y":100,"wires":[["5d0ead9a.487214"]]},{"id":"5d0ead9a.487214","type":"template","z":"20b712ef.404aa6","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"<!DOCTYPE html>\n<html>\n<body>\n\n<h1>The input form attribute</h1>\n\n<p>The form attribute specifies the form an input element belongs to.</p>\n\n<form action=\"/webpage\" id=\"form1\" method=\"POST\">\n <label for=\"uname\">Username : </label>\n <input type=\"text\" id=\"uname\" name=\"uname\" value = \"username\"><br><br>\n <label for=\"email\">Email : </label>\n <input type=\"text\" id=\"email\" name=\"email\" value = \"email\"><br><br>\n <label for=\"password\">Password : </label>\n <input type=\"password\" id=\"password\" name=\"password\" value = \"password\"><br><br>\n <input type=\"submit\" value=\"Submit\">\n <button type=\"button\" onClick = \"showdata()\">Show data</button> \n</form>\n\n<hr>\n\n</body>\n</html>\n","output":"str","x":300,"y":100,"wires":[["8af853b8.d503b8"]]},{"id":"8af853b8.d503b8","type":"http response","z":"20b712ef.404aa6","name":"","statusCode":"","headers":{},"x":510,"y":100,"wires":[]},{"id":"f1b7fc37.81709","type":"mysql","z":"20b712ef.404aa6","mydb":"c5b83b64.bcedb","name":"","x":530,"y":280,"wires":[["e963eb80.fbf7b"]]},{"id":"bda19a7b.79adf8","type":"inject","z":"20b712ef.404aa6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"CREATE TABLE test ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); ","payload":"","payloadType":"date","x":140,"y":640,"wires":[[]]},{"id":"80cb3f51.c1c64","type":"inject","z":"20b712ef.404aa6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"INSERT INTO test (PersonID, LastName, FirstName, Address, City) VALUES ('3', 'three', 'Test', 'Big Street', 'Khao Gali');","payload":"","payloadType":"date","x":140,"y":680,"wires":[[]]},{"id":"eb53a62e.b225b8","type":"inject","z":"20b712ef.404aa6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"select * from user;","payload":"","payloadType":"date","x":320,"y":280,"wires":[["f1b7fc37.81709"]]},{"id":"f200169d.446368","type":"http in","z":"20b712ef.404aa6","name":"","url":"/webpage","method":"post","upload":false,"swaggerDoc":"","x":150,"y":160,"wires":[["519bbb9f.dbfc94"]]},{"id":"519bbb9f.dbfc94","type":"function","z":"20b712ef.404aa6","name":"","func":"var obj1 = msg.payload.uname;\nvar obj2 = msg.payload.email;\nvar obj3 = msg.payload.password;\nmsg.topic = \"INSERT INTO `user` ( `Username`, `Email`, `Password`) VALUES ('\"+obj1+\"','\"+obj2+\"','\"+obj3+\"')\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":390,"y":180,"wires":[["806e3bdd.c8f86","f1b7fc37.81709","1a3dbbf2.db6cfc"]]},{"id":"74d2c212.573554","type":"inject","z":"20b712ef.404aa6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"CREATE TABLE user( Username varchar(255), Email varchar(255), Password varchar(255)); ","payload":"","payloadType":"date","x":590,"y":220,"wires":[["f1b7fc37.81709"]]},{"id":"806e3bdd.c8f86","type":"debug","z":"20b712ef.404aa6","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":620,"y":160,"wires":[]},{"id":"227d8607.41b1b2","type":"inject","z":"20b712ef.404aa6","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"INSERT INTO user( Username, Email, Password) VALUES ('tester','test@mail','qawsedrf');","payload":"","payloadType":"date","x":870,"y":200,"wires":[["f1b7fc37.81709"]]},{"id":"1a3dbbf2.db6cfc","type":"http response","z":"20b712ef.404aa6","name":"","statusCode":"","headers":{},"x":780,"y":100,"wires":[]},{"id":"31cc7922.cfe9d6","type":"mqtt-broker","name":"","broker":"localhost","port":"1883","clientid":"","usetls":false,"compatmode":false,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"c5b83b64.bcedb","type":"MySQLdatabase","name":"","host":"localhost","port":"3306","db":"test","tz":"","charset":"UTF8"}]
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
