You are here: Re: Query builder in PHP....IS IT POSSIBLE?? « PHP « IT news, forums, messages
Re: Query builder in PHP....IS IT POSSIBLE??

Posted by Johan Holst Nielsen on 02/13/06 22:03 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

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]

Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация