2 Aug
2017
2 Aug
'17
5:48 p.m.
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(a)manishbisht.me
Website : https://manishbisht.me
On Wed, Aug 2, 2017 at 5:21 PM, Michal Čihař <michal(a)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(a)phpmyadmin.net
https://lists.phpmyadmin.net/mailman/listinfo/developers