1
I am developing an application where basically the user will interface between Mysql tables. For example:
- table A (Products)
- table B (Photos)
- Table C (Price history).
Basically in the application would have to have the following:
- The user chooses the tables involved;
- User says when adding a new photo, the product ID should be included;
- The user says that when the price is changed, it should include the price in the history table using the product ID.
Well, it’s just an introduction to the problem. The problem is to avoid programming and make the most of the interface, but this is a rule among several possible.
The question is, am I going the wrong way, with no way out? Is there an application that does this (it doesn’t do everything but it already does a lot and there certainly is) and I’m reinventing the wheel? Even if it’s not PHP+Mysql, what matters is the concept.
you want to create something like phpMyAdmin?
– rray
No, I know and use phpMyAdmin. What I want is to develop something to popular tables for the common user. Imagine that the customer wants a new area on the site just to present the product. The programmer would have to create in the backoffice the management of the products, in php say that when changing the price include a new line in the product history table, prepare upload images to the gallery...
– Filipe Moraes
So you want a data "Populator"?
– Tafarel Chicotti
The data "populator" would be generated according to the settings and relationships between tables.
– Filipe Moraes
Felipe, whenever possible, [Edit]and the question to add information and clarifications. Then, warn other users using
@NomeDoUsuario
here in the comments. You can only notify a user of each comment, and the author of the question/answer is always notified.– brasofilo