To make the export progress more efficient. Is there any php page to which I can do the ajax request and run the query on phpmyadmin configuration database.
Manish Bisht Email : hi@manishbisht.me Website : https://manishbisht.me
On Tue, Jul 18, 2017 at 3:57 AM, Isaac Bennetch bennetch@gmail.com wrote:
Hello,
On 7/17/17 12:22 PM, Manish Bisht wrote:
I found three ways to execute the query. What is the difference between these.
$GLOBALS['dbi']->query($sql_query);
$GLOBALS['dbi']->tryQuery($sql_query);
PMA_queryAsControlUser($sql_query);
What is the difference between these. What I know is query() returns error and tryQuery() doesn't returns error.
Michal has already answered most of this, but query() calls tryQuery() and if it fails, it die()s. queryAsControlUser() specifically runs as the controluser[1][2] so that's what we'd want here.
You can see this in DatabaseInterface.php[3]
1 - https://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration- storage 2 - https://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_controluser 3 - https://github.com/phpmyadmin/phpmyadmin/blob/master/libraries/classes/ DatabaseInterface.php#L140-146
On 7/17/17 2:20 PM, Manish Bisht wrote:
I have checked other ajax requests and found that some extra parameter
server : PMA_commonParams.get('server'), db : PMA_commonParams.get('db'), table : PMA_commonParams.get('table'),
are passed in the ajax request. What is the need of this so that I can check if these are required in my case.
I'm pretty confident that these are used to tell phpMyAdmin which server, database, and table are currently active. For instance, after copying a table to a new database, the user may wish to switch to the newly copied one instead of staying on the same page; these functions facilitate that change.
Then this is not required in my case and I can simply ignore these.
Sure, that sounds correct.
I think all of your other questions have been answered by the others, so let me know of course if there's anything I missed.
Isaac
Developers mailing list Developers@phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers