note 58719 added to control-structures.for
| From: | php-general at lists dot php dot net | Date: | Sun, 13 Nov 2005 23:23:41 +0000 |
| Subject: | note 58719 added to control-structures.for | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-98523@lists.php.net to get a copy of this message | ||
if you wanted to make a next previous thing for mysql this would be it
$page = $_GET['page'];
// mysql query goes here
$limit = 30; //gets 30 of whatever
if(!$page){
$page = "1";
}
$limitvalue = $page * $limit - ($limit); //find the limit value
$query = mysql_query("SELECT * FROM
tableORDER BY id DESC LIMIT $limitvalue,
$limit");
$numrows = mysql_query("SELECT * FROM forum_topics WHERE forumid =
'$fid'");
$numofpages = ceil($numrows / $limit);
while ($r = mysql_fetch_array($query)){
// your stuff goes here
}
$pageprev = $page-1;
$pagenext = $page+1;
if ($page != "1"){
echo " <a href='linkhere.php?page=$pageprev'><< Previous</a>
";
}
for ($i = 1; $i <= $numofpages; $i++) {
if ($i == $page){
echo "<b>$i</b> ";
}
else {
echo "<a href='linkhere.php?page=$i'>$i</a> ";
}
}
if ($numrows > $limit){
if ($page != $numofpages){
echo " <a href='linkhere.php?page=$pagenext'>Next >></a> ";
}
}
There is also a few other ways but this is how i do it ^^
----
Manual Page -- http://www.php.net/manual/en/control-structures.for.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+58719
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes&reason=non-english
Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes&reason=already+in+docs
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+58719&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+58719&report=yes
Search -- http://master.php.net/manage/user-notes.php