Re: pagination example?

From: Date: Wed, 23 Nov 2005 10:52:28 +0000
Subject: Re: pagination example?
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-40717@lists.php.net to get a copy of this message
$perpage = 10; $page = (!is_numeric($_GET['page'])) ? '1' : round($_GET['page']); $page = ($page-1) * $perpage; $sql = 'SELECT * FROM table WHERE 1 LIMIT '. $page .', '. $perpage; something like this? xkorakidis wrote: >Hi, I'm trying to find a simple example for pagination in php-mysql. I >found smth in php classes but it seems too complex (3-4 files and things >not so simple). Is there any simple way to do that? >Thanks. > > > -- -----BEGIN PGP PUBLIC KEY BLOCK----- Version: GnuPG v1.4.1 (MingW32) mQGiBEKI4BsRBACgj8tsbHAvQNmDao4v0FA5UU++ripJXitp4R0AKUfSnC89x9vO Ox39Ip6Cjvw7/TAYmZsOPKjHgL+j+aoz/hBWQBPkOScNQ3Tehc2RrpJd4f2rO+1n Rx5YeRLFIL7kII27rFisQNH3xWk+Srgml6tsiOsYAho+fwMAGc0IYr0alwCgjQ+D BQPpTIJSvZxJ2S2Q3e7tJB0D/0o27C6KOFcUIJKAi++DydXH7iWab/E8mLGFv0Ol tG/XNJWBo0p00bTrj93PoJ0zTsnZamuyfstzwGX/BqLQaCqGufpxD82jHxHC4SQC 3M3zXScYRfBeGU1ihIeQnbyH1zQeb5kq2ObmxzysBHXbTqSCE/aMEH0CxvNsGGNJ KQrtA/4majuB0O7jdyQM3Ec182HuQ0YvWPSyxQnWq9ZLStoSbIaRckZq1wNqVMHm kO1vS5Y4s4f5z7FaJKJh3wc2QQ/d+iMo5eDDd4a9PNZERzfKeqAJDun8HH6n5/DD Hu7soHugedjLQqaXYNjdPFJ0d/GPQp+AJ2gDm4K/sYUEfOCpRLQ2VW5uYXd1dCBM ZWVwYWlzYWxzdXdhbm5hICh0dXdhbm51KSA8dHV3YW5udUBnbWFpbC5jb20+iF4E ExECAB4FAkKI4BsCGwMGCwkIBwMCAxUCAwMWAgECHgECF4AACgkQey8SxD/BmXLX YACeJN0G+Pmjl1iWDfqIJa2T5NmnZBEAn1k4wmHUZxJogFwCfPDIQOxP6d1JuQIN BEKI4CkQCAC2tbrmFbSZmW4kbSNhqN9Oqcu+w+fpfu6vQQ3/0nWG03k6YkBNAg8f iDcuFo8vnCmH7X4IEGnSKOpXo2XlPmxfkTnoYuqyukjRNeYgAhBDKX0azMPa6hFc pWQj7VokoyGlwkiLo1a/99p0A+T05LUJp5zKVdbKWd6kconTDfgi+no7wL+f5YlM PH2pSa8CuMeCEhqL6xL5/qlFdzYPGjJj7UE73cZrTr0zPNIQt6RU6Rp8f4KyfAxm fqmjjUVL54J7qGFfIaB6b9Ca1PLvv3v7UjmggwJzfkNsoE1LgrNmMGDSut2mxh99 YDUum5xzuHY9DprJjbfMRwNY8h2sZjoDAAMFB/9oQSQU38bxKXw7LyI3y6Zxdvwy Mr36OIdibUYOpFmfN+MmKSEiwCk+4l9kRdZJzdQWRvADdaocWe9bB4eKGLTlSLbU gWRbAyJy1GjN5Y3EHd9xSrQQRk9ZYxAW5SQBYI0wKxQgi2Hf02q25nWjaNG4YOwZ snw8wyrqVLMHvwHA9csKewhuV9ZAoAD2AqAO7quif26zN5OjnoqjfT6yWHDLPEjU gdAsJkFDdncQEGNF5zJ7XxG1ybIMLVjvrAyvLHAsRp/G6OYurYaPIuQpHJXcLyOp VyBVj+FmOdDoSZoomMDkMOtqris97Rw9Rm4MRNELgl4KlItMg7o3r2ca/GufiEkE GBECAAkFAkKI4CkCGwwACgkQey8SxD/BmXK96wCfahapDeGs55QdeyZFsWrXejiv AtoAnjL/op77uRrkO8G+bm/H1xS5yJx1 =zCme -----END PGP PUBLIC KEY BLOCK-----

« previous php.db (#40717) next »