| php與ajax結合實現的無重新整理分頁的簡單例子,供初學的朋友參考。 無重新整理分頁,相容IE與Firefox等瀏覽器。 1、index.php 無重新整理分頁_bbs.it-home.org
2、sql.php ".$row["uname"].""; } $num=mysql_num_rows(mysql_query("select * from test")); $pagenum=@ceil($num/$pagesize); for($i=1;$i<=$pagenum;$i++){ if($page==$i){ $str.="[".$i."] "; }else{ $str.="".$i." "; } } echo $str;}else{ die();}?>3、test資料庫 test表 SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for test-- ----------------------------DROP TABLE IF EXISTS `test`;CREATE TABLE `test` ( `id` int(10) NOT NULL auto_increment, `uname` char(50) character set utf8 NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin;-- ------------------------------ Records-- ----------------------------INSERT INTO `test` VALUES ('1', 'aaaaaaaaaaa');INSERT INTO `test` VALUES ('2', 'bbbbbbbbbbbb');INSERT INTO `test` VALUES ('3', 'cccccccccccc');INSERT INTO `test` VALUES ('4', 'dddddddddddddddd');INSERT INTO `test` VALUES ('5', 'eeeeeeeeeee');INSERT INTO `test` VALUES ('6', 'ffffffffff');INSERT INTO `test` VALUES ('7', 'ggggggggggggggg');INSERT INTO `test` VALUES ('8', 'hhhhhhhhhhhh');INSERT INTO `test` VALUES ('9', 'jjjjjjjjjjjjjjjj');INSERT INTO `test` VALUES ('10', 'kkkkkkkkkkk');INSERT INTO `test` VALUES ('11', 'mmmmmmmmmmm');INSERT INTO `test` VALUES ('12', 'cccccccccccccccccc');INSERT INTO `test` VALUES ('13', 'bbbbbbbbbbbb');INSERT INTO `test` VALUES ('14', 'ooooooooooooooooo');INSERT INTO `test` VALUES ('15', 'pppppppppppp');INSERT INTO `test` VALUES ('16', 'aaaaaaaaaaaaaaa');INSERT INTO `test` VALUES ('17', 'ggggggggggggggggg');INSERT INTO `test` VALUES ('18', 'dddddddddddddddd');INSERT INTO `test` VALUES ('19', 'cccccccccccccc');INSERT INTO `test` VALUES ('20', 'xxxxxxxxxx');INSERT INTO `test` VALUES ('21', 'zzzzzzzzzzzzzzz');INSERT INTO `test` VALUES ('22', 'oooooooooooooooooooo');INSERT INTO `test` VALUES ('23', 'iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii');INSERT INTO `test` VALUES ('24', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuu');INSERT INTO `test` VALUES ('25', 'yyyyyyyyyyyyyyyyyy');INSERT INTO `test` VALUES ('26', 'ttttttttttttttttttttttttttt');INSERT INTO `test` VALUES ('27', 'rrrrrrrrrrrrrrrrrrrrrrrr');INSERT INTO `test` VALUES ('28', 'eeeeeeeeeeeeeeeeeeeee');INSERT INTO `test` VALUES ('29', 'wwwwwwwwwwwwwwwwwwwww');INSERT INTO `test` VALUES ('30', 'qqqqqqqqqqqqq'); |