GoFuckYourself.com - Adult Webmaster Forum - View Single Post

eMonk · 10-27-2011, 10:15 AM

I've been searching the web for basic php/mysql pagination tutorials to learn from since my book didn't cover this and having some problems.

Here's one that I'd like to learn from but it doesn't explain how to display the results on each page. After reading other pagination tutorials, I added a while loop and another query. Here's the link with source code, however I had to make some changes to make it work with mysqli:

http://www.tyleringram.com/blog/basi...ation-tutorial

Here's the while loop I added before the pages get echoed:

Code:

$max = 'limit ' .($page - 1) * $LIMIT .',' .$LIMIT;
$data_p = "SELECT * FROM model $max";
$result_2 = $db->query($data_p);

while ($list = $result_2->fetch_assoc()) {
   // echo data
   echo $list['id'] . " : " . $list['name'] . "<br />";
}

This works and displays the first 5 results on page 1 but once you click on page 2, I get a 404 error because the page doesn't exist. How can I view the results on page 2 and 3, etc?

The url output appears like this:

http://www.domain.com/2
http://www.domain.com/3
http://www.domain.com/4
etc.....

10-27-2011, 10:15 AM
eMonk Confirmed User Industry Role: Join Date: Aug 2003 Location: Canada Posts: 2,310	PHP and MySQL Pagination I've been searching the web for basic php/mysql pagination tutorials to learn from since my book didn't cover this and having some problems. Here's one that I'd like to learn from but it doesn't explain how to display the results on each page. After reading other pagination tutorials, I added a while loop and another query. Here's the link with source code, however I had to make some changes to make it work with mysqli: http://www.tyleringram.com/blog/basi...ation-tutorial Here's the while loop I added before the pages get echoed: Code: $max = 'limit ' .($page - 1) * $LIMIT .',' .$LIMIT; $data_p = "SELECT * FROM model $max"; $result_2 = $db->query($data_p); while ($list = $result_2->fetch_assoc()) { // echo data echo $list['id'] . " : " . $list['name'] . "<br />"; } This works and displays the first 5 results on page 1 but once you click on page 2, I get a 404 error because the page doesn't exist. How can I view the results on page 2 and 3, etc? The url output appears like this: http://www.domain.com/2 http://www.domain.com/3 http://www.domain.com/4 etc.....