| There are 6 "...Type" tables. These could all have been made ENUM (enumeration) types, but I decided that an external table for each one would be easier & allow more future options. Filling these tables is the goal of the first PHP file.
The first act was to construct a HTML file that replicated what I wanted the PHP file to achieve. This file can be renamed from .html to .php & it works fine - only script between the <?php...?> delimiters is acted upon by the PHP engine.
Next, it became apparent that one difficulty was to distinguish which tables were to be available for editing. To help achieve this I've standardised the naming of all the "...Type" tables, as there should be a means of finding all the table names, and then all the "...Type" tables can be discovered in that listing. |
