# Form data to database

**URL:** <https://discourse.nodered.org/t/form-data-to-database/11100>\
**Category:** Dashboard\
**Created:** [14 May 2019 07:07 UTC](https://discourse.nodered.org/t/form-data-to-database/11100 "2019-05-14T07:07:08Z")\
**Posts on this page:** 8\
**Page:** 2

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [14 May 2019 11:57 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/21 "2019-05-14T11:57:48Z")

</div>

Nope. Go look at the debug output you provided above. What are the element names it displays? The debug going ‘into’ the function node

---

<div class="post-metadata">

**Author:** ![purnima](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@purnima](https://discourse.nodered.org/u/purnima)\
**Post date:** [14 May 2019 12:02 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/22 "2019-05-14T12:02:11Z")

</div>

its same sir.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/f/ff64c4fa74987d3efbbfafeb38203b385ee50b27.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [14 May 2019 12:14 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/23 "2019-05-14T12:14:36Z")

</div>

Ok, they are now but in your debug a couple posts ago they were different so I see you have made some changes.

Please provide your complete flow again

---

<div class="post-metadata">

**Author:** ![purnima](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@purnima](https://discourse.nodered.org/u/purnima)\
**Post date:** [14 May 2019 12:16 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/24 "2019-05-14T12:16:21Z")

</div>

@zenofmud Thanks for helping me .. and sorry to distrub you . give me some time.

---

<div class="post-metadata">

**Author:** ![purnima](https://avatars.discourse-cdn.com/v4/letter/p/49beb7/32.png) [@purnima](https://discourse.nodered.org/u/purnima)\
**Post date:** [14 May 2019 12:23 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/25 "2019-05-14T12:23:32Z")

</div>

Now its working .  
[{"id":"6ffadafe.da5624","type":"function","z":"166ff6a7.0b0779","name":"insert Query","func":"msg.topic="INSERT INTO test(Emp\_Id,Name,F\_name,DOJ) VALUES (?,?,?,?)";\nmsg.payload=[msg.payload.Emp\_Id,msg.payload.Name,msg.payload.F\_name,msg.payload.DOJ];\nreturn msg;","outputs":1,"noerr":0,"x":330,"y":80,"wires":[["e8e5e50e.b83968","c21b9501.cc5fd8"]]}]

---

<div class="post-metadata">

**Author:** ![onderxyilmaz](https://avatars.discourse-cdn.com/v4/letter/o/9de0a6/32.png) [@onderxyilmaz](https://discourse.nodered.org/u/onderxyilmaz)\
**Post date:** [15 November 2021 21:10 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/26 "2021-11-15T21:10:33Z")

</div>

Hi there,

This example is not working. So where can I find an example about it? I added 1 form node, 1 function node, 1 MySQL node and 1 debug node. I prepared my form fields as firstname, lastname and email. My MySql database table has id, firstname, lastname, and email fields. So how can I send form data to MySQL table? Is there any example about it?

Regards.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [16 November 2021 00:09 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/27 "2021-11-16T00:09:52Z")

</div>

Since this thread is over three years old, I’m going to close it and ask you to open a new one. Please provide your flow and let us know what version of node-red you have and which MySQL node you are using (node-red-…..)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [16 November 2021 00:10 UTC](https://discourse.nodered.org/t/form-data-to-database/11100/28 "2021-11-16T00:10:20Z")

</div>



[Previous page](https://discourse.nodered.org/t/form-data-to-database/11100.md?page=1)
