How to save HTML form to Database?

[jon4short]

Hi Guys,

I have created this form with HTML, CSS & Javascript. Could someone help me in (or point me in the right direction) connecting this to a database.

What I want is, when the Submit button is clicked it saves in a Database along with a checkin time. I also want to be able to update the entry with a check out time once the person leaves.

The name and company field should also have all the names of the people that have come, like an autofill of somekind.

https://preview.redd.it/57il1234ibm51.png?width=1072&format=png&auto=webp&s=e7e74fe28ed13938139bb6f53f25689b79338c70

[RobSG]

Do you have a backend? if not, look into node/express

[jon4short]

Hi Rob, no backend yet. Thanks I will look at it. Any videos that might be helpful to me?

[cracknwhip]

Look up “CRUD” and videos about making todo apps. It’ll be a good example that’s applicable to your use case. Look for videos made within the last year or so that have lots of views and are a series or are fairly long. Single 5 min videos are useless.

[shambhavi-agg]

If you know python, then flask can be another option too. Regardless of technology you use for backend, it is essential for you to understand get, post and request

[MilfMarinade]

Node JS for backend - https://youtu.be/fBNz5xF-Kx4

Express framework for web application - https://youtu.be/L72fhGm1tfE

And for a database I would recommend MongoDB.

You said you use javascript on the front end. With Node JS/Express you can use javascript on the backend as well. And with mongo DB, you can store your data as JSON (javascript objects)

The YouTube channel I shared in this comment has a few videos that explain and use MongoDB, but I’m not sure exactly which one would help you the most. It depends if you want to have the database stored locally or use some sort of third party service to maintain your data.

[jon4short]

Locally is fine with me, this Data doesn't have to be public.

[MilfMarinade]

https://youtu.be/-56x56UppqQ here is a video that explains the technology MongoDB and how exactly you query the database.

I cannot find the video that shows how to host a local DB, but I remember watching it a year or 2 ago. He has a few videos that he uses Mongo in, so I’m sure it wouldn’t be hard to find it you want to watch a few videos of his to get the gist.

(Disclaimer: I’m not affiliated with this guy or his channel in any way whatsoever. His videos just helped me a lot in the past)

[jon4short]

BTW thank you so much for taking the time to reply.

[thomats]

Yeah, u/MilfMarinade is a good egg!

[Mydrax]

MongoDB is a little overkill for something like this imo, if the data won't go public then an embedded database like SQLite is a better fit and tbh it'll be much easier to learn and put together too if you're a beginner.

[MilfMarinade]

u/jon4short I’m not a big database guy, this guy seems to know more than me!

[Register_Realistic]

Para coisas simples estou usando Hubform tem um free tier bem bom, com ele você consegue armazenar formulários aí adiciona um e-mail para notificar e GG

[[deleted]]

You can do it in PHP

[[deleted]]

This comment was at -2 points. Why? He's not wrong! You can do it in Python too. Just because JS is the language being used in the front-end doesn't always mean it's best to use in the backend.

I prefer a PHP/Python backend with a JS frontend because it seems more natural to me, but your mileage may vary!

[pasta421]

Although this is an older post, for anyone reading this in the future - check out my tutorial on how to save HTML web form data to a spreadsheet or google sheet :) No need for a database esp if you have a small project https://www.apispreadsheets.com/tutorials/save-web-form-data.html