Re: Multiple pages of data.
| From: | Matthew Fonda | Date: | Wed, 29 Sep 2004 05:45:51 +0000 |
| Subject: | Re: Multiple pages of data. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-198154@lists.php.net to get a copy of this message | ||
Or if you wanted to do it all in PHP, without using LIMIT, you could do
something like this.
I'm not exactly sure how your database is set up, so I just used this
made this dummy table as the one I will use in this example:
create table topics(id int(8) not null auto_increment, topic
varchar(30), author varchar(20), body text, primary key(id));
Ok, so then I just inserted some random data into to test with.
Here is some PHP code:
<?php
$link = mysql_connect('localhost', 'user', 'password');
mysql_select_db("database", $link);
$result = mysql_query("SELECT * FROM table", $link);
$num_rows = mysql_num_rows($result);
$all = array();
while ($topic = mysql_fetch_assoc($result)) {
$all[] = $topic;
}
if (isset($_GET['start'])) {
$start = $_GET['start'];
} else {
$start = 0;
}
for($i = $start; $i < $start + 15; $i++) {
echo "Topic ID: ". $all[$i]['id'] ."<br />";
echo "Topic Title: ". $all[$i]['topic'] ."<br />";
echo "Topic Author: ". $all[$i]['author'] ."<br />";
echo "Topic Body: ". $all[$i]['body'] ."<br />";
echo "<hr>";
if ($i == $start + 14) {
echo "<p><a href=\"pages.php?start=".($i+1)."\">Next
Page</a></p>";
}
}
mysql_free_result($result);
mysql_close($link);
?>
That will do simple paging, and works seems to work fine.
On Tue, 2004-09-28 at 22:05, Nick Patsaros wrote:
> I'm trying to build a bulletin style system right now. I have topics
> and replies to each topic. If a topic gets more than 15 replies I
> want them to start carrying over onto page 2 and then 3 and so on with
> 15 replies per page.
>
> The key that I'm missing I guess is, how do I keep track of the last
> accessed row in the database? So if I run a LIMIT 15 I can go back
> and pick up where I left on previously? Using the primary key isn't
> going to help because if posts get deleted I would have less than 15
> per page.
>
> Maybe I'm totally lost on this though, if someone could give me a bit
> of help on the most efficient way to accomplish this.
>
> --Nick