I have this script (please adapt the section where the
results are showed)
<?php
// Request for parameters.
$offset =3D $_REQUEST['offset'];
$pgnum =3D $_REQUEST['pgnum'];
// Make that they are integer - security.
settype($offset, 'integer');
settype($pgnum, 'integer');
// Open database, i.e PostgreSQL
$connuserpostgres");
if (!$conn) {
echo "An error occured.\n";
exit;
}
// Initialize variables.
$limit=3D20; // rows to return
$numresults=3Dpg_query("select * from table"); //
PostgreSQL
$numrows=3Dpg_num_rows($numresults);
// next determine if offset has been passed to
script, if not use 0
if (empty($offset)) {
$offset=3D0;
$pgnum=3D1;
}
// get results
$result=3Dpg_query("select autor, titulo from table
limit $limit offset $offset"); // PostgreSQL
// now you can display the results returned
//echo "OffSet ".$offset." Page# ".$pgnum."<br><br>";
echo "<table><tr>";
echo "<td><b>Autor</b></td>";
echo "<td><b>Titulo</b></td>";
echo "</tr>";
while ($row =3D pg_fetch_array($result, $i)) {
echo "<tr><td align=3D\"left\">";
//$arr =3D pg_fetch_array($result,($i));
for ($j=3D0; $j < count($row); $j++) {
/*
echo "<tr><td align=3D\"left\" colspan=3D\"2\">";
echo "$row[$j] ";
echo "</td></tr>";
*/
echo "$row[$j]";
//echo " $j['autor']";
=09
=09
}
echo "</td></tr>";
//echo "<BR>";
}
echo "</table>";
// calculate number of pages needing links
$pages=3Dintval($numrows/$limit);
// $pages now contains int of pages needed unless
there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
echo "<font size=3D1>";
// next we need to do the links to other results
if (pages!=3D1)
{
if ($pgnum=3D=3D1) {
print "<a
href=3D\"$PHP_SELF?offset=3D0&pgnum=3D1\">PREV</a>
\n";
}
else
{
$prevoffset=3D$offset-20;
$cpgnum =3D intval($prevoffset/$limit)+1;
print "<a
href=3D\"$PHP_SELF?offset=3D$prevoffset&pgnum=3D$cpgnum\">PR EV</a>
\n";
}
}
for ($i=3D1;$i<=3D$pages;$i++) { // loop thru
$newoffset=3D$limit*($i-1);
$cpgnum =3D $i;
print "<a
href=3D\"$PHP_SELF?offset=3D$newoffset&pgnum=3D$cpgnum\">$cp gnum</a>
\n";
}
// check to see if last page
if ($pages!=3D1)
{
if ($pgnum<$pages) {
$newoffset=3D$offset+$limit;
$cpgnum =3D intval(($offset+$limit)/$limit)+1;
print "<a
href=3D\"$PHP_SELF?offset=3D$newoffset&pgnum=3D$cpgnum\">NEX T</a><p>\n";
}
else
{
print "<a
href=3D\"$PHP_SELF?offset=3D$newoffset&pgnum=3D$pages\">NEXT</a><p>\n";
}
}
// Close database.
pg_close($conn);
?>
--- David Busby <busby [at] pnts.com> escreveu: > Paging
with PostgreSQL is super easy!
> select * from table where (x=3Dy) offset 0 limit 30;
> Gives you the first 30 matches, then do
> select * from table where (x=3Dy) offset 30 limit
> 30;
> This will give the next 30, super easy!
>
> Here's a sample of how I use it in a script
>
> // Collect offset
> $offset =3D isset($_GET['offset'])?$_GET['offset']:0;
> // Now the links for Prev/Next
> if ($offset >=3D 30) echo "|<a
>
href=3D'/contents.php?".$qs."offset=3D".($offset-30)."'>Back
> 30</a>";
> echo "|<a
>
href=3D'/contents.php?".$qs."offset=3D".($offset+30)."'>Next
> 30</a>";
> // Query
> $rs =3D pg_exec($db,"select id,name from stuff order
> by name offset $offset
> limit 30;");
>
> /B
>
>
> ----- Original Message -----
> From: "Lynna Landstreet" <lynna [at] gallery44.org>
> To: <pgsql-php [at] postgresql.org>
> Sent: Friday, August 08, 2003 13:30
> Subject: [PHP] Paging results
>
>
> > HI there,
> >
> > Thanks to everyone who helped with my keyword
> problem - I think I thanked
> > them all individually but I thought I should
> mention it here too.
> >
> > Now, a new question:
> >
> > Does anyone know if there's a PHP class anywhere
> out there for paging
> > results from a PostgreSQL query, similar to
> Paginator or ezResults which
> do
> > that for MySQL? Or do I have to do the code for
> that from scratch?
> >
> > Alternatively, would it be difficult to adapt one
> of those to working with
> > PostgreSQL instead of MySQL?
> >
> >
> > Lynna
> > --
> > Resource Centre Database Coordinator
> > Gallery 44
> > www.gallery44.org
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo [at] postgresql.org
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
=3D=3D=3D=3D=3D
=C2ngelo Marcos Rigo
AMR Inform=E1tica
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo [at] yahoo.com.br
____________________________________________________________ ___________
Conhe=E7a o novo Cad=EA? - Mais r=E1pido, mais f=E1cil e mais preciso.
Toda a web, 42 milh=F5es de p=E1ginas brasileiras e nova busca por imagen=
s!
http://www.cade.com.br
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo [at] postgresql.org so that your
message can get through to the mailing list cleanly
