I have a running PHP application to show pictures of building construction projects. For each project these is a table, where each row contains the information of one picture, name, size, storage path ...
The names of the tables are different for each project by a different prefix.
e.g. proj1_picture_list, proj2_picture_list ...
Pictures are stored in a file system, not in the database.
It is easy to build the application for one project, searching, etc....
How to manage a lot of projects? Showing people only their own projects.
And managing the projects, adding new and deleting old.
Is there a way to do this without putting all pictures (meta information) into one single table?
I hope somebody has a clue.
Thanks a lot.
