Pagination page

louiegiezer · Post by **louiegiezer** » Thu Nov 17, 2011 5:21 pm

Hey Guys!

I'm planning to implement the pagination tutorial in my website made by Mr.Jacek so in this tutorial instead of the next page is a number i want to change it in Next and Previous is this possible?

Post by **jacek** » Thu Nov 17, 2011 10:16 pm

Post by **Temor** » Fri Nov 18, 2011 7:52 am

Yes. Very easily even.

If you're having troubles figuring it out, let me know

louiegiezer · Post by **louiegiezer** » Fri Nov 18, 2011 9:09 am

thanks. Lets begin

Post by **Temor** » Fri Nov 18, 2011 3:21 pm

show us what you have so far

louiegiezer · Post by **louiegiezer** » Fri Nov 18, 2011 4:42 pm

here's the code

user_list.php

<?php

include('core/init.inc.php');

$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
?>

<html>
	<head>
		<title>Pagination Test</title>
	</head>
	<body>
		<div>	
			<?php
				foreach (fetch_users($page, 5) as $user){
					echo "<p>{$user}</p>";
				}
				
			$total_pages = ceil(fetch_total_users() / 5);
			
			for ($i = 1; $i <= $total_pages; ++$i){
				echo " <a href=\"?page={$i}\">{$i}</a> ";
			}
			
			?>
		</div>
	</body>
</html>

user.inc.php

<?php

function fetch_users($page, $per_page){
	$start		 = (int)($page -1) * $per_page;
	$per_page	 = (int)$per_page;
	
	$query = mysql_query("SELECT `user_name` FROM `tester` LIMIT {$start}, {$per_page}");

	while (($row = mysql_fetch_assoc($query)) !== false){
		$users[] = $row['user_name'];
	}
	return $users;
}

function fetch_total_users(){
	$result = mysql_query('SELECT COUNT(`user_id`)FROM `tester`');
	
	return mysql_result($result, 0);
}
?>

so how to make this prev and next

Post by **jacek** » Sun Nov 20, 2011 12:21 am

Well the next page is current_page + 1 so

echo '<a href="?page=', ($page + 1), '">Next</a>';

should be a good place to start.

louiegiezer · Post by **louiegiezer** » Sun Nov 20, 2011 6:31 pm

well its better if you give the exact code in prev and next..

bowersbros · Post by **bowersbros** » Sun Nov 20, 2011 7:18 pm

Jacek has given you exactly what you need to figure it out for yourself.

You wont learn if he provides code for you, and frankly. Why should he do it for you? Its your website; Not his.

The code that Jacek gave will work, however you will need to adapt it slightly and enhance it abit more. Just give it a try.

BetterPHP

Pagination page

Pagination page

Re: Pagination page

Re: Pagination page

Re: Pagination page

Re: Pagination page

Re: Pagination page

Re: Pagination page

Re: Pagination page

Re: Pagination page