[RESOLVED] Need Pagination Help For Flatfile DB

DaleRobbins

I use the following code to display and paginate the log entries from a flatfile DB (one line per record with 5 fields delimited by | pipe symbols, such
as "name|address|city|state|zip"). I presently can navigate the pages with "Next Page" or "Previous Page" but would like to also display the number of pages available with links to each page. It would also help if I can count and display the total number of records (lines) in the DB.

I am fairly new to PHP and would appreciate any assistance you can provide. Thank you so much.

<?php

$data = file("passed.txt");

$perpage = 20; 
if(isset($_GET['start'])) $start = $_GET['start']; else $start = 0;
$numposts = count($data);
$data = array_slice($data, $start, $perpage);

foreach($data as $k => $v)
{
  echo $data[$k].''."\n";
}

if($start > 0)
{
	$text .= '<a href="tracking_log.php?start='.($start - $perpage).'">< Previous Page </a>';
}
if($start > 0 && $numposts > $perpage && $start < $numposts - $perpage)
{
	$text .= ' | ';
}
if($numposts > $perpage && $start < $numposts - $perpage)
{
	$text .= '<a href="tracking_log.php?start='.($start + $perpage).'">Next Page ></a>';
}
echo $text;

?>

DaleRobbins

I guess what I was looking for was this:

(just add this after echo $text😉

$numpages = ceil($numposts / $perpage);
echo "Page";
for( $i=1; $i<=$numpages; $i++ )
{
$pages = ($i -1);
$advance = ($pages * $perpage);
echo "<a href=paginate.php?start=$advance>";
$pages = ($i);
echo "&nbsp;";
echo "[$pages]</a>";
echo "&nbsp;";
}
echo "<br>";
echo "$numposts records";
echo "<br>";
echo "$numpages pages";

DaleRobbins

If someone has a better way of paginating the display of a flatfile DB, please let me know.

DaleRobbins

Here's the complete code if someone needs it. Once again, if you have a BETTER way of paginating a flatfile database, let me know.

$data = file("passed.txt");

$perpage = 20; //Obviously you would want to change this to something higher, depending on the content.
if(isset($_GET['start'])) $start = $_GET['start']; else $start = 0;
$numposts = count($data);
$data = array_slice($data, $start, $perpage);


foreach($data as $k => $v)
{
  echo $data[$k].''."\n";
}

echo "</table>";

echo "<center>";

if($start > 0)
{
	$text .= '<a href="tracking_log.php?start='.($start - $perpage).'">< Previous Page </a>';
}
if($start > 0 && $numposts > $perpage && $start < $numposts - $perpage)
{
	$text .= ' | ';
}
if($numposts > $perpage && $start < $numposts - $perpage)
{
	$text .= '<a href="tracking_log.php?start='.($start + $perpage).'">Next Page ></a>';
}
echo $text;

echo "<br>";
$numpages = ceil($numposts / $perpage);
echo "Go to Page";
for( $i=1; $i<=$numpages; $i++ )
{
$pages = ($i -1);
$advance = ($pages * $perpage);
echo "<a href=tracking_log.php?start=$advance>";
$pages = ($i);
echo "&nbsp;";
echo "[$pages]</a>";
echo "&nbsp;";
}
echo "<br>";
echo "$numposts log entries";
echo "<br>";

if(isset($_GET['start'])) $query = $_GET['start']; else $query = 0;
$query = ceil($query / $perpage);
$query = ($query +1);
echo "Page $query of $numpages";
echo "<br>";
echo "<br>";