Le 2011-01-28 05:11, lgtkaushalya(a)gmail.com a écrit : Hi, looking at your wire frame, I fail to see how one would expand/collapse the search criteria when there are search results on-screen, which is the feature that is present in table search in current master. Also I don't understand how the Column section would be used. -- Marc Delisle http://infomarc.info

Hi Marc, I was successfully able to a add a "Show search criteria" link to the database search window. It works similar as the table search criteria show links. Currently I have used the link below the browse and delete options appear. This doc contains the screen shots of how it works [1]. The reason I didn't add it to the result shown window is, because I planned to combine it with my second task. That is modify the search result show window as it appear in the same page on a new panel(pop up), without directing it to a new window, as you said earlier. In the creme browser there is a small toggling problem with both table search criteria and db search criteria which I have reported as [2] ID: 3168569. But this works fine with fire fox. So please let me know if you see any issue on the above improvement. What do you prefer for applying these changes. May i send it as a whole when I finish both of them or may I send my first one right now. Thank you. [1] - https://docs0.google.com/document/d/1wJqxndD4Ae2nW4zyR_kpPyepaX1PWqbyAlWifH… [2] - https://sourceforge.net/tracker/?func=detail&aid=3168569&group_id=2… Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

Hi Marc, I have submitted the patch to the tracker with the id 3169798 [1]. This patch only contains the modification done to adding the "Show/Hide search criteria" link to the DB_search results. Please let me know if there any issues with that Since I'm going away from the home this week I'll not be able to work on the rest of the task until next Monday. So I'll continue with the rest in next week. Thank you. [1] - https://sourceforge.net/tracker/?func=detail&aid=3169798&group_id=2… Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

Hi Marc, I have checked for the improvement on Ajaxify the database search result browsing and and deletion operations. I have modified the browse option and loaded the search results in the same window with the search criteria done. Here is the doc which contains the screen shots of the modification [1]. But there is a little issue with that. I just used to load the same result window which gave previously by the sql.php file. So the tab navigation bar is appeared again according to the browsing table(I have showed it by [3] in the image). Without that navigation bar we cannot give the table options such as structure and import, and also if we remove the database tab navigation bar(which I showed by the [1] in the image) and replaced it with the table tab navigation bar (I have showed it by [3] in the image) we will not be able to do the database navigation options at that stage. So I'm confusing with taking decision of removing or keeping the table tab navigation bar(I have showed it by [3] in the image) on the Ajaxified DB result panel. So can you suggest your opinions on this issue. Thank you. [1] - https://docs.google.com/document/d/1E1Hh9BjAt741o4anw7jpIhUBh7JqrUnYfrppUE9… Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

Hi Marc, Thilanka, OK. I got the idea. I'll be update you soon. Thanks for the tip. :) Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

Hi Marc, I worked with Ajaxify the Browse and Delete options in the database search. I have successfully finished it and tested it with the Chrome and Firefox browsers. I have submitted the patch with the ID: 3176420 [1]. This doc contains screen shots of the modifications [2] for quick reference. Please let me know if there should be more changes on that. Thanks. [1] - https://sourceforge.net/tracker/?func=detail&aid=3176420&group_id=2… [2] - https://docs.google.com/document/d/1WupXl9vF-k9xcaVGzRUGbVQIag8URh82WaQlws6… Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

Hi Marc, I have miss the fact of jquery disabled user configuration when I designed the modification. So I have modified the whole db search criteria using only jquery. Thats why it is not function well under the jquery disabled configurations. Sorry for the inconvenience you faced. I will fix those issues as soon as possible. Thank you. Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

Hi Marc, Since I was little bit busy during the last week I could not continue the AJAXify Interface modification. I will continue my works in this week. I have contacted the Ninad Pundalik who did this project last year, for more information on the project. Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Thilanka Kaushalya a écrit : Thilanka, you're right. I tried again with current master + your patch (adjusted by changing "<?" with "<?php") and browse works even if AjaxEnable is false. Maybe last time I had forgotten to change one of the "<?" or had not cleared my browser cache. However IMO it should not be working as this is an Ajax behavior and the config says that it's disabled. -- Marc Delisle http://infomarc.info

Le 2011-02-26 00:11, Thilanka Kaushalya a écrit : Thilanka, about your point 4, well the Ajax behavior should _not_ work if the user sets AjaxEnable to false. -- Marc Delisle http://infomarc.info

Hi Marc, Thank you applying my patch. Since I'm on my exams this week I was little bit busy with studies. So I'll develop the hide/show criteria for the search results in the next week. Since currently we have only few actions to ajaxify listed in the wiki page [1], I thought to start a google spread sheet to list the functionalities I identify which are should ajaxify. It will help me to get review those ideas from the community. Finally we can add those points to the wiki. Thank you. [1] - http://wiki.phpmyadmin.net/pma/AJAXify_Interface <http://wiki.phpmyadmin.net/pma/AJAXify_Interface>Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Hi Marc, Thank you for the quick response. Then I'll use the same wiki page as you said. Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Thilanka Kaushalya a écrit : Thilanka, After a quick look, here are some examples: - on table Structure, adding a column could display a panel similar to when we create a table (jQuery dialog) - clicking on Edit for a row could bring a similar panel - in Browse, deleting a row does not not Ajax to me - clicking a table name in navigation panel could load the main panel in a way that does not look like a panel refresh Work needs to be done to find appropriate actions, then update http://wiki.phpmyadmin.net/pma/AJAXify_Interface. -- Marc Delisle http://infomarc.info

Hi Marc, I went through some of the sections of the PMA and found some actions which could be more useful with Ajax support. 1. In table Browse and Structure options, Change multiple rows should add a ajax window. Currently when no row is selected it does not give an error dialog have to handle that. 2. In table Structure->Change should add ajax window support. 3. In table Structure, Add column(s) At End of/ At beginning of tables should apply the ajax window support. 4. In database Structure we can add a ajax window to the insert option because it will help the user to insert for multiple tables from a one place. These are my suggestions and can you please check and confirm me on that. I'll go through the other sections deeply to find more actions. Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Hi Marc, Thanks for adding the Ajaxify ideas to the wiki page. Since my exam is over I started working on adding the Show/Hide search results option to the db search. I have almost done that, but have to clarify small issue on that. Currently when a user deletes the searched results it shows the delete results as well as the sql query box on the same page. I have add the option of hide/show query box link with my previous patch *ID: 3176420 [1]* . Currently when I add the show/hide search results link it handle hide/show of both results and the sql query box. I'm not sure whether we need both these links and it seems better to have only one link (Show/Hide search results). I have shared some screen shots of the problem with this google doc [2]. Please can you help me on this issue. Thank you. [1] - http://sourceforge.net/tracker/?func=detail&aid=3176420&group_id=23… [2] - https://docs.google.com/document/d/1Rg96E1m_PCgdY00QIIyE_imwDMslefO2MzNC0Q2… Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Hi Marc, On Thu, Mar 24, 2011 at 5:10 PM, Marc Delisle &lt;marc(a)infomarc.info&gt; wrote: It is working correctly with me. Please can you check it again by cache clearing. Ok. I'll continue with that. Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Hi Marc, On Thu, Mar 24, 2011 at 5:10 PM, Marc Delisle &lt;marc(a)infomarc.info&gt; wrote: I have little bit confused on this comment. What section do you point out by "Search results". I thought it is the area that shows the Browse results and delete results (No 1 in the screen shot). In that case the show/hide search results link will appear under that and toggle the browse and delete results. But I'm confused whether you referred the top table which list the search results (No 2 in the screen shot). If so I don't see a high importancy on that when we are using databases with few tables. It may useful when searching on a DB with large number of tables. I have attached the screen shot with this doc to point out the areas [1]. Please clarify me on this. Thank you [1] - https://docs.google.com/document/d/1cQjKyNZOpoIGxBMiZFyLIyvLAdtmAM4ccbXx1AS… Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Hi Marc, I got your point and I have checked the issue with the latest update from the master. But in my machine it does not give any issue and updates correctly to the 0 matches after deletion. I have shared the screenshots of the scenario with this doc [1]. In the previous patch I have handled it by triggering the go button the search criteria after the deletion by jquery trigger function. So it should work fine. Now I have a another problem which I have raised with the my last mail and I think my explanation with that mail was unable to convince you the problem. I have added the new "Show/Hide search results" option to toggle the browsed and deleted results which are appear below the "Show/Hide search criteria" link. I have share a doc containing the above scenario [2](This doc contains the scenario of the Hide/Show search results as understood by me). But I'm not sure whether I have provided the right feature for your request. Is this correct or should I change "Show/Hide search results" option to toggle the results appearing under "Search results for *a* at least one of the words" heading( Which I have highlighted by the number 4). If so please correct me. [1] - https://docs.google.com/document/d/18pxKFkjDlPg2eOQXKDCWSt3HE9sstBoFZKIwDPI… <https://docs.google.com/document/d/18pxKFkjDlPg2eOQXKDCWSt3HE9sstBoFZKIwDPIk2JU/edit?hl=en&authkey=CJfW4eoD#>[2] - https://docs.google.com/document/d/1Mf55LtS0nhj7glIo72V02HTb8eVjP0RC2cQYlD4… Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/

Hi Marc, I have submitted a patch on adding "Show/Hide search results criteria for db search" [1]. Please check that. Now I'm looking at this issue and will be able to update you soon. Thank you. [1] - https://sourceforge.net/tracker/?func=detail&aid=3256122&group_id=2… Regards, Thilanka. -- L G Thilanka Kaushalya Computer Science & Engineering, University of Moratuwa, Sri Lanka Connect with me at, Gmail : lgtkaushalya(a)gmail.com Twitter : @thilanka_k Facebook : Thilanka Kaushalya Yahoo : lgtkaushalya(a)yahoo.com Blog : http://coders-view.blogspot.com/