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

Go Back   Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more > Web Programming > PHP Development
User Name
Password

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 11-22-2005, 07:31 PM   #1 (permalink)
que
Member
 
Join Date: Aug 2005
Posts: 31
Default php pagination

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
que is offline   Reply With Quote
Sponsored Links
Old 11-23-2005, 11:55 PM   #2 (permalink)
cristobal
Senior Member
 
Join Date: Sep 2005
Posts: 219
Default

try phpmyadmin
Where is your DB installed?
There should be some SQL admin software from your host.
cristobal is offline   Reply With Quote
Old 11-24-2005, 10:00 AM   #3 (permalink)
que
Member
 
Join Date: Aug 2005
Posts: 31
Default

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
que is offline   Reply With Quote
Old 11-27-2005, 05:28 AM   #4 (permalink)
badshow_99
Member
 
Join Date: Nov 2005
Posts: 35
Default

well i know, in for jsp, there is a displaytag library, maybe you could search for something similar in here?
badshow_99 is offline   Reply With Quote
Old 02-16-2006, 01:34 AM   #5 (permalink)
pascalobispo
Junior Member
 
Join Date: Feb 2006
Posts: 2
Default Re: php pagination

PHP Pagination tutorial
pascalobispo is offline   Reply With Quote
Old 02-23-2006, 05:57 AM   #6 (permalink)
raul
Junior Member
 
Join Date: Feb 2006
Posts: 1
Lightbulb Re: php pagination

U could take a look at http://ionescuraul.users.phpclasses....ckage/2832.htm
raul is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Points Per Thread View: 1.00
Points Per Thread: 11.00
Points Per Reply: 5.00



» Sponsors

» Links

» Affiliates
Web Hosting
Marketing Find
Merchant Select
SiteMap Builder
Host Compare
Dedicated Servers

» Links

» Sports Network
Paintball Forum
Football Forum
Hockey Forum
Golf Forum
Boxing Forum
Lacrosse Forum
Baseball Forum
SnowBoarding Forum
Soccer Forum
MMA Forum


All times are GMT -4. The time now is 02:11 AM.



LinkBacks Enabled by vBSEO 3.0.0 RC8
Webmaster Forums