Reply to Re: How could I paginate the result set?

Your name:

Reply:


Posted by Kim Andrι Akerψ on 04/19/07 15:49

Man-wai Chang wrote:

> > Hi. You can use the query to do it for you, without PHP or stored
> > procedures.
> > SELECT * FROM table LIMIT 0, 10
>
> page 1 is easy. What about pageno > 1?

Using PHP (with explanations):

// Number of items per page.
$pagesize = 10;

// Get the page number from the user input.
$pageno = intval($_GET["page"]);

// In case "page=" in the URL query string was set to 0,
// a negative number, or not set at all.
if ($pageno < 1) { $pageno = 1; }

// Calculate the offset based on the page size and given page number.
$offset = ($pageno - 1) * $pagesize;

// Perform the
$query = "SELECT * FROM myTable LIMIT ".$offset.", ".$pagesize;
$result = mysql_query($query);

--
Kim AndrΓ© AkerΓΈ
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)

[Back to original message]


УдалСнная Ρ€Π°Π±ΠΎΡ‚Π° для программистов  •  Как Π·Π°Ρ€Π°Π±ΠΎΡ‚Π°Ρ‚ΡŒ Π½Π° Google AdSense  •  England, UK  •  ΡΡ‚Π°Ρ‚ΡŒΠΈ Π½Π° английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Π‘Π°ΠΉΡ‚ ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ Π² Π‘Ρ‚ΡƒΠ΄ΠΈΠΈ Π’Π°Π»Π΅Π½Ρ‚ΠΈΠ½Π° ΠŸΠ΅Ρ‚Ρ€ΡƒΡ‡Π΅ΠΊΠ°
ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ ΠΈ ΠΏΠΎΠ΄Π΄Π΅Ρ€ΠΆΠΊΠ° Π²Π΅Π±-сайтов, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚ΠΊΠ° ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎΠ³ΠΎ обСспСчСния, поисковая оптимизация