Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author John Blackbourn

    (@johnbillion)

    WordPress Core Developer

    It’s unlikely I’ll add a means of viewing a query result any time soon. Many queries can and do return huge amounts of data which are impractical to attempt to display in any meaningful format.

    What sort of queries do you need to see the result for?

    Thread Starter giuliovale

    (@giuliovale)

    Hi, thanks for reply.
    I need to debug some plugin so my idea is to make a step by step query to see if the results are correct.
    Until now I make this with phpmyadmin where I paste the query that query monitor show into footer.
    A possible idea is something like have a button aside every query that show the result inside another window or popup?

    Thread Starter giuliovale

    (@giuliovale)

    Hi I made a little hack/test (btw I’m not a wordpress developper)

    put this inside query-monitor.js

    $(function(){
            $('<input></input>').attr({'type': 'button','style':'height:18px;'}).val("+").click(function(){
                var valuetopast = $(this).parent().html().replace(/\<br\>/gi,'\r').replace(/(<([^>]+)>)/ig,"");
                var myWindow =null;
                var windowstyle ="width=800, height=800 ";
                myWindow = window.open("phpminiadmin.php","",windowstyle);
                $(myWindow).load(function(){
                   myWindow.document.getElementById("q").innerHTML = valuetopast;
                });
    
            }).appendTo($('td.qm-row-sql'));
        });

    and add phpminiadmin.php from phpminiadmin.php inside root of my wordpress.

    With this little hack I can debug on demand all the query from frontend.
    Yes I know there is really a little security etc

    giulio

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘dump’ is closed to new replies.