4 Aug
2017
4 Aug
'17
7:30 p.m.
unsubscribe
-----Original Message-----
From: Developers [mailto:developers-bounces@phpmyadmin.net] On Behalf Of
developers-request(a)phpmyadmin.net
Sent: Friday, August 4, 2017 6:00 AM
To: developers(a)phpmyadmin.net
Subject: Developers Digest, Vol 26, Issue 3
Send Developers mailing list submissions to
developers(a)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(a)phpmyadmin.net
You can reach the person managing the list at
developers-owner(a)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(a)gmail.com>
To: phpMyAdmin developers <developers(a)phpmyadmin.net>
Subject: Re: [phpMyAdmin Developers] get the table name from sql query
Message-ID:
<CAO1FkOd3ATA_5589U3cazt_q8=JK-gvm_qF=agfrXFt7c1Jj=g(a)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(a)manishbisht.me
Website : https://manishbisht.me
On Wed, Aug 2, 2017 at 8:30 PM, Manish Bisht <manish.bisht490(a)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(a)manishbisht.me
Website : https://manishbisht.me
On Wed, Aug 2, 2017 at 8:18 PM, Manish Bisht <manish.bisht490(a)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(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
>>
------------------------------
Message: 2
Date: Fri, 4 Aug 2017 04:02:30 +0200 (CEST)
From: Jenkins Daemon <jenkins(a)phpmyadmin.net>
To: developers(a)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-m…
(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.h… - with
Found to
https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-…
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-in…
(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-totalnam…
(line 558) ok
https://suhosin.org/stories/configuration.html#suhosin-post-max-totalname-l…
(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-emo…
(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.re…
(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_innod…
(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-ins…
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_phpmyad…
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/REA…
(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-er…
(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(a)phpmyadmin.net
https://lists.phpmyadmin.net/mailman/listinfo/developers
------------------------------
End of Developers Digest, Vol 26, Issue 3
*****************************************