[phpMyAdmin Developers] get the table name from sql query

[Manish Bisht]

According to my view I think this `$response->addJSON('ajax_reload',
$ajax_reload);` is used to reload the left and top navigation.

And all the import queries are executed first and then displayed on the page.

Correct me if I am missing something.


Manish Bisht
Email : hi at manishbisht.me
Website : https://manishbisht.me



On Wed, Aug 2, 2017 at 8:18 PM, Manish Bisht <manish.bisht490 at gmail.com> wrote:
> Thanks,
>
> One more thing for the import page (import.php) does the query on
> import page are shown as soon as they are executed using ajax or all
> the import queries are executed first and then shown on the page.
>
> Also what is the use of this link `$response->addJSON('ajax_reload',
> $ajax_reload);` in import.php file
> Manish Bisht
> Email : hi at manishbisht.me
> Website : https://manishbisht.me
>
>
>
> On Wed, Aug 2, 2017 at 5:21 PM, Michal Čihař <michal at cihar.com> wrote:
>> Hi
>>
>> Manish Bisht píše v St 02. 08. 2017 v 16:48 +0530:
>>> I have one create sql query in one variable.
>>>
>>> Is there any way I can get the table name from the sql query using
>>> sql
>>> parser or any other other way.
>>
>> Yes, SQL parser can do that:
>>
>> <?php
>>
>> require 'vendor/autoload.php';
>>
>> use PhpMyAdmin\SqlParser\Parser;
>> use PhpMyAdmin\SqlParser\Utils\Query;
>> use PhpMyAdmin\SqlParser\Statements\CreateStatement;
>>
>> $query = 'CREATE TABLE t (c CHAR(20) CHARACTER SET utf8 COLLATE
>> utf8_bin)';
>>
>> $parser = new Parser($query);
>> $statement = $parser->statements[0];
>> foreach ($parser->statements as $statement) {
>>     if ($statement instanceof CreateStatement) {
>>         echo "Creating table $statement->name\n";
>>     }
>> }
>>
>>>
>>> I am thinking of splitting the query by single space and then using
>>> the 3 value of the array as the table name.
>>
>> No, please do not make any assumptions on the SQL query structure, this
>> is very easy to break:
>>
>> CRATE TABLE `table with spaces` ...
>>
>> CREATE TABLE IF NOT EXIST `table` ...
>>
>> CREATE TABLE /* comment */ `table` ...
>>
>> --
>>         Michal Čihař | https://cihar.com/ | https://weblate.org/
>>
>> _______________________________________________
>> Developers mailing list
>> Developers at phpmyadmin.net
>> https://lists.phpmyadmin.net/mailman/listinfo/developers
>>