PHP MySQL query builder [closed]

Question

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

Answer 1

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?

Answer 2

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/

Answer 3

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