[Phpmyadmin-devel] Bug #4301: need suggestion

[Atul Pratap Singh]

On 3/3/14, Smita <kumarismita62 at gmail.com> wrote:
> Hi,
>
> I was looking at the bug http://sourceforge.net/p/phpmyadmin/bugs/4301/ . I
> think, If the query execution is not redirecting page, ie it's happening on
> the same page via an ajax request then there are two ways we can approach
> it.
> 1.  Append an another Query box below previous Query box for all the
> following requests. So in this case, we'll have separate query boxes for
> each operation performed on the page.
Smita,
Similar behavior occurs when:-
In Browse mode, click on "Edit" in a table row => On edit page change
something and click Go => see two SQL query boxes with UPDATE query
box on top not below.

But IMO, we could skip showing UPDATE query altogether if the user did
it with grid edit.  Or we could also show SQL query momentarily in the
success message that pops up.

> 2.  Append the query itself with separator semicolon in the same existing
> query box. In this case we'll have same just one Query box having all the
> Queries appended with separator semicolon.
>
> Please let me know if any concern, and what approach we can take to solve
> the same ?
>
> Fixing the bug will also make sure that user will have list of all the
> queries performed on relation in order that resulted into the results
> displayed on the page.
>
If you mean showing a sort of history of SQL queries, I don't think
main Browse page is suitable place for that.


Regards
-- 
Atul Pratap Singh
http://blog.atulsisodia.in/