So I went to work, happily streamlining my design until I had 3NF. My problem was that when I started creating tables and actually entering data on the sql commandline, I realized it was going to be a major pain to remember the various tables and where everything went. I also had difficulty with the joins. Other things in life came up and I was distracted from the project.
Now I have some time, and Istill don't know where to look. I am unclear how to set up an interface for adding or viewing the data. I've used PHP a bit for managing a phpBB forum, as well as phpmyadmin. I write bash scripts on a regular basis to admin my systems. I don't care what language or tool I use, I just don't know a place to start. I'm having trouble coming up with search terms for google--I either get pure design or pure representation.
I'd be grateful to anyone who could point me to the stuff in the middle.
Just mentioning PHP doesn't help. It doesn't point me to a link, doesn't suggest anything to search for, nothing. The problem with many newbs like myself is that they don't even know the terms to search for in an unfamiliar area. I have found nothing that explains how to make a nice form that allows a user to unify the various 3NF tables under one simple interface.
It doesn't explicitly show how to do what I want, but at least it shows how to use a database w/ php. I think I can take it from there, but if someone knows a good resource on the specific problem I stated, I'd be grateful.
Thank you both so much. I did not realize that there was a php AND mysql on the w3 tutorials. I don't remember it being there several years ago when I went through their php tutorial, but it's possible.
As for the OOP for heretics, thanks for that as well. My first coding experience (after the greatest language of all time, QBasic) was C++. I heard the vaunted creeds of OOP. I followed them. I got tired of some of them. I like this person's renegade take. I'll have to think through the rationale to see what I agree with.
Or maybe I'll just try coding my front-end w/ QBasic... Yes...