Query builder in PHP....IS IT POSSIBLE??

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?

Thanks!!

Dario

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

Well, I need a complex one, in order to do joins between tables, with
summerized datas and so on.

I looked at Agata Report, but I found it very hard to use, despite of
an article appeared on 'php | architect'.

Any ideas?


Thanks!!