Web lists-archives.com

[PHP] Query Builder FrontEnd UI Class


Any one know of a PHP Class that will assist in allow user to setup query string in PHP for mySQL.

I envisioned a table where they can compile the WHERE statement with headers:

and_or, field_name, operator (preferably in words), and value.

The table would default displaying one row (with a option to add and delete a line)

The first line would not have an “and_or” menu.

Depending on what field was selected, the “operator” options would update and the “value” would too.

If the type is number and the operator is “BETWEEN” it would have two value fields.

The same with date BETWEEN but the start and end dates would have pop-up calendars for selecting

Booleans would show a CHECKBOX

is EMPTY and is not EMPTY are options in the operator list.

I know I can compile something like this, but was hoping there something open source or donation ware that would save me the work and time.

Appreciate any direction.

Don Wieland
donw@xxxxxxxxxxxxx <mailto:donw@xxxxxxxxxxxxx>http://www.pointmade.net <http://www.pointmade.net/>
https://www.facebook.com/pointmade.band <https://www.facebook.com/pointmade.band>