[phpMyAdmin Developers] Developers Digest, Vol 26, Issue 3
tkirby2605 at gmail.com
tkirby2605 at gmail.com
Fri Aug 4 18:30:45 CEST 2017
unsubscribe
-----Original Message-----
From: Developers [mailto:developers-bounces at phpmyadmin.net] On Behalf Of developers-request at phpmyadmin.net
Sent: Friday, August 4, 2017 6:00 AM
To: developers at phpmyadmin.net
Subject: Developers Digest, Vol 26, Issue 3
Send Developers mailing list submissions to
developers at 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 at phpmyadmin.net
You can reach the person managing the list at
developers-owner at 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 at gmail.com>
To: phpMyAdmin developers <developers at phpmyadmin.net>
Subject: Re: [phpMyAdmin Developers] get the table name from sql query
Message-ID:
<CAO1FkOd3ATA_5589U3cazt_q8=JK-gvm_qF=agfrXFt7c1Jj=g at 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 at manishbisht.me
Website : https://manishbisht.me
On Wed, Aug 2, 2017 at 8:30 PM, Manish Bisht <manish.bisht490 at 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 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
>>>
------------------------------
Message: 2
Date: Fri, 4 Aug 2017 04:02:30 +0200 (CEST)
From: Jenkins Daemon <jenkins at phpmyadmin.net>
To: developers at phpmyadmin.net
Subject: [phpMyAdmin Developers] Build failed in Jenkins:
documentation #452
Message-ID: <1761298704.1.1501812150990.JavaMail.jenkins at 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-maxlifetime
(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.html - with Found to https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.15/iconv_open.3.html
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-index-length
(line 554) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-array-index-length
(line 556) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-totalname-length
(line 558) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-totalname-length
(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-traversal
(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-emodifier
(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.real-connect-notes
(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_strict_mode
(line 2254) ok https://sites.google.com/site/bughunteruniversity/nonvuln/csv-excel-formula-injection
(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-inserts-in-phpmyadmin/
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_phpmyadmin_iis
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/README.Debian
(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-errors
(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 at phpmyadmin.net
https://lists.phpmyadmin.net/mailman/listinfo/developers
------------------------------
End of Developers Digest, Vol 26, Issue 3
*****************************************
More information about the Developers
mailing list