Posted by Johan Holst Nielsen on 02/13/06 22:03
> my boss asked me to develop a filter system on a mysql database set of
> I wonder if there's a tool, written in php, that:
> - analyzes my table structure (or the structure defined in a config
> - 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
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? :)
[Reply to this message]
Copyright © 2005-2006 Powered by Custom PHP Programming