#1198 a "show 500" Button

invalid
nobody
5
2013-06-11
2010-01-22
Ruben Barkow
No

i often need the show all button, but:

a "show 500" Button would be nice
if there are not so many records, it will work like the (optional) "show all" button
and if there are more than 500 records, it is better than a show all
button, cause it creates less server load

Discussion

  • Ruben Barkow
    Ruben Barkow
    2010-01-24

    the patch would be easy:

    just edit the file libraries/display_tbl.lib.php

    find the line
    // end show all

    and add this after that line:

    // Display the "Show 500" button
    echo "\n";
    ?>
    <td>
    &nbsp;&nbsp;&nbsp;
    </td>
    <td>
    <form action="sql.php" method="post">
    <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
    <input type="hidden" name="sql_query" value="<?php echo $html_sql_query; ?>" />
    <input type="hidden" name="pos" value="0" />
    <input type="hidden" name="session_max_rows" value="500" />
    <input type="hidden" name="goto" value="<?php echo $goto; ?>" />
    <input type="submit" name="navig" value="Show 500" />
    </form>
    </td>
    <?php
    // end show 500

     
  • Michal Čihař
    Michal Čihař
    2011-03-02

    I think it is better to allow user to enter value how many rows he wants to see. With accepting your proposal, the reuqest to make this configurable will follow soon and it really does not improve situation much.

     
  • Michal Čihař
    Michal Čihař
    2011-03-02

    • status: open --> pending
     
  • Michal Čihař
    Michal Čihař
    2011-03-02

    • status: pending --> pending-rejected
     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending-rejected --> closed-rejected
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-rejected --> invalid