kalau saya punya data banyak bgt d tampilkan d halaman web dengan bentuk table maka akan panjang sekali k bawah. maka saya cari source yang bisa d tampilkan per halaman. waktu googling ternyata bnyak tapi menggunakan ASP (apa emang lg musim ASP ya). ternyata teman saya bisa yg dari ASP tersebut d jadikan k PHP (emang dya master :)) tapi codingnya banyak bgt, eh akhirnya dapet juga nih :
<?php
// how many rows to show per page
$rowsPerPage = 10;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$link=open_connection();
$query = "SELECT * FROM db_kar where nik_kar<>12345 LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, salah');
// print the random numbers
while($row = mysql_fetch_array($result))
{
bla... bla..
}
?>
dan ada dua model tampilannya…
yg pertama seperti
sourcenya :
<?php
// how many rows we have in database
$query = "SELECT COUNT(*) AS numrows FROM db_kar";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page "; // no need to create a link to current page
}
else
{
$nav .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
// creating previous and next link
// plus the link to go straight to
// the first and last page
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";
$first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">[Next]</a> ";
$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// print the navigation link
echo ("<font style='font-family: Arial,Verdana,Sans; font-size: 10pt; color: #FFFFFF'>");
echo $first . $prev . $nav . $next . $last;
echo ("</font>");
?>
yg ke dua
sourcenya:
<?php
// how many rows we have in database
$query = "SELECT COUNT(*) AS numrows FROM tbnom where nm_folder = '".$strfolder."'";
$res1=SQLQUERY($query,$conn);
$row = mysql_fetch_array($res1);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link
// print 'previous' link only if we're not
// on page one
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?show=$strfolder&page=$page\">[Prev]</a> ";
$first = " <a href=\"$self?show=$strfolder&page=1\">[First Page]</a> ";
}
else
{
$prev = ' [Prev] '; // we're on page one, don't enable 'previous' link
$first = ' [First Page] '; // nor 'first page' link
}
// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?show=$strfolder&page=$page\">[Next]</a> ";
$last = " <a href=\"$self?show=$strfolder&page=$maxPage\">[Last Page]</a> ";
}
else
{
$next = ' [Next] '; // we're on the last page, don't enable 'next' link
$last = ' [Last Page] '; // nor 'last page' link
}
// print the page navigation link
echo ("<font style='font-family: Arial,Verdana,Sans; font-size: 10pt; color: #FFFFFF'>");
echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last;
echo ("</font>");
?>