I am making a website to help myself maintain accounts, staff members, IP ranges, and usernames for multiple vendors. Right now I have 16 tables in MySQL for storing this information. I also have a admin page to edit these tables and a quest page that allows only viewing of these tables.
How should I organize my php files, scripts, functions and other files to help me maintain the increasing amount of code. For example, each table has a function for delete, insert, update, validate, view etc.
The ever increasing number of files and functions is creating a burden. How can I possibly organize these files. Should I be using one file per table, put all files in a directory for each file and use an include statement to include them. How does everybody handle this.
Thanks for your suggestions.
