Query Builder FrontEnd UI Class

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

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>





[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux