[RESOLVED] Pagination solution, I think

dcjones

Hi All,

I am working on a project that out puts data to a table from an SQL database.

I need to output 15 records at a time and display them for a set period, and then automatically rollover to the next page.

I know how to set the code up to create x number of page per record set but I am completely stuck on how to automatically rollover to the next page. The code for creating the x number of page per record set is below. Can anyone point me in the right direction as to how I can accomplish this task.

The code I am using to extract the data and create the x number of pages.

$maxRows_fids = 10;
$pageNum_fids = 0;
if (isset($_GET['pageNum_fids'])) {
  $pageNum_fids = $_GET['pageNum_fids'];
}
$startRow_fids = $pageNum_fids * $maxRows_fids;

mysql_select_db($database_flightq, $flightq);
$query_fids = "SELECT * FROM flightdata WHERE ArrivalOrDeparture = 'O'  ORDER BY ScheduledDateTime ASC";
$query_limit_fids = sprintf("%s LIMIT %d, %d", $query_fids, $startRow_fids, $maxRows_fids);
$fids = mysql_query($query_limit_fids, $flightq) or die(mysql_error());
$row_fids = mysql_fetch_assoc($fids);

if (isset($_GET['totalRows_fids'])) {
  $totalRows_fids = $_GET['totalRows_fids'];
} else {
  $all_fids = mysql_query($query_fids);
  $totalRows_fids = mysql_num_rows($all_fids);
}
$totalPages_fids = ceil($totalRows_fids/$maxRows_fids)-1;

$currentPage = $_SERVER["PHP_SELF"];

$queryString_fids = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_fids") == false && 
        stristr($param, "totalRows_fids") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_fids = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_fids = sprintf("&totalRows_fids=%d%s", $totalRows_fids, $queryString_fids);

The code I am using to create the static "back" and "forward" buttons which I am trying to make automatic.

<table border="0">
  <tr>
    <td><?php if ($pageNum_fids > 0) { // Show if not first page ?>
          <a href="<?php printf("%s?pageNum_fids=%d%s", $currentPage, 0, $queryString_fids); ?>">First</a>
          <?php } // Show if not first page ?>
    </td>
    <td><?php if ($pageNum_fids > 0) { // Show if not first page ?>
          <a href="<?php printf("%s?pageNum_fids=%d%s", $currentPage, max(0, $pageNum_fids - 1), $queryString_fids); ?>">Previous</a>
          <?php } // Show if not first page ?>
    </td>
    <td><?php if ($pageNum_fids < $totalPages_fids) { // Show if not last page ?>
          <a href="<?php printf("%s?pageNum_fids=%d%s", $currentPage, min($totalPages_fids, $pageNum_fids + 1), $queryString_fids); ?>">Next</a>
          <?php } // Show if not last page ?>
    </td>
    <td><?php if ($pageNum_fids < $totalPages_fids) { // Show if not last page ?>
          <a href="<?php printf("%s?pageNum_fids=%d%s", $currentPage, $totalPages_fids, $queryString_fids); ?>">Last</a>
          <?php } // Show if not last page ?>
    </td>
  </tr>
</table>

Many thanks in advance.

sneakyimp

You can use either Javascript or a meta refresh tag to get a page to automatically reload. This meta refresh tag would cause a page to refresh itself every 15 seconds:

<meta http-equiv="refresh" content="15" />

This tag would cause the current page to load the given url in 15 seconds

<meta http-equiv="refresh" content="15;url=http://example.com/" />

This is a PHP variant which should refresh the current page:

<meta http-equiv="refresh" content="15;url=<?php echo $_SERVER['SCRIPT_URL'] ?>" />

I think the trick here would be to construct the appropriate url in PHP and feed it to the meta tag. Make sure you set the offset correctly in the url.

dcjones

Hi sneakyimp,

Many thanks for your reply. It made me sit down and do some thinking.

What I came up with works to a degree. If I set the max number of row to be displayed tp 10, run the script I get odd results.

The SQL query result gives me 13 pages to display.
The 1st displays 13 records,
The 2nd page displays 12 records,
The 3rd page displays 11 records,
The 4th pages displays 10 records,
The 5th page displays 8 records,
The 6th page displays 11 records,

In my code below, can you see anything that may be causing this to happen.

[PHP
$maxRows_fids = 14;
$pageNum_fids = 0;
if (isset($GET['pageNum_fids'])) {
$pageNum_fids = $GET['pageNum_fids'];
}
$startRow_fids = $pageNum_fids * $maxRows_fids;

mysql_select_db($database_flightq, $flightq);
$query_fids = "SELECT * FROM flightdata WHERE ArrivalOrDeparture = 'O' ORDER BY ScheduledDateTime ASC";
$query_limit_fids = sprintf("%s LIMIT %d, %d", $query_fids, $startRow_fids, $maxRows_fids);
$fids = mysql_query($query_limit_fids, $flightq) or die(mysql_error());
$row_fids = mysql_fetch_assoc($fids);

if (isset($GET['totalRows_fids'])) {
$totalRows_fids = $GET['totalRows_fids'];
} else {
$all_fids = mysql_query($query_fids);
$totalRows_fids = mysql_num_rows($all_fids);
}
$totalPages_fids = ceil($totalRows_fids/$maxRows_fids)-1;

$currentPage = $_SERVER["PHP_SELF"];

$queryString_fids = "";

if (!empty($SERVER['QUERY_STRING'])) {
$params = explode("&", $SERVER['QUERY_STRING']);
$newParams = array();
$newParams;
foreach ($params as $param) {
if (stristr($param, "pageNum_fids") == false &&
stristr($param, "totalRows_fids") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_fids = "&" . htmlentities(implode("&", $newParams));
}
}

[/code]

dcjones

hi sneakyimp,

Sorry, forget the last reply, RESOLVED.

matthew9090

sneakyimp;10960977 wrote:
You can use either Javascript or a meta refresh tag to get a page to automatically reload. This meta refresh tag would cause a page to refresh itself every 15 seconds:
<meta http-equiv="refresh" content="15" />
This tag would cause the current page to load the given url in 15 seconds
<meta http-equiv="refresh" content="15;url=http://example.com/" />
This is a PHP variant which should refresh the current page:
<meta http-equiv="refresh" content="15;url=<?php echo $_SERVER['SCRIPT_URL'] ?>" />
I think the trick here would be to construct the appropriate url in PHP and feed it to the meta tag. Make sure you set the offset correctly in the url.

you could also use ajax