/Pager object example

## Pager object example
<?PHP
    // First off, how many items per page?
    $per_page = 4;

    // Next, get the total number of items in the database
    $num_videos = $db->getValue("SELECT COUNT(*) FROM videos where status = 'approved' ORDER BY dt");

    // Initialize the Pager object
    $pager = new Pager($_GET['p'], $per_page, $num_videos);

    // Using the data that $pager calculated for us, select the appropriate records from the database
    $videos = DBObject::glob('video', "SELECT * FROM videos WHERE status = 'approved' ORDER BY dt DESC LIMIT {$pager->firstRecord}, {$pager->per_page}");
?>
<html>
<body>

    <p>You are viewing videos <?PHP echo $pager->firstRecord; ?> through <?PHP echo $pager->lastRecord; ?>
    of <?PHP echo $pager->numRecords; ?> total.</p>

    <?PHP foreach($videos as $v) : ?>
    <!-- Do something with the video - display it perhaps -->
    <?PHP endforeach; ?>

    <!-- Simple Previous/Next links -->
    <a href="some-page.php?p=<?PHP echo $p->prevPage(); ?>">Previous Page</a>
    <a href="some-page.php?p=<?PHP echo $p->nextPage(); ?>">Next Page</a>

</body>
</html>
	<?PHP
	// First off, how many items per page?
	$per_page = 4;

	// Next, get the total number of items in the database
	$num_videos = $db->getValue("SELECT COUNT(*) FROM videos where status = 'approved' ORDER BY dt");

	// Initialize the Pager object
	$pager = new Pager($_GET['p'], $per_page, $num_videos);

	// Using the data that $pager calculated for us, select the appropriate records from the database
	$videos = DBObject::glob('video', "SELECT * FROM videos WHERE status = 'approved' ORDER BY dt DESC LIMIT {$pager->firstRecord}, {$pager->per_page}");
	?>
	<html>
	<body>

	<p>You are viewing videos <?PHP echo $pager->firstRecord; ?> through <?PHP echo $pager->lastRecord; ?>
	of <?PHP echo $pager->numRecords; ?> total.</p>

	<?PHP foreach($videos as $v) : ?>
	<!-- Do something with the video - display it perhaps -->
	<?PHP endforeach; ?>

	<!-- Simple Previous/Next links -->
	<a href="some-page.php?p=<?PHP echo $p->prevPage(); ?>">Previous Page</a>
	<a href="some-page.php?p=<?PHP echo $p->nextPage(); ?>">Next Page</a>

	</body>
	</html>