Getting data into a database from the web

Getting data into a database from the web
Photo by Jan Antonin Kolar / Unsplash

I never really thought databases could be much fun. And let's face it, data entry is not all that great. But being able to interact with databases is a valuable career skill. Building one isn't all that hard, but connecting it to a web front end takes a bit more doing.

As soon as my first database was up and functional, I thought there had to be a better way of interacting with it. So I put my training from the Cisco EN-AUTO to work by writing a python script to present users a simple set of prompts and then pass the input to the database.

And as fun as that was, I understand very few people in the real world will ever relish sitting in front of a black screen with green text to type answers to prompts on a command line interface the same way I do.

Thus,  I embarked on the journey of stitching my python script together with some html code and an apache web sever. The combination proved a bit challenging. I will say more about that in a future edit--perhaps tomorrow--as I'm getting sleepy and would like to put this project to bed for then evening.

The product of a much learning and a few hours of troubleshooting the Dunning-Kruger effect's effects is a functional mysql database that I am leaving up in this link here for you to play with for at least a while. Have fun fuzzing the inputs and checking for whatever vulnerabilities you can. I haven’t broken it yet.

Here's a video to give you a little better idea of what went into making this possible. If anything, it will make you a bit more appreciative of the hard work and countless hours that go into making, maintaining, and securing your information every time you fill in a form online.