Teknik Paging di PHP (Previous n Next)

Paging atau yang biasa dikenal dengan pagination adalah sebuah teknik untuk memecah tampilan per halaman yang akan ditampilkan.


Untuk Database'a....

$server = "localhost";


$user = "username";


$pass = "";


$databasename = "namaDatabase";

Source Code ....

$db = mysql_connect($server, $user);


mysql_select_db($databasename,$db);





$sql = "SELECT * FROM yourtable WHERE yourconditions ORDER BY your_order ";


$query = mysql_query($sql,$db);


$total_results = mysql_num_rows($query);


$limit = "15"; //limit of archived results per page.


$total_pages = ceil($total_results / $limit); //total number of pages


if (empty($page))


{


$page = "1"; //default page if none is selected


}


$offset = ($page - 1) * $limit; //starting number for displaying results out of DB





$query = "SELECT * FROM yourtable WHERE yourconditions ORDER BY your_order LIMIT $offset, $limit";


$result = mysql_query($query);


//This is the start of the normal results...





while ($row = mysql_fetch_array($result))


{


// display your results as you see fit here.


}


mysql_close();








// This is the Previous/Next Navigation


echo "";


echo "Pages:($total_pages)  "; // total pages


if ($page != 1)


{


echo "<< First   "; // First Page Link


$prevpage = $page - 1;


echo " << "; // Previous Page Link


}


     if ($page == $total_pages) 


   {


         $to = $total_pages;


      } 


  elseif ($page == $total_pages-1) 


   {


         $to = $page+1;


      } 


  elseif ($page == $total_pages-2) 


   {


         $to = $page+2;


      } 


  else 


   {


         $to = $page+3;


      }


     if ($page == 1 || $page == 2 || $page == 3) 


   {


         $from = 1;


      } 


  else 


   {


         $from = $page-3;


      }





for ($i = $from; $i <= $to; $i++)





 {


 if ($i == $total_results) $to=$total_results;


 if ($i != $page)


  {


  echo "$i";


  }


 else


  {


  echo "[$i]";


  }


 if ($i != $total_pages)


  echo " ";


 }


if ($page != $total_pages)


{


$nextpage = $page + 1;


echo " >> "; // Next Page Link


echo "   Last >>"; // Last Page Link


}


echo "";





// This is the end of the Previous/Next Navigation