Next page...

rIkLuNd

Hello!
I'm trying to write a guestbook, and it's all going well, except one little this; How do I do to make for example 12 entries show up on a page, and then you have to go to the next page too see 10 older entries?

Hope that you can help me with this!

//rIkLuNd

james2010

This is how I do it:


$limiter = 10;
if(!$page)     // page is the current page #
  $start = 0;
else
  $start = $page;

$sql = "SELECT * FROM table ORDER BY field LIMIT $start,$limiter";

this limits the query to what ever amount of records you want per page. Then you can dynamically generate links to other pages based on the current page.

BLottman

I'd like to do the same but am unsure of where or how to implement the dynamic links. I've included the LIMIT $start, $limiter in the SQL statements but don't understand how to implement it in the code below.

The following code displays all records and I need to provide the user with links to each page of summary lines.

echo("<Table Align=Left Border=1>");
while ($row = mysql_fetch_array($result)){
$recordid = $row["ID"];
echo("<tr><td>" . $row["field1"] . "</td>");
echo("<td>" . $row["field2"] . "</td>");
echo("<td>" . $row["field3"] . "</td>");
echo("<td>" . $row["field4"] . "</td>");
echo("<td>" . $row["field5"] . "</td>");
echo("<td>" . $row["field6"] . "</td>");
echo("<td>" . $row["field7"] . "</td>");
echo("<td>" . $row["field8"] . "</td>");
echo("<td>" . $row["field9"] . "</td>");
echo("<td><a href='displayrecorddetails.php?ddetails=$recordid'>Display</A></td>
}
echo("</Table>");

Regards,

Bill.

james2010

Here's a simple example to get you started, it's pretty easy to modify this to do other things, for example dispaying all available pages or the previous page.

$limiter = 10;
if(!$page)
  $start = 0;
else
  $start = ($page-1)*$limiter;

$sql = "SELECT * FROM table ORDER BY field LIMIT $start,$limiter";
$result = mysql_query($sql);

// now put all your content to display the query results.. ie
while($rows = mysql_fetch_assoc($result))
{
  print $rows[field];
}

// determine the next page

if(!$page)
  $next_page = 2;
else
  $next_page = $page + 1;

print "<a href=\"" . $PHP_SELF . "?page=" . $next_page . "\">Next Page</a>";

BLottman

I have a form with the following header:

<form action="<?=$PHP_SELF?>" method=post>
....
....
</form>

When form is submitted, the While loop processes the rows that meet the expression and they display in sequence.

Then the Next Page link appears as the last row in the table. I set the $limiter = 3 since I only have 10 rows in the table (i.e., just learning).

When I press the Next Page link, it brings me back to the form and no more rows appear. Is it because I'm displaying the rows after the form appears on the same page as the form or should I display the rows on another page?

Regards,

Bill.

james2010

I'm not exactly sure what you're trying to do here. Are you passing data to new pages via your form? Or displaying the result of your query within <input> tags?

BLottman

Requirements:

User selects various drop down selects, on the search page in the form, to search the db for rows they wish to see. On submit, the submission form reappears at the top and just below it the resulting rows of data appear. The data is summary only. When the user clicks on the href link at the end of each row, the detail page is displayed. I'm able to limit the number of rows on the summary page but am unable to display more than the three initial rows (i.e., using the $limiter=3). Pressing the "Next Page" link redisplays the form submission page without any more subsequent summary data rows below it.

The search webpage has a form submission structure on it that contains various option select tags:

<form action="<?=$PHP_SELF?>" method=post>

<select name="fieldvar">
<option name ="fieldvar">Select All</option>
<option name ="fieldvar">Selection1</option>
<option name ="fieldvar">Selection2</option>
</select>

....

<select name="fieldvar2">
<option name ="fieldvar2">Select All</option>
<option name ="fieldvar2">Selection1</option>
<option name ="fieldvar2">Selection2</option>
</select>

....

<?php
include("settings.inc");
mysql_select_db("$mydb", $connection);
if ($submitsearch == "Submit") {

$result = @("Select ID, ... fieldnames...");

}

while ($row = mysql_fetch_array($result)){
$recordid = $row["ID"];
echo("<tr><td>" . $row["field1"] . "</td>");
echo("<td>" . $row["field2"] . "</td>");
echo("<td>" . $row["field3"] . "</td>");
echo("<td>" . $row["field4"] . "</td>");
echo("<td>" . $row["field5"] . "</td>");
echo("<td>" . $row["field6"] . "</td>");
echo("<td>" . $row["field7"] . "</td>");
echo("<td>" . $row["field8"] . "</td>");
echo("<td>" . $row["field9"] . "</td>");
echo("<td><a href='displayrecorddetail.php?drecord=recordid...
}
// determine the next page
if(!$page)
$next_page = 2;
else
$next_page = $page + 1;
echo "<tr><td colspan=10><a href=\"" . $PHP_SELF . "?

page=" . $next_page . "\">Next Page</a></td></tr>

Should I create a separate page to display the summary result rows and then manipulate the displaying of data using the "Next Page" link on that page instead of redisplaying the form submission page?