将Paging添加到PHP / mySQL列表中

Question

I have a php/mysql list, where I can display lots of thumbnails.

My problem is that there are too many images to display in one page. I would like to divide it so that I can get some page links or something at the bottom?

Like: 1,2,3,4,5,6,7,8 or next and prev...

Here is the current code:

<?php
    if ($db_found) {
        $SQL = "SELECT * FROM myTable";
        $result = mysql_query($SQL);

        while ($db_field = mysql_fetch_assoc($result)) {
            echo '<li>';
            echo '<div class="thumb"><img src="images/thumbnails/'.$db_field['image'].'" alt="" /></a></div>';
            echo '</li>';
        }
        mysql_close($db_handle);
    }
?>

How can I add some page links here?

Answer 1

it's much more easy with Jquery but i Recommends you to work with PHP for start, It can only develop your head than to add some JQuery code will get you everything. anyway simple paging with PHP goes like that, the key's for learning this code is to understand: intval,LIMIT,mysql_num_rows,mysql_fetch_assoc,mysql_fetch_row,ceil,COUNT after you will learn each off them the code will be much easy to understand and you can develop it and add some of your own Improvements. The Credit for this Excellent site : PHPGuide

 $per_page = 5; 
 $page = 1;

 if (isset($_GET['page'])) 
 {
  $page = intval($_GET['page']); 
  if($page < 1) $page = 1;
}


 $start_from = ($page - 1) * $per_page; 

 mysql_connect(..);
 mysql_select_db(..);

 $current_items = mysql_query( "SELECT * FROM `test` LIMIT $start_from, $per_page");
 if( mysql_num_rows($current_items) > 0)
 {
  while($item = mysql_fetch_assoc($current_items))
  {
    echo $item['text'], '<br/>';
  }
 }
 else
 {
  echo 'this page does not exists'; 
 }


 $total_rows = mysql_query("SELECT COUNT(*) FROM `test`");
 $total_rows = mysql_fetch_row($total_rows);
 $total_rows = $total_rows[0];

 $total_pages = $total_rows / $per_page;
 $total_pages = ceil($total_pages); # 19/5 = 3.8 ~=~ 4

 for($i = 1; $i  <= $total_pages; ++$i)
 {
  echo "<a href='?page=$i'>$i</a> &nbsp;&nbsp;";
 }

The Code is Very Easy to understand and very simple. and about the prev and forward page it's one of the improvements you will do after you get this code.