Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo


#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

    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

    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

    • priority: 5 --> 6
  • Marc Delisle
    Marc Delisle

    • priority: 6 --> 5
  • Michal Čihař
    Michal Čihař

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

  • Michal Čihař
    Michal Čihař

    • 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ř

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

    • Status: closed-fixed --> fixed