Hello PHP Community,
I have been creating a kind of a system that, given a database, it auto generates pages, forms and give to the end users a HTML5 interface to interact to their data. It is working properly, including using foreign keys (and displaying dropdown to select the proper one).
I believe that most of you have already had that idea or have already used an existing one to do so ;-)
Eventually, I do not want to be contacted by my clients when they want a new table or report, instead, I would like to give them access to a tool that can create tables by themselves. in fact, the "system" is able to create tables and columns now.
However, something that I am struggling to, is to develop a way to create database VIEWS.
Phpmyadmin is a way, but it is too much for my users, I believe, I am thinking more about having an UI showing:
1. all tables (give option to users select)
2. all tables connected to that table (give option to users select - or not, if it depends just the first one)
3. define parameters of the fields on table (1) or (2)
4. Generate SQL - and save it in a VIEW
I believe I can do that, though I see that it might take hours and hours of my time if I try to do that by myself.
Does anyone of you have used / has available a "tool" to build views? In fact, this tool should can work just like a SQL generator -- and then I can create the view by myself.
What I have tried:
I have not find anything particularly that addresses this purpose.