Simple pagination in PHP using Mysql
September 12th, 2009One Comment | Filed Under: Tutorials
This is the simple example about how to do pagination in PHP.
/*
Function to get simple query converted into pagination query
*/
{
if (isset($_GET['page']) && (int)$_GET['page'] > 0) {
$page = (int)$_GET['page'];
} else {
$page = 1;
}
// start fetching from this row number
$offset = ($page – 1) * $itemPerPage;
return $sql . "LIMIT $offset, $itemPerPage";
}
/*
Main function to do the pagination
Get the links to navigate between one result page to another.
Supply a value for $strGet if the page url already contain some
GET values for example if the original page url is like this :
http://www.abc.com/index.php?c=12
use "c=12" as the value for $strGet. But if the url is like this :
http://www.abc.com/index.php
then there's no need to set a value for $strGet
*/
{
$result = dbQuery($sql);
$pagingLink = '';
$totalResults = dbNumRows($result);
$totalPages = ceil($totalResults / $itemPerPage);
// how many link pages to show
$numLinks = 10;
// create the paging links only if we have more than one page of results
if ($totalPages > 1) {
$self = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] ;
if (isset($_GET['page']) && (int)$_GET['page'] > 0) {
$pageNumber = (int)$_GET['page'];
} else {
$pageNumber = 1;
}
// print 'previous' link only if we're not
// on page one
if ($pageNumber > 1) {
$page = $pageNumber – 1;
if ($page > 1) {
$prev = " <a href=\"$self?page=$page&$strGet/\">[Prev]</a> ";
} else {
$prev = " <a href=\"$self?$strGet\">[Prev]</a> ";
}
$first = " <a href=\"$self?$strGet\">[First]</a> ";
} else {
$prev = ''; // we're on page one, don't show 'previous' link
$first = ''; // nor 'first page' link
}
// print 'next' link only if we're not
// on the last page
if ($pageNumber < $totalPages) {
$page = $pageNumber + 1;
$next = " <a href=\"$self?page=$page&$strGet\">[Next]</a> ";
$last = " <a href=\"$self?page=$totalPages&$strGet\">[Last]</a> ";
} else {
$next = ''; // we're on the last page, don't show 'next' link
$last = ''; // nor 'last page' link
}
$start = $pageNumber – ($pageNumber % $numLinks) + 1;
$end = $start + $numLinks – 1;
$end = min($totalPages, $end);
$pagingLink = array();
for($page = $start; $page <= $end; $page++) {
if ($page == $pageNumber) {
$pagingLink[] = " $page "; // no need to create a link to current page
} else {
if ($page == 1) {
$pagingLink[] = " <a href=\"$self?$strGet\">$page</a> ";
} else {
$pagingLink[] = " <a href=\"$self?page=$page&$strGet\">$page</a> ";
}
}
}
$pagingLink = implode(' | ', $pagingLink);
// return the page navigation link
$pagingLink = $first . $prev . $pagingLink . $next . $last;
}
return $pagingLink;
}
/************************************************
This will come in a page where you want to do the pagination
// for paging
// how many rows to show per page
$rowsPerPage = 10;
$sql = "SELECT * FROM tbl_members ORDER BY name";
$result = mysql_query(getPagingQuery($sql, $rowsPerPage));
$pagingLink = getPagingLink($sql, $rowsPerPage);
/*********************************************************
Where you want to display the pagination write the code below
PHP script uploads files and manipulates images very easily
September 9th, 2009No Comments | Filed Under: Resources, Software & Tools
class.upload.php -
This PHP script uploads files and manipulates images very easily. The perfect script to generate thumbnails or create a photo gallery! It can convert, resize and work on uploaded images in many ways, add labels, watermarks and reflections and other image editing features. You can use it for files uploaded through an HTML form, a Flash uploader, or on local files. It uses the GD library.
Test your website in various versions of Internet Explorer
September 9th, 2009No Comments | Filed Under: Resources
One of a problem I seen while developing website’s is CSS layout is not working properly in all version of IE. Many people are still using IE 6 as their web browser in cyber cafe’s etc. There are tool’s like IETester, MultipleIE that can solve your problem.
These are great tool’s for all web designers.
1. IETester is a free WebBrowser that allows you to have the rendering and javascript engines of IE8, IE7 IE 6 and IE5.5 on Vista and XP, as well as the installed IE in the same process.
IETester is available for free download, try it yourself!
http://www.my-debugbar.com/wiki/IETester/HomePage
2. Multiple IE installer – ever wanted to test your website in various versions of Internet Explorer? It is possible to run Internet Explorer in standalone mode without having to over-write previous versions.
It is not difficult to follow the instructions and get any version of IE running in standalone along side other versions.
Multiple-IE is available for free download, try it yourself!
Download Multiple IE installer (10.3MB)