<br><div class="gmail_quote"> On Marc Delisle a écrit :<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">>Samith Dassanayake a écrit :<br>
<div>>> Hi,<br>
>><br>
>> I am working on bug [0].<br>
>> My plan is, if the operation is "rename" , parse the sql query and identify<br>
>> what is new table name and reload the page with updated info.<br>
>><br>
>> 1.) In top of the main page (in the div "serverinfo") it points to current<br>
>> table, db etc... How we can change where it points if the page is<br>
>> reloaded.? What variables do we need to set?<br>
>><br>
>> 2.) Is there a existing Sql parser class or function that I can use to<br>
>> parse a sql query by extending its functionality, to identify the new table<br>
>> name?<br>
><br>
</div>>Hi,<br>
>there is a parser in libraries/sqlparser.lib.php, but maybe preg_match()<br>
>would be enough. See this solution attempt : [1]<br>
>><br>
>> [0] <a href="http://sourceforge.net/p/phpmyadmin/bugs/3818/" target="_blank">http://sourceforge.net/p/phpmyadmin/bugs/3818/</a><br>
><br>
>[1]<br>
<a href="https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b343b95fc0e9" target="_blank">>https://github.com/hisamith/phpmyadmin/commit/b250906159d8fb261409bbb12482b343b95fc0e9</a><br>
<br></blockquote><div>Hi <br></div><div>I am the one who done that attempt. But the problem is, even though it reload the left menu with the updated information, in top of the main page (in the div "serverinfo") it points to the previous table name as you mentioned in the pull request. <br>
Same problem is there with a "Drop table " request(in sql tab). It updates the left menu but not the top main page. (It points to the deleted table name).<br></div><div> </div><div> </div></div><br><br clear="all">
<br>-- <br>
<span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Best regards,<br><br>Samith Dassanayake,<br><div>Department of Computer Science and Engineering,<br></div>University of Moratuwa.</span>