php 分页用的代码

 1 /*
 2 Navic at MySQL Data Transfer
 3 Order by              : happig
 4 Source Server         : localhost
 5 Source Server Version : 50516
 6 Source Host           : localhost:3306
 7 Source Database       : test
 8  
 9 Target Server Type    : MYSQL
10 Target Server Version : 50516
11 File Encoding         : 65001
12  
13 Date: 2012-08-25 02:21:44
14 */
15 USE `pagelist`;
16  
17 SET FOREIGN_KEY_CHECKS=0;
18 -- ----------------------------
19 -- Table structure for `v_char`
20 -- ----------------------------
21 DROP TABLE IF EXISTS `v_char`;
22 CREATE TABLE `v_char` (
23   `type_id` int(11) NOT NULL DEFAULT '0',
24   `type_name` varchar(255) DEFAULT NULL,
25   `type_parent_id` int(11) DEFAULT NULL,
26   `project` varchar(255) DEFAULT NULL,
27   PRIMARY KEY (`type_id`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29  
30 -- ----------------------------
31 -- Records of v_char
32 -- ----------------------------
33 INSERT INTO `v_char` VALUES ('1', '工装功能', null, 'gong');
34 INSERT INTO `v_char` VALUES ('2', '工装类型', null, 'gong');
35 INSERT INTO `v_char` VALUES ('3', '家装功能', null, 'jia');
36 INSERT INTO `v_char` VALUES ('4', '家装风格', null, 'jia');
37 INSERT INTO `v_char` VALUES ('5', '家装构件', null, 'jia');
38 INSERT INTO `v_char` VALUES ('6', '家装户型', null, 'jia');
39 INSERT INTO `v_char` VALUES ('10', '办公空间', '2', 'gong');
40 INSERT INTO `v_char` VALUES ('13', '中式', '4', 'jia');
41 INSERT INTO `v_char` VALUES ('14', '欧式', '4', 'jia');
42 INSERT INTO `v_char` VALUES ('16', '医院', '1', 'gong');
43 INSERT INTO `v_char` VALUES ('17', '办公室', '1', 'gong');
44 INSERT INTO `v_char` VALUES ('18', '网吧', '1', 'gong');
45 INSERT INTO `v_char` VALUES ('19', '超市', '1', 'gong');
46 INSERT INTO `v_char` VALUES ('20', '售楼部', '1', 'gong');
47 INSERT INTO `v_char` VALUES ('21', '餐厅', '1', 'gong');
48 INSERT INTO `v_char` VALUES ('22', '酒店', '1', 'gong');