Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Limit function

  1. #1
    Regular Coder
    Join Date
    Sep 2008
    Posts
    697
    Thanks
    8
    Thanked 17 Times in 16 Posts

    Limit function

    Can someone add a limit function to this, kind of like a pagination?

    Like after 5 it makes it stop and you have to go another page like page.php?page=2

    something like that.
    code:
    PHP Code:
    <?php

    require("inc/config.php");
    if (isset(
    $_POST['del'])) 
    {

        for (
    $count 0;$count<count($_POST[delchk]);$count++)
       {
               
    $delete $_POST[delchk][$count];
               
    $query "DELETE FROM accounts WHERE id = '$delete'";
               
    $result mysql_query($query);
               if (!
    $result
       {
                die(
    "Error deleting accounts! Query: $query<br />Error: ".mysql_error());
            }
        }
    }
    $result mysql_query("SELECT * FROM accounts");

    // Check how many rows it found
    if(mysql_num_rows($result) > 0){
    echo 
    "<h2>Logged Account Details</h2>";
    echo 
    "<table class=\"gridtable\">
    <thead>

        <tr>
            <th align=\"center\" scope=\"col\">Delete?</th>
            <th align=\"center\" scope=\"col\">Username</th>
            <th align=\"center\" scope=\"col\">Password</th>
            <th align=\"center\" scope=\"col\">Highscores</th>
            <th align=\"center\" scope=\"col\">Date</th>
            <th align=\"center\" scope=\"col\">IP Address</th>
            <th align=\"center\" scope=\"col\">Status</th>
        </tr>
    </thead>
    <tbody>"



    echo 
    "<form name = 'myform' action='' method='post'>";
    while(
    $row mysql_fetch_array($result))
      {
      echo 
    "<tr align=\"center\">";
      echo 
    '<td><input type="checkbox" id="delchk" name="delchk[]" value="'.$row['id'].'" /></td>';  
      echo 
    "<td class=\"valid\" >" $row['username'] . "</td>";
      echo 
    "<td class=\"valid\" >" $row['password'] . "</td>";
      echo 
    "<td><a target=frame2 href='" ."http://hiscore.runescape.com/hiscorepersonal.ws?user1="$row['username'] ."'>Check Highscores</a></td>"
      echo 
    "<td>" $row['addeddate'] . "</td>";
      echo 
    "<td>" $row['ip'] . "</td>";
      echo 
    "<td><img src=\"img/invalid.png\" title=\"Account information: INVALID!\"/><img src=\"img/valid.png\" title=\"Account information: VALID!\"/></td>";
      echo 
    "</tr>";
      }
    echo 
    "</tbody>";
    echo 
    "</table>";
    echo 
    "<hr>";
    echo 
    "<input type='submit' name = 'del' value='Delete Selected'></form>";
    echo 
    "<input type='button' onclick='checkall(document.myform[\"delchk\"]);' value='Select All'>";
    echo 
    "<input type='button' onclick='uncheckall(document.myform[\"delchk\"]);' value='Deselect All'>";
    echo 
    "<hr>";
    }

    else{
    // No rows were found ...
    echo '<center>No logged accounts.</center><hr>'
    }

    mysql_close();
    ?>
    Thank You.

  • #2
    Regular Coder
    Join Date
    Sep 2008
    Posts
    697
    Thanks
    8
    Thanked 17 Times in 16 Posts
    I have added it:
    PHP Code:
    <script type="text/javascript">
       function checkall(delchk)
       {
          for (i = 0; i < delchk.length; i++)
          delchk[i].checked = true;
       }
    </script>

    <script type="text/javascript">
       function uncheckall(delchk)
       {
          for (i = 0; i < delchk.length; i++)
          delchk[i].checked = false;
       }
    </script>


    <?php
    include("inc/config.php");
    if (isset(
    $_POST['del'])) 
    {
      for (
    $count 0;$count<count($_POST[delchk]);$count++)
       {
               
    $delete $_POST[delchk][$count];
               
    $query "DELETE FROM accounts WHERE id = '$delete'";
               
    $result mysql_query($query);
               if (!
    $result
       {
                die(
    "Error deleting accounts! Query: $query<br />Error: ".mysql_error());
            }
        }
    }
      echo 
    "<table class=\"gridtable\">
    <thead>
        <tr>
            <th align=\"center\" scope=\"col\">Username</th>
            <th align=\"center\" scope=\"col\">Password</th>
            <th align=\"center\" scope=\"col\">Highscores</th>
            <th align=\"center\" scope=\"col\">Date</th>
            <th align=\"center\" scope=\"col\">IP Address</th>
            <th align=\"center\" scope=\"col\">Status</th>
           <th align=\"center\" scope=\"col\">Delete?</th>
        </tr>
    </thead>
    <tbody>"
    ;
    echo 
    "<form name = 'myform' action='' method='post'>";
    $pagenum = (isset($_GET['pagenum'])) ? (int) $_GET['pagenum'] : 1;
    $data mysql_query("SELECT * FROM accounts") or die(mysql_error());
    $rows mysql_num_rows($data);
    $page_rows 4;
    $last ceil($rows/$page_rows);
    if (
    $pagenum 1)
    {
    $pagenum 1;
    }
    elseif (
    $pagenum $last)
    {
    $pagenum $last;
    }
    $max 'limit ' .($pagenum 1) * $page_rows .',' .$page_rows;
    $data_p mysql_query("SELECT * FROM accounts $max") or die("");  
    while(
    $info mysql_fetch_array$data_p ))
      {
      echo 
    "<tr align=\"center\">";
      echo 
    "<td class=\"valid\" >" $info['username'] . "</td>";
      echo 
    "<td class=\"valid\" >" $info['password'] . "</td>";
      echo 
    "<td><a target=frame2 href='" ."profile/hiscorepersonal.ws?user1="$info['username'] ."'>Check Highscores</a></td>"
      echo 
    "<td>" $info['addeddate'] . "</td>";
      echo 
    "<td>" $info['ip'] . "</td>";
      echo 
    "<td><img src=\"img/invalid.png\" title=\"Account information: INVALID!\"/><img src=\"img/valid.png\" title=\"Account information: VALID!\"/></td>";
       echo 
    '<td><input type="checkbox" id="delchk" name="delchk[]" value="'.$info['id'].'" /></td>';  
      echo 
    "</tr>";
      }
    echo 
    "</tbody>";
    echo 
    "</table>";
    echo 
    "<hr>";
    echo 
    "<input type='submit' name = 'del' value='Delete Selected'></form>";
    echo 
    "<input type='button' onclick='checkall(document.myform[\"delchk\"]);' value='Select All'>";
    echo 
    "<input type='button' onclick='uncheckall(document.myform[\"delchk\"]);' value='Deselect All'>";
    echo 
    "<hr>";
    if (
    $pagenum == 1)
    {
    }
    else
    {
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'>First</a> ";
    echo 
    " | ";
    echo 
    " ";
    $previous $pagenum-1;
    $current $pagenum;
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'>$previous</a> ";
    echo 
    " | ";
    }
    echo 
    "$pagenum";
    if (
    $pagenum == $last)
    {
    }
    else {
    $next $pagenum+1;
    echo 
    " | ";
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'> $next</a> ";
    echo 
    " ";
    echo 
    " | ";
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last</a> ";
    }
    ?>

    Basically when you view the page and view the source the code stops at
    Code:
    <form name = 'myform' action='' method='post'>
    so it cuts of everything under it, like the footer and some other things.

    That only happens when there are no records in the table, when there are the web page loads full working.
    Last edited by bucket; 11-03-2009 at 06:21 PM.

  • #3
    Regular Coder
    Join Date
    Sep 2008
    Posts
    697
    Thanks
    8
    Thanked 17 Times in 16 Posts
    Bump.

  • #4
    Regular Coder
    Join Date
    Sep 2008
    Posts
    697
    Thanks
    8
    Thanked 17 Times in 16 Posts
    Okay I got it to show no pages when there is no records in the database.
    And I also got it to show when there are records in the database to show pages.

    But now the pages dont work. When I click to go to page 2 it shows the first 4 records from page 1.

    PHP Code:
    <?php
    include("inc/config.php");
    if (isset(
    $_POST['del'])) 
    {
      for (
    $count 0;$count<count($_POST[delchk]);$count++)
       {
               
    $delete $_POST[delchk][$count];
               
    $query "DELETE FROM accounts WHERE id = '$delete'";
               
    $result mysql_query($query);
               if (!
    $result
       {
                die(
    "Error deleting accounts! Query: $query<br />Error: ".mysql_error());
            }
        }
    }
      echo 
    "<table class=\"gridtable\">
    <thead>
        <tr>
            <th align=\"center\" scope=\"col\">Username</th>
            <th align=\"center\" scope=\"col\">Password</th>
            <th align=\"center\" scope=\"col\">Highscores</th>
            <th align=\"center\" scope=\"col\">Date</th>
            <th align=\"center\" scope=\"col\">IP Address</th>
            <th align=\"center\" scope=\"col\">Status</th>
           <th align=\"center\" scope=\"col\">Delete?</th>
        </tr>
    </thead>
    <tbody>"
    ;
    echo 
    "<form name = 'myform' action='' method='post'>";


    $data mysql_query("SELECT * FROM `accounts`") or die(mysql_error());
    $rows mysql_num_rows($data);
    $page_rows 4;
    $max_pages ceil($rows/$page_rows);

    $page = (int) $_GET['pagenum'];
    $pagenum = ($page && $page && $page <= $last) ? $page 1;
    $last ceil($rows/$page_rows);

    $max 'limit ' .($pagenum 1) * $page_rows .',' .$page_rows;
    $data_p mysql_query("SELECT * FROM accounts $max") or die(mysql_error());  
    while(
    $info mysql_fetch_array$data_p ))
      {
      echo 
    "<tr align=\"center\">";
      echo 
    "<td class=\"valid\" >" $info['username'] . "</td>";
      echo 
    "<td class=\"valid\" >" $info['password'] . "</td>";
      echo 
    "<td><a target=frame2 href='" ."profile/hiscorepersonal.ws?user1="$info['username'] ."'>Check Highscores</a></td>"
      echo 
    "<td>" $info['addeddate'] . "</td>";
      echo 
    "<td>" $info['ip'] . "</td>";
      echo 
    "<td><img src=\"img/invalid.png\" title=\"Account information: INVALID!\"/><img src=\"img/valid.png\" title=\"Account information: VALID!\"/></td>";
       echo 
    '<td><input type="checkbox" id="delchk" name="delchk[]" value="'.$info['id'].'" /></td>';  
      echo 
    "</tr>";
      }
    echo 
    "</tbody>";
    echo 
    "</table>";
    echo 
    "<hr>";
    echo 
    "<input type='submit' name = 'del' value='Delete Selected'></form>";
    echo 
    "<input type='button' onclick='checkall(document.myform[\"delchk\"]);' value='Select All'>";
    echo 
    "<input type='button' onclick='uncheckall(document.myform[\"delchk\"]);' value='Deselect All'>";
    echo 
    "<hr>";
    if (
    $pagenum == 1)
    {
    }
    else
    {
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'>First</a> ";
    echo 
    " | ";
    echo 
    " ";
    $previous $pagenum-1;
    $current $pagenum;
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'>$previous</a> ";
    echo 
    " | ";
    }
    echo 
    "$pagenum";
    if (
    $pagenum == $last)
    {
    }
    else {
    $next $pagenum+1;
    echo 
    " | ";
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'> $next</a> ";
    echo 
    " ";
    echo 
    " | ";
    echo 
    " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last</a> ";
    }
    ?>


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •