PHP / MySQL Query Builder UI with jQuery?

php jquery mysql query-builder
emailq picture emailq · Jun 8, 2010 · Viewed 13.9k times · Source

So, I need to construct a front-facing query builder for a database, but I'm having trouble finding existing code for what I can't imagine is a rare requirement.

Basically, I have non-SQL fluent people needing to build queries on the fly and view the results.

I found this: http://plugins.jquery.com/project/SQL_QUERY_BUILDER (Demo: http://ksistem.com/jquery/sqlbuilderdemo.htm)

But it requires that the database schema be hardcoded, rather than be dynamically generated.

Is there a better solution that dyamically pulls the database schema into a jQuery-like UI for building and executing SELECT queries against a MySQL database?

Answer

Sergey Smagin picture Sergey Smagin · Jun 9, 2010

Active Query Builder ASP.NET Edition's MS Access-like user interface is based on jQuery. It's a commercial component for ASP.NET 2.0 and higher. It can build SELECT statements for MySQL server.

Product page: http://www.activequerybuilder.com/product_asp.html Demo: http://aspquerybuilder.net

Related questions

jQuery UI Sortable, then write order into a database

I want to use the jQuery UI sortable function to allow users to set an order and then on change, write it to the database and update it. Can someone write an example on how this would be done?

Read More
Autocomplete Textbox results based from SQL database

I'm trying to create an auto-complete function into a textbox but the result should come from my SQL database. Here's the code that i'm trying to configure: index.php: <html lang="en"> <head> <meta charset="…

Read More
Show loading image while PHP is executing

I would like to show loading image while the php script is executing. I have read different answers on how to do that but most of them stated that I should have a separate php page. However I am using …

Read More