php pagination - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

que · 11-22-2005, 08:31 PM

Hello -

Well I have my database up and running and have it populated with plenty of data now. Currently I can only view all the records at once

. I need help with a php pagination script to view the database like PREV 1,2,3 NEXT.

Anyone know where I can find a easily customizable script like this?

thanks

cristobal · 11-24-2005, 12:55 AM

try phpmyadmin
Where is your DB installed?
There should be some SQL admin software from your host.

que · 11-24-2005, 11:00 AM

Thanks ~cristobal I know about phpmyadmin but I am building a script to display my data on my site.

Code:

<html> 
<head><title>My Page Title</title></head> 
<body> 
<?php 
$database="mydbname"; 
mysql_connect ("localhost", "myusername", "mypassword"); 
@mysql_select_db($database) or die( "Unable to select database"); 
$result = mysql_query( "SELECT * FROM mytable" ) 
or die("SELECT Error: ".mysql_error()); 
$num_rows = mysql_num_rows($result); 
print "There are $num_rows records.<P>"; 
print "<table width=400 border=1>\n"; 
while ($get_info = mysql_fetch_row($result)){ 
print "<tr>\n"; 
foreach ($get_info as $field) 
print "\t<td><font face=arial size=1/>$field</font></td>\n"; 
print "</tr>\n"; 
} 
print "</table>\n"; 
?> 
</body> 
</html>

This is what I have so far but I do not know how to add the PREV 1,2,3 NEXT part of it..
thanks

badshow_99 · 11-27-2005, 06:28 AM

well i know, in for jsp, there is a displaytag library, maybe you could search for something similar in here?

pascalobispo · 02-16-2006, 02:34 AM

PHP Pagination tutorial

raul · 02-23-2006, 06:57 AM

U could take a look at http://ionescuraul.users.phpclasses....ckage/2832.htm

alstonwillman · 06-25-2010, 08:18 AM

Can anyone could give me any idea of where to find a good PHP Pagination Script?

sandy_j_sam · 08-19-2010, 02:18 AM

Hi As we know that pagination concept we use for showing Record which we fetch From database. Actually here we used the concept, like that,

(1)first we know how much Record is placed in database.(suppose 100 Record in table1)
(2)Number of record which we want to show per page (suppose 20 Record Per Page)
(3)How many Page we need for getting that Record from Database ( i.e " 100/20 " =>5 ).

Now this is the basis concept, which we need.

jklm899 · 08-28-2010, 03:20 AM

这是新加的空白文章14，可以在ubb可视化编辑器中，添加和修改文章内容。

cyberdesignz · 08-30-2010, 06:43 AM

You can get the pagination by using remainder logic. For example you want to to have 10 results on a single page, then take the mod of ten and tell the condition that if mod of ten becomes zero then switch to the next page.