#673 (ok 3.4) store browse preferences (in cookies?)

Rob Kalkman

I love 'phpmyadmin'. Very useful. However, I have a
usability issue that could be solved easily, I would think.

For the type of work I'm doing, browsing/selecting by
LIMIT'ing 30 rows at a time doesn't really work for me. I
need to see all lines, or at least a group considerably
bigger than just 30 rows, in a table. As a result, I have
to change the display settings each and every time (e.g.
3000 rows, starting with row 0). It is just annoying
having to do that, and it doesn't make sense.

Would it be possible to just store these preference
settings in a cookie or so? You can even make it so
that there is a checkmark-box to give the user control
over the existence of such a cookie, just like many log-
on screens nowadays?


  • Ryan Schmidt

    Ryan Schmidt - 2005-01-23

    Logged In: YES

    If you are the only user of this phpMyAdmin installation,
    you can change the $cfg['MaxRows'] to a different value. If
    other people use this installation of phpMyAdmin and they
    do not want this altered MaxRows setting, then you could
    install a copy of phpMyAdmin just for you that you modify
    to suit your needs.

  • Rob Kalkman

    Rob Kalkman - 2005-01-23

    Logged In: YES

    Ryan, thanks for your suggestion.

    I cannot change the phpMyAdmin settings myself, since I'm
    using phpMyAdmin at several hosted accounts. I access the
    different databases (for different websites) from different PCs
    in different locations. A private copy locally on a PC wouldn't
    work, and some of the hosts don't even provide shell access,
    so installing a private copy is not an option there. Since the
    hosting companies are using phpMyAdmin as their official
    interface for their clients, I would assume that there are
    many people that are just end-users, that won't have control
    over the application settings.

    I realize that cookies wouldn't cover the multi-pc situation
    entirely, but having the option for the use of a cookie means
    that you only have to set these thing only once on that PC,
    or worst case, per session. That would still be an fast
    improvement over having to do it many times per session.

  • Rob Kalkman

    Rob Kalkman - 2005-01-23
    • priority: 5 --> 6
  • Marc Delisle

    Marc Delisle - 2008-07-26
    • priority: 6 --> 5
  • Michal Čihař

    Michal Čihař - 2011-03-02

    You can configure this using new user preferences module in phpMyAdmin 3.4.

  • Michal Čihař

    Michal Čihař - 2011-03-02
    • priority: 5 --> 1
    • summary: store browse preferences (in cookies?) --> (ok 3.4) store browse preferences (in cookies?)
    • status: open --> open-fixed
  • Michal Čihař

    Michal Čihař - 2011-05-11
    • status: open-fixed --> closed-fixed
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed