Show All Rows PHP 7.0.10
Posted by: charliemelrose (---.static.optonline.net)
Date: April 14, 2017 05:41PM

I installed the latest version of WAMP and am using PHP 7.0.10. I imported a .sql dump and it has several million rows. How do I "show all rows" and not be limited to 500 rows at a time? I did research and most of the advice is to modify the config.inc.php, hpwever, there is no such file in the latest version(s) of PHP in WAMP. Thanks for the help!!

Options: ReplyQuote
Re: Show All Rows PHP 7.0.10
Posted by: Otomatic (Moderator)
Date: April 14, 2017 06:32PM

Hi,

This has absolutely nothing to do with the version of PHP, nor the version of Wampserver.
These are settings for PhpMyAdmin.

There is a file "config.inc.php", that is the one of the personal configuration of phpMyAdmin:

wamp\apps\phpmyadmin4.7.0\config.inc.php

See file (do not modify) wamp\apps\phpmyadmin4.7.0\libraries\config.default.php for possible values, may be
$cfg['ShowAll']

And then, you have very badly looked for the files "config.inc.php" since there is also a second one, reserved for the configuration of Wampserver "wamp\scripts\config.inc.php" that should never be modified.

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.0.8 32 bit - Apache 2.4.25 - PHP 7.1.3/7.0.17/5.6.30 - MySQL 5.7.18 - MariaDB 10.1.21
Wampserver 3.0.8 64 bit - Apache 2.4.25 - PHP 7.1.3/7.0.17/5.6.30 - MySQL 5.7.18 - MariaDB 10.1.22
PhPMyAdmin 4.7.0 - MysqlDumper 1.24.5

Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.