help add pagination

[$php_mysql$]

someone guide me on adding page limit please

 

here is my sql

 

function getDetails($ID) {
		$posts = array();
		$sql    = "SELECT * FROM `tbl` AS d
            WHERE d.id = '".$ID."'";
		$rs = executeSql($sql);
		while($row = mysql_fetch_array($rs)) {
		$posts[] = $row;
		}
		return $posts;	
    }	

 

and this is how i display it

 

<?php

if(!count($adsPost)){
print 'no records';
}else{

foreach($adsPost as $p){
echo "<a href=\"ads_details.php?Category=$catName&ID=".$p['id']."\">".$p['adtitle']."</a>, ".$p['postersname'].", ".date('F jS, Y, g:i a',$p['adtime'])."<br/>";
}
}

?>	

 

i wish to add 15 results in a page, anyone know how to get it done?

 

i want it like

 

<< first page 1 2 3 4 5 [6] 7 last page>>

[Muddy_Funster]

there are several gudes to this already, try searching the forums.

[AyKay47]

there are many resources on this topic both here and on the web...

many pre-made scripts etc...

[$php_mysql$]

i have seen but i need guidance mebbe you could show me how and where to start?

[AyKay47]

http://www.google.com/#hl=en&xhr=t&q=php+pagination&cp=9&pf=p&sclient=psy&source=hp&aq=0&aqi=g5&aql=&oq=php+pagin&pbx=1&bav=on.2,or.r_gc.r_pw.&fp=68b3f9ae28a95316&biw=1920&bih=999

[PFMaBiSmAd]

I recommend that you find a php class that does this so that you can pass it your basic query and it provides the methods/properties necessary to add pagination into your existing script.

[$php_mysql$]

not helping, understanding nothing at all. can someone show me on my codes above how to get it done?

[darkfreaks]

http://www.phpsnaps.com/snaps/view/php-pagination-class/

[phpSensei]

OP, instead of all the helpful advice you have been given, i'll attempt to explain pagination. Pagination works based on the offset, this is what actually makes it possible.

 

Heres an explanation of whats going on

 

1. Grab current page number in the HTTP VAR

$currentpage = $_GET['page']

2. Count the number of rows inside the table you are going to display in the screen

$num_rows = mysql_num_rows($query);

3. Create a variable, name it what you want in order to set a limit for the results per page ($rowsperpage= 10)

4. Calculate the total number of pages you are to get, you will need this...

 

$totalpages= ceil($num_rows/$rowsperpage)

 

5. Now we now how the total number of pages, and the number of results per page to display

6. We need to create an offset, meaning display a certain number of results from starting from this offset based on the current page number

 

$offset = ($currentpage - 1) * $rowsperpage;

 

7. Now plug this offset into your second query which will actually DISPLAY your content based on the offset, and the total page. The offset tells the code where to start in the query and the total pages tells it where to stop.

 

$sql = mysql_query("SELECT * FROM table_name LIMIT $offset, $rowsperpage");

 

8. Create a while loop, display the data.

 

http://www.phpfreaks.com/tutorial/basic-pagination

[AyKay47]

i don't help people that just want the cde written for them, if you want to learn PHP, study and view the provided links..they explain how it works..im not going to write something here that has already been written and explained somewhere else

[voip03]

This is good one

http://www.phpfreaks.com/tutorial/basic-pagination

 

phpSensei  that  g8

[AyKay47]

This is good one

http://www.phpfreaks.com/tutorial/basic-pagination

 

phpSensei  that  g8

that link was already given..

[voip03]

O  sorry miss line 8