PHP Navigation

Hi frnds,

I want to have the code for PHP Navigation. Can anybody give me the code for it. I want navigaition as is in google.
e.g.
Previous 1 2 3 4 5 Next.

will be highly thankful

 

gosh... suppose you didn't try "pagination" search on google? anyhow, here's how it's done in a nuttshall, hope you'll get the picture and write the code for pagination yourself from now on:

OK, you have some recordset you need to paginate. Naturally, first you have to retrieve # of total records using:

SELECT count(*) FROM, or mysql_num_rows() ... and extract total number of records, let's say the varialbe is called $totalRecords. Then, define number of results for each page, let's call that $resultsPerPage, and assign some initial value to it. So far, the code might look like:

$totalRecords = mysql_num_rows($some_result_set);
$resultsPerPage = 20;

PHP:

Next thing we have one trivial thing - to find out how many pages will we have, so we need to divide total results and number of results per page. With given results we make a loop to echo out the pagination pages.

//find out total number of pages
$totalPages = ceil($totalRecords / $resultsPerPage);

//loop thru and echo the links
for ($i = 1; $i <= $totalPages; $i++)
   echo "<a href='".$_SERVER['PHP_SELF']."?page=".$i."'>$i</a> ";

PHP:

OK, so we have pagination now. Next thing is to display proper results once someone clicks on "Page 3", for example. The whole point is using LIMIT patameter to SELECT query to point the cursor to proper starting point on resultset. Pick up GET with "page" paremeter and calculate exact record to start with.

// multiply paging with results per page.
$fromResult = ($_GET['page']-1) * $resultsPerPage;

// make the query
SELECT * FROM ... LIMIT $fromResult, $resultsPerPage

PHP:

And that would be it... this is only basic pagination, you can make things much more complicated than this, but hopefully you'll grasp the idea.

Hope this helped