up vote 7 down vote favorite
1
share [g+] share [fb]

I was wondering if there are any PHP code, modules, plugins that would allow me to build my own MySQL queries. E.g. The query builder that phpMyAdmin uses lets you make queries using dropdown menus.

It has to be a builder that will be on a website not software or application!

Must be user friendly! visual etc

link|improve this question
82% accept rate
visually or incode? – Daniel A. White Aug 3 '11 at 15:38
visually so it is easy to see for a user who wants to find out stuff : e.g. I want to find out how many people bought bananas – sqlmole Aug 3 '11 at 15:40
You should write that into your question. It sounds like you want one for you as a developer, not one for the public to use. – cularis Aug 3 '11 at 15:45
No i want one so my users can get data that is relevant for them to so they can make business decisions – sqlmole Aug 3 '11 at 16:03
+1 Good question. I actually want to add something like this to my client's admin pages. Also, I like the part where it's a +100 bounty but you only have 59 rep ;-) – JamWaffles Aug 7 '11 at 13:30
show 6 more comments
feedback

6 Answers

up vote 4 down vote
+50

When you say "needs to be on a WEBSITE", you are asking for Javascript/Jquery and not PHP

You want this ::

http://plugins.jquery.com/project/SQL_QUERY_BUILDER

Demo for above http://ksistem.com/jquery/sqlbuilderdemo.htm

in the Iframe type of thing on that page, scroll down to see the menu to build new queries.

OR This (more detailed)

http://aspquerybuilder.net/default.aspx

and this might also help ::

http://sourceforge.net/projects/myquerybuilder/

link|improve this answer
Why would I use ASP when my system is being built using PHP and Codeigniter framework lol! – sqlmole Aug 7 '11 at 13:49
1  
@sqlmole that ASP is for future reference, and the other two, the jquery one and myquerybuilder will work with PHP and codeigniter framework, and since its Javascript/Jquery it will pretty much work with anything else as well. – Pheonix Aug 7 '11 at 14:52
That ASP product is really nice, +1. – Alix Axel Aug 10 '11 at 3:08
feedback
up vote 1 down vote

I don't know of any like that, but you could just use phpMyAdmin and copy the query that's generated?

link|improve this answer
Yes but then that would be fixed, and not dynamic for users who want different queries – sqlmole Aug 3 '11 at 15:40
If your program's licence is compatible with the GPL, you can just copy the one from phpMyAdmin. – cularis Aug 3 '11 at 15:46
feedback
up vote 1 down vote

Try the following tools. These does the same work of PhpMyAdmin but no guarantee that they would satisfy your taste.

1.Adminer (formerly phpMinAdmin) A full-featured MySQL management tool written in PHP. Does more or less everything phpMyAdmin however consist of a single file only that is ready to upload to your servers and connect to the DB.

2.Navicat This, in my opinion, is the best MySQL client out there. It does everything you want from a very user friendly interface. However, it doesn’t come free. There is a small price tag to it but is well worth it!

3.Sequel Pro One for the Mac users.

4.SQLWave

5.SQLyog

6.BlueSQL

Free web based DB management tool.

7.SQL Buddy

9.DBDesigner 4

10.SQLGate

11.HeidiSQL

Is this what you want?

link|improve this answer
feedback
up vote 0 down vote

@sqlmole, there is no such tool that will let you build a query such as how many people purchased bananas. You will have to develop such a system. However, apart from PHPMyAdmin, MySQL GUI Tools from MySQL itself and WebYog are some tools known to me which can some how help you create queries visually. I would also love to see alternatives.

link|improve this answer
It needs to be on a website – sqlmole Aug 3 '11 at 16:02
feedback
up vote 0 down vote

Have you ever tried Navicat? Look this: http://navicat.com/manual/online_manual/en/mac_manual/QueryBuilder.html

link|improve this answer
That wont work on a webpage – sqlmole Aug 3 '11 at 16:02
feedback
up vote 0 down vote

What about this jQuery based SQL Query Builder?

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.