Posted by Johan Holst Nielsen on 02/13/06 22:03

lacenaepronta@gmail.com wrote:
> HI,
>
> my boss asked me to develop a filter system on a mysql database set of
> tables.
>
> I wonder if there's a tool, written in php, that:
>
> - analyzes my table structure (or the structure defined in a config
> file)
> - allows to create customized queries with a web based front end
>
> So, I'm looking for a query builder system written in php, is there
> something similar?

Well - take a look at phpmyadmin - they have a simple query builder. But
do you need an advanced query builder - or just a simple one?

If you need inner joins etc - i would be plenty of work (like making a
scheme that defines that fieldA in tableA refers to fieldB in tableB -
that needs to be done manual if you database not have any foreign keys
etc.).

Can you describe the tables you need to build this for? Is it a single
table or a bunch of tables that needs the same frontend? :)


Regards,
Johan

[Back to original message]