I have a database, for which I need an online form that adds data behind a login/password wall. PHP/MySQL is obvious, but do you have any recommendations for books or tutorials on this particular application? I get the general idea behind all of it, but reading instructions on how to rotate ad banners and the like isn't helping.
in what format is this existing database? how many users are going to be accessing and modifying the DB?
I did something similar sounding in an evening using flask, a python framework. I used sqlite as the database since its built-in/embedded and I didn't need something as heavy as postgres or mysql
the flask tutorial covers most of what you'd need to know assuming you know a little python. might be worth checking out:
Thanks I'll check it out. The DB was built in LibreOffice Base - it's pretty simple (two tables, one form and one subform), total users will be about 6 including me.
im not sure of any libreoffice to sqlite bridge, but im sure you could get it in there somehow if you can just export the libreoffice database to CSV or something. youd need to do the same work regardless of what db you end up choosing to put the site behind
sqlite would work fine for a handful of users like that. if you decide this is going to become some site that 20 people are editing at a time and hundreds are accessing, you'd be better off with something like postgres or mysql (postgres being the more common choice). my capacity estimation might be off there, but sqlite is a file-based embedded database. its super easy to prototype with and its actually incredibly powerful, its just not a big database server like the others...which is nice for right now if you want to get a site up and running in an hour without knowing a lot about the parts.
i built most of what amounts to a minimal youtube clone using flask+sqlite. a neighbor wanted to have something like that to host video clips throughout the editing process and then send the clips to coworkers for review. it was a few simple tables to store video info, user info, and then comments and a approve/reject state for each clip.
You could probably build this in about ten minutes using SQL lite and PHP. Pick a server then let me know what languages are available to you