unsubscribe -----Original Message----- From: Developers [mailto:developers-bounces@phpmyadmin.net] On Behalf Of developers-request@phpmyadmin.net Sent: Friday, August 4, 2017 6:00 AM To: developers@phpmyadmin.net Subject: Developers Digest, Vol 26, Issue 3 Send Developers mailing list submissions to developers@phpmyadmin.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.phpmyadmin.net/mailman/listinfo/developers or, via email, send a message with subject or body 'help' to developers-request@phpmyadmin.net You can reach the person managing the list at developers-owner@phpmyadmin.net When replying, please edit your Subject line so it is more specific than "Re: Contents of Developers digest..." Today's Topics: 1. Re: get the table name from sql query (Manish Bisht) 2. Build failed in Jenkins: documentation #452 (Jenkins Daemon) ---------------------------------------------------------------------- Message: 1 Date: Thu, 3 Aug 2017 20:34:55 +0530 From: Manish Bisht <manish.bisht490@gmail.com> To: phpMyAdmin developers <developers@phpmyadmin.net> Subject: Re: [phpMyAdmin Developers] get the table name from sql query Message-ID: <CAO1FkOd3ATA_5589U3cazt_q8=JK-gvm_qF=agfrXFt7c1Jj=g@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I am trying to send data to page using $response->addJSON('key', 'value'); How I can I show the above JSON value on the page ? Where does this value actually gets stored. Manish Bisht Email : hi@manishbisht.me Website : https://manishbisht.me On Wed, Aug 2, 2017 at 8:30 PM, Manish Bisht <manish.bisht490@gmail.com> wrote:

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@manishbisht.me Website : https://manishbisht.me

On Wed, Aug 2, 2017 at 8:18 PM, Manish Bisht <manish.bisht490@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@manishbisht.me Website : https://manishbisht.me

On Wed, Aug 2, 2017 at 5:21 PM, Michal Čihař <michal@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@phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers

------------------------------ Message: 2 Date: Fri, 4 Aug 2017 04:02:30 +0200 (CEST) From: Jenkins Daemon <jenkins@phpmyadmin.net> To: developers@phpmyadmin.net Subject: [phpMyAdmin Developers] Build failed in Jenkins: documentation #452 Message-ID: <1761298704.1.1501812150990.JavaMail.jenkins@pmaci> Content-Type: text/plain; charset=UTF-8 See <https://ci.phpmyadmin.net/job/documentation/452/display/redirect?page=changes> Changes: [weblate] Translated using Weblate (Punjabi) [noreply] Fix typo [weblate] Translated using Weblate (Basque) [weblate] Translated using Weblate (Spanish) [noreply] Fix CGI link in glossary.rst ------------------------------------------ [...truncated 1.54 KB...] (line 27) ok http://www.jqplot.com/ writing output... [ 13%] config (line 712) ok https://secure.php.net/manual/en/reference.pcre.pattern.syntax.php (line 296) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 276) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 924) ok https://dev.mysql.com/doc/refman/5.7/en/grant.html (line 316) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 1433) ok https://secure.php.net/manual/en/function.session-get-cookie-params.php (line 1270) ok https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html (line 1566) ok https://secure.php.net/manual/en/features.persistent-connections.php (line 1570) ok https://secure.php.net/manual/en/function.mysql-pconnect.php (line 1572) ok https://secure.php.net/manual/en/mysqli.persistconns.php (line 1851) ok https://www.google.com/recaptcha/intro/ (line 1841) ok https://www.google.com/recaptcha/intro/ (line 3323) ok https://www.phpmyadmin.net/try/ (line 1609) ok https://secure.php.net/session_save_path (line 1760) ok https://secure.php.net/manual/en/session.configuration.php#ini.session.gc-ma... (line 3470) ok https://bugs.php.net/bug.php?id=72048 (line 2567) ok https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html (line 2614) redirect https://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.ht... - with Found to https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1... writing output... [ 18%] copyright (line 28) ok https://www.gnu.org/licenses/ writing output... [ 22%] credits (line 181) ok http://www.fpdf.org/ (line 206) ok https://tcpdf.org (line 181) ok https://tcpdf.org/ (line 139) ok https://sourceforge.net/projects/phpmysqlformgen/ (line 181) ok https://acko.net/blog/ufpdf-unicode-utf-8-extension-for-fpdf/ writing output... [ 27%] developers (line 10) ok https://www.phpmyadmin.net/contribute/ writing output... [ 31%] faq (line 6) ok https://www.phpmyadmin.net/docs/ (line 197) ok https://www.phpmyadmin.net/downloads/ (line 180) ok http://www.ozerov.de/bigdump/ (line 46) ok https://bugs.php.net/bug.php?id=12061 (line 208) ok https://secure.php.net/mysqli (line 197) ok https://www.mysql.com/ (line 134) ok https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html (line 201) ok https://mariadb.org/ (line 469) ok https://httpd.apache.org (line 367) ok https://bugs.php.net/bug.php?id=21079 (line 208) ok https://dev.mysql.com/doc/refman/5.7/en/old-client.html (line 548) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-vars (line 550) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-vars (line 552) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-array-ind... (line 554) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-array-index-... (line 556) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-totalname... (line 558) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-totalname-le... (line 560) ok https://suhosin.org/stories/configuration.html#suhosin-get-max-value-length (line 328) ok https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html (line 564) ok https://suhosin.org/stories/configuration.html#logging-configuration (line 567) ok https://suhosin.org/stories/configuration.html#suhosin-sql-union (line 562) ok https://suhosin.org/stories/configuration.html#suhosin-sql-bailout-on-error (line 569) ok https://suhosin.org/stories/configuration.html#suhosin-sql-multiselect (line 576) ok https://suhosin.org/stories/configuration.html#suhosin-executor-include-max-... (line 571) ok https://suhosin.org/stories/configuration.html#suhosin-sql-comment (line 580) ok https://suhosin.org/stories/configuration.html#suhosin-cookie-encrypt (line 582) ok https://suhosin.org/stories/configuration.html#suhosin-executor-disable-emod... (line 599) ok https://httpd.apache.org/docs/2.4/mod/mod_ssl.html (line 628) ok https://httpd.apache.org/docs/2.2/mod/mod_proxy.html (line 822) ok https://suhosin.org/stories/index.html (line 822) ok https://suhosin.org/stories/faq.html (line 813) ok https://bugs.php.net/bug.php?id=31134 (line 824) ok https://bugs.php.net/bug.php?id=39842 (line 457) ok https://tools.ietf.org/html/rfc2616.html (line 833) ok https://secure.php.net/manual/en/book.apc.php (line 757) ok https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html (line 833) ok https://pecl.php.net/package/uploadprogress (line 879) ok https://bugs.mysql.com/bug.php?id=21704 (line 953) ok https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html (line 846) ok https://tools.ietf.org/html/rfc1867.html (line 1063) ok https://github.com/phpmyadmin/phpmyadmin/issues/12232 (line 953) ok https://github.com/phpmyadmin/phpmyadmin/issues/7383 (line 1063) ok https://secure.php.net/manual/en/mysqli.real-connect.php#refsect1-mysqli.rea... (line 1266) ok https://bugzilla.mozilla.org/ (line 1587) ok https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html (line 1636) ok https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html (line 1615) ok https://dev.mysql.com/doc/refman/5.7/en/drop-table.html (line 1638) ok https://dev.mysql.com/doc/refman/5.7/en/insert.html (line 1800) ok https://secure.php.net/strftime (line 2167) ok https://www.phpmyadmin.net/security (line 2176) ok https://www.phpmyadmin.net/translate/ (line 2204) ok https://www.phpmyadmin.net/security/ (line 1732) ok https://bugs.mysql.com/bug.php?id=179 (line 2167) ok https://github.com/phpmyadmin/phpmyadmin/issues (line 2137) ok https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb... (line 2254) ok https://sites.google.com/site/bughunteruniversity/nonvuln/csv-excel-formula-... (line 2176) ok https://hosted.weblate.org/projects/phpmyadmin/ writing output... [ 36%] glossary (line 31) ok https://en.wikipedia.org/wiki/Bzip2 (line 13) ok https://en.wikipedia.org/wiki/.htaccess (line 21) ok https://en.wikipedia.org/wiki/Blowfish_(cipher) (line 38) ok https://en.wikipedia.org/wiki/Common_Gateway_Interface (line 26) ok https://en.wikipedia.org/wiki/Web_browser (line 53) ok https://en.wikipedia.org/wiki/Column_(database) (line 43) ok https://en.wikipedia.org/wiki/Changelog (line 58) ok https://en.wikipedia.org/wiki/HTTP_cookie (line 48) ok https://en.wikipedia.org/wiki/Client_(computing) (line 63) ok https://en.wikipedia.org/wiki/Comma-separated_values (line 79) ok https://en.wikipedia.org/wiki/Software_extension (line 71) ok https://en.wikipedia.org/wiki/Database (line 97) ok https://en.wikipedia.org/wiki/Foreign_key (line 90) ok https://en.wikipedia.org/wiki/Field_(computer_science) (line 85) ok https://en.wikipedia.org/wiki/FAQ (line 107) ok https://en.wikipedia.org/wiki/GD_Graphics_Library (line 120) ok https://en.wikipedia.org/wiki/Host (line 115) ok https://en.wikipedia.org/wiki/Gzip (line 125) ok https://en.wikipedia.org/wiki/Hostname (line 145) ok https://en.wikipedia.org/wiki/Internet_Information_Services (line 157) ok https://en.wikipedia.org/wiki/Internet_Protocol (line 136) ok https://en.wikipedia.org/wiki/Https:_URI_scheme (line 150) ok https://en.wikipedia.org/wiki/Index_(database) (line 131) ok https://en.wikipedia.org/wiki/HyperText_Transfer_Protocol (line 162) ok https://en.wikipedia.org/wiki/IP_Address (line 169) ok https://en.wikipedia.org/wiki/IPv6 (line 174) ok https://en.wikipedia.org/wiki/ISAPI (line 188) ok https://en.wikipedia.org/wiki/JPEG (line 199) ok https://en.wikipedia.org/wiki/LaTeX (line 209) ok https://en.wikipedia.org/wiki/Mac_OS_X (line 204) ok https://en.wikipedia.org/wiki/Mac (line 180) ok https://en.wikipedia.org/wiki/ISP (line 232) ok https://en.wikipedia.org/wiki/MIME (line 221) ok https://en.wikipedia.org/wiki/MCrypt (line 237) ok https://en.wikipedia.org/wiki/Apache_HTTP_Server (line 246) ok https://en.wikipedia.org/wiki/MySQL (line 261) ok https://en.wikipedia.org/wiki/OpenDocument (line 266) ok https://en.wikipedia.org/wiki/OS_X (line 273) ok https://en.wikipedia.org/wiki/Portable_Document_Format (line 216) ok https://secure.php.net/manual/en/book.mbstring.php (line 226) ok https://secure.php.net/mcrypt (line 292) ok https://en.wikipedia.org/wiki/PHP (line 251) ok https://secure.php.net/manual/en/book.mysqli.php (line 278) ok https://pear.php.net/ (line 256) ok https://secure.php.net/manual/en/book.mysql.php (line 297) ok https://en.wikipedia.org/wiki/Port_(computing) (line 321) ok https://en.wikipedia.org/wiki/Request_for_Comments (line 336) ok https://en.wikipedia.org/wiki/Server_(computing) (line 331) ok https://en.wikipedia.org/wiki/Row_(database) (line 358) ok https://en.wikipedia.org/wiki/Secure_Sockets_Layer (line 352) ok https://en.wikipedia.org/wiki/Unix_domain_socket (line 363) ok https://en.wikipedia.org/wiki/Stored_procedure (line 368) ok https://en.wikipedia.org/wiki/SQL (line 284) ok https://secure.php.net/pcre (line 376) ok https://en.wikipedia.org/wiki/Table_(database) (line 381) ok https://en.wikipedia.org/wiki/Tar_(file_format) (line 387) ok https://en.wikipedia.org/wiki/TCP (line 397) ok https://en.wikipedia.org/wiki/Database_trigger (line 414) ok https://en.wikipedia.org/wiki/URL (line 326) ok https://tools.ietf.org/html/rfc1952.html (line 431) ok https://en.wikipedia.org/wiki/ZIP_(file_format) (line 426) ok https://en.wikipedia.org/wiki/XML (line 436) ok https://en.wikipedia.org/wiki/Zlib (line 419) ok https://en.wikipedia.org/wiki/Webserver (line 347) ok https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html writing output... [ 40%] import_export (line 125) ok https://en.wikipedia.org/wiki/NHibernate (line 282) ok http://odf-converter.sourceforge.net/ (line 242) ok https://www.ctan.org/ (line 242) ok https://www.ctan.org/tex/ (line 340) ok https://texy.info/en/try/4q5we (line 340) ok https://texy.info/ (line 355) ok http://www.yaml.org (line 319) ok https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html (line 335) ok http://www.scriptalicious.com/blog/2009/04/complete-inserts-or-extended-inse... writing output... [ 45%] index writing output... [ 50%] intro (line 47) ok https://www.phpmyadmin.net/translations/ writing output... [ 54%] other (line 21) ok https://cihar.com/publications/linuxsoft/ (line 27) ok http://www.php-editors.com/articles/sql_phpmyadmin.php (line 26) ok http://garv.in/tops/texte/mimetutorial (line 33) redirect http://php-myadmin.ru/ - permanently to https://php-myadmin.ru/ (line 28) ok http://www.iis-aid.com/articles/how_to_guides/install_and_configure_phpmyadm... writing output... [ 59%] privileges writing output... [ 63%] relations writing output... [ 68%] require (line 31) ok https://secure.php.net/libxml (line 34) ok https://secure.php.net/openssl (line 26) ok https://secure.php.net/openssl (line 59) ok https://jquery.com/browser-support/ (line 37) ok https://secure.php.net/curl writing output... [ 72%] security (line 106) ok https://files.phpmyadmin.net/phpmyadmin.keyring (line 37) ok https://en.wikipedia.org/wiki/Cross-site_scripting (line 71) ok https://en.wikipedia.org/wiki/SQL_injection (line 85) ok https://en.wikipedia.org/wiki/Brute-force_attack (line 56) ok https://en.wikipedia.org/wiki/Cross-site_request_forgery (line 106) ok https://keybase.io/phpmyadmin_sec (line 110) ok https://github.com/phpmyadmin/phpmyadmin/labels/hardening writing output... [ 77%] settings writing output... [ 81%] setup (line 85) ok https://fedoraproject.org/wiki/EPEL/FAQ#howtouse (line 85) ok https://fedoraproject.org/wiki/EPEL (line 102) ok https://en.wikipedia.org/wiki/List_of_AMP_packages (line 114) ok https://getcomposer.org/ (line 133) ok https://packagist.org/ (line 53) ok https://launchpad.net/~nijel/+archive/ubuntu/phpmyadmin (line 47) broken https://software.opensuse.org/package/phpMyAdmin - HTTP Error 503: Service Unavailable (line 149) ok https://www.phpmyadmin.net/packages.json (line 41) ok https://anonscm.debian.org/cgit/collab-maint/phpmyadmin.git/tree/debian/READ... (line 98) redirect https://www.apachefriends.org/ - with Found to https://www.apachefriends.org/index.html (line 579) ok https://www.phpmyadmin.net/ (line 579) redirect https://demo.phpmyadmin.net/STABLE/setup/ - with Found to http://demo.phpmyadmin.net/master/setup/ (line 243) ok https://hub.docker.com/r/_/mysql/ (line 243) ok https://hub.docker.com/r/_/mariadb/ (line 162) ok https://hub.docker.com/r/phpmyadmin/phpmyadmin/ (line 666) ok https://www.gnupg.org/gph/en/manual.html#AEN335 (line 338) ok https://github.com/phpmyadmin/docker (line 598) ok https://keybase.io/lem9 (line 607) ok https://keybase.io/ibennetch (line 616) ok https://keybase.io/nijel (line 1010) ok https://secure.php.net/manual/en/errorfunc.configuration.php#ini.display-err... (line 1101) ok https://github.com/phpmyadmin/phpmyadmin/issues/11922 (line 666) ok https://pgp.cs.uu.nl/paths/79be3e4300411886/to/ce752f178259bd92.html (line 1107) ok https://github.com/phpmyadmin/phpmyadmin/issues/11898 writing output... [ 86%] themes (line 6) ok https://www.phpmyadmin.net/themes/ writing output... [ 90%] transformations (line 135) ok https://secure.php.net/mysql_fetch_field (line 135) ok https://secure.php.net/mysql_fetch_field writing output... [ 95%] user writing output... [100%] vendors build finished with problems. Makefile:179: recipe for target 'linkcheck' failed make: *** [linkcheck] Error 1 make: Leaving directory '<https://ci.phpmyadmin.net/job/documentation/ws/doc'> Build step 'Execute shell' marked build as failure [WARNINGS] Skipping publisher since build result is FAILURE ------------------------------ Subject: Digest Footer _______________________________________________ Developers mailing list Developers@phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers ------------------------------ End of Developers Digest, Vol 26, Issue 3 *****************************************