Save HTML Form Data to Database - Node.js Express MySQL Heroku

Learn how to save data from an HTML form to a MySQL database and then read that data back using an Express REST API and a Heroku MySQL database.

Comment and subscribe if you like this video!

Normally, you would run 'git init' in the root project folder, but to keep the video simple and for easy Heroku deploying, we initialized a temporary repo in the 'code' folder.

One-on-one tutoring available via Zoom! Contact me on my website for more information:

See all of my final code here:

References:

[keerthanayelchuri]

Thank you so much for this video! It really helped me in my project

[ichmachmut]

Awesome Video! Could you make a tutorial on how to save/remember information locally on an device using the web app? For example a counter app. So each device has it own value over any point in time

[crlvlnc]

Hey Jake, can you create an updated version of this? a lot has changed like body-parser being added to express and prohairesis becoming slim-node-mysql :D would appreciate it

[jamespowell]

HI JAKE, like carl i would appreciate an upto date version of this its great info ;-), aslo a more zoomed in view would be great, cheers good work

[missnaturale]

I have been stuck on node mySQL heroku deployment for over a week! I have read and tried almost EVERY suggestion on stackoverflow and youtube vids but nothing worked until I followed your tutorial! You are amazing, thank you so much!! I just have one question, I am using slim-node-mysql instead of prohairesis as it's deprecated now. Could you please explain a bit more what purpose they actually serve? Are they absolutely necessary for the project to run or are they more of a nice-to-have feature? Thanks soooo much once again!! I wish I could like this video multiple times :D

[amaan]

It is showing require is not defined in console.
please help me out.

[christianmingle]

This video was exactly what i was looking for. Sadly whenever i enter in info and hit the button, i get a 404 ERROR saying it doesnt exist. i have checked over my .post and all the other code 10x over and its making me go crazy. If you have any ideas id appreciate it because i really want to know how to do this :)

[bepatient]

How can i modify this code without heroku is there any way that i can directly use the ip and port number to connect the mssql server

[Rostensky]

Hey man, was just wondering if you had any advice on finding some info on how to retrieve the data to use again in html. like for logging into a website. Im pretty knowledgeable in javascript and have just started to dabble in backend, and was able to follow along with your tutorial pretty well. Got my database setup and working with collecting data, but not sure how to retrieve it. Ive searched all over and cant find any clear precise info. Any help would be appreciated it!

[generalstep]

Heroku asking for credit card to add database and i dont have Credit card

[femiabitogun]

I could not read what you are typing, too tiny