Visual Query Builder
I have been using phpMyAdmin from past few years, i found PMA very interesting and useful tool.Especially if you are a newbie PMA is like heaven for you .Even for experienced user it make things simple and fast.
But i found one problem with PMA. ‘Query’ option in the present PMA used for writing complex queries using multiple tables is not good and interactive enough,also it has a limited scope.So i decided to make complex Query writing more fun and propose to add visual query builder, an interactive and a visual aid for query building as my Gsoc project.
This query Builder will be using an interactive diagram showing the relational schema something similar to one used for defining relations in the present PMA,here we will have options for selecting attributes from different tables and then generate queries.
One option button will be present with each attribute where we will have a menu bar with following fields
As user selects option from this menu bar other text-boxes boxes/options will appear as the case is.
For the example in image we will select name check-box and then select S_LANG in song table there we will go to the option and click on the where button a small
where window will come here we will use the drop down menu to select = and in the text-box we will write English,and press Ok one entry will be added to the history table,repeat the process to for HINDI.
after all this we will select the AND rule by writing (1 and 2).and then submit .
Although i personally will like to make option for selecting AND/OR option more interactive,and am open for suggestions
For coding will use the diagram building code, used for defining relation for our diagrams and add new features to it.also will reuse the code of query building section .