PHP分页小代码
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>PHP make page list</title>
<style type="text/css">
<!--
.page a:link {
color: #0000FF;
text-decoration: none;
}
.page a:visited {
text-decoration: none;
color: #0000FF;
}
.page a:hover {
text-decoration: none;
color: #0000FF;
}
.page a:active {
text-decoration: none;
color: #0000FF;
}
.page{color:#0000FF;}
-->
</style>
</head>
<body>
<table width="530" height="103" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<th width="30" height="38" bgcolor="#E3E3E3" scope="col">ID</th>
<th width="500" bgcolor="#E3E3E3" scope="col">文章标题</th>
</tr>
<?php
/*
* Created on 2010-4-17
*
* Order by Kove Wong
*/
$link=mysql_connect('localhost','root','haoxiazai1987');
mysql_select_db('pagelist');
mysql_query('set names gbk');
$Page_size=10;
$result=mysql_query('select * from v_char');
$count = mysql_num_rows($result);
$page_count = ceil($count/$Page_size);
$init=1;
$page_len=7;
$max_p=$page_count;
$pages=$page_count;
//判断当前页码
if(empty($_GET['page'])||$_GET['page']<0){
$page=1;
}else {
$page=$_GET['page'];
}
$offset=$Page_size*($page-1);
$sql="select * from v_char limit $offset,$Page_size";
$result=mysql_query($sql,$link);
while ($row=mysql_fetch_array($result)) {
?>
<tr>
<td bgcolor="#E0EEE0" height="25px"><div align="center">
<?php echo $row['id']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['name']?>
</div></td>
</tr>
<?php
}
$page_len = ($page_len%2)?$page_len:$pagelen+1;//页码个数
$pageoffset = ($page_len-1)/2;//页码个数左右偏移量
$key='<div class="page">';
$key.="<span>$page/$pages</span> "; //第几页,共几页
if($page!=1){
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=1\">第一页</a> "; //第一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页</a>"; //上一页
}else {
$key.="第一页 ";//第一页
$key.="上一页"; //上一页
}
if($pages>$page_len){
//如果当前页小于等于左偏移
if($page<=$pageoffset){
$init=1;
$max_p = $page_len;
}else{//如果当前页大于左偏移
//如果当前页码右偏移超出最大分页数
if($page+$pageoffset>=$pages+1){
$init = $pages-$page_len+1;
}else{
//左右偏移都存在时的计算
$init = $page-$pageoffset;
$max_p = $page+$pageoffset;
}
}
}
for($i=$init;$i<=$max_p;$i++){
if($i==$page){
$key.=' <span>'.$i.'</span>';
} else {
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>";
}
}
if($page!=$pages){
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a> ";//下一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">最后一页</a>"; //最后一页
}else {
$key.="下一页 ";//下一页
$key.="最后一页"; //最后一页
}
$key.='</div>';
?>
<tr>
<td colspan="2" bgcolor="#E0EEE0"><div align="center"><?php echo $key?></div></td>
</tr>
</table>
</body>
</html>
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50051
Source Host : localhost:3306
Source Database : pagelist
Target Server Type : MYSQL
Target Server Version : 50051
File Encoding : 65001
Date: 2010-07-18 11:17:08
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `v_char`
-- ----------------------------
DROP TABLE IF EXISTS `v_char`;
CREATE TABLE `v_char` (
`id` int(10) NOT NULL auto_increment,
`name` char(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of v_char
-- ----------------------------
INSERT INTO `v_char` VALUES ('1', '尤文闪耀之人竟是AC米兰弃将');
INSERT INTO `v_char` VALUES ('2', '斯内德意大利举行婚');
INSERT INTO `v_char` VALUES ('3', '李铁证实伯明翰邀请非炒作');
INSERT INTO `v_char` VALUES ('4', '这是标题4');
INSERT INTO `v_char` VALUES ('5', '这是标题5');
INSERT INTO `v_char` VALUES ('6', '这是标题6');
INSERT INTO `v_char` VALUES ('7', '这是标题7');
INSERT INTO `v_char` VALUES ('8', '这是标题8');
INSERT INTO `v_char` VALUES ('9', '这是标题9');
INSERT INTO `v_char` VALUES ('10', '这是标题10');
INSERT INTO `v_char` VALUES ('11', '这是标题11');
INSERT INTO `v_char` VALUES ('12', '这是标题12');
INSERT INTO `v_char` VALUES ('13', '这是标题13');
INSERT INTO `v_char` VALUES ('14', '这是标题14');
INSERT INTO `v_char` VALUES ('15', '这是标题15');
INSERT INTO `v_char` VALUES ('16', '这是标题16');
INSERT INTO `v_char` VALUES ('17', '这是标题17');
INSERT INTO `v_char` VALUES ('18', '这是标题18');
INSERT INTO `v_char` VALUES ('19', '这是标题19');
INSERT INTO `v_char` VALUES ('20', '这是标题20');
INSERT INTO `v_char` VALUES ('21', '这是标题21');
INSERT INTO `v_char` VALUES ('22', '这是标题22');
INSERT INTO `v_char` VALUES ('23', '这是标题23');
INSERT INTO `v_char` VALUES ('24', '这是标题24');
INSERT INTO `v_char` VALUES ('25', '这是标题25');
INSERT INTO `v_char` VALUES ('26', '这是标题26');
INSERT INTO `v_char` VALUES ('27', '这是标题27');
INSERT INTO `v_char` VALUES ('28', '这是标题28');
INSERT INTO `v_char` VALUES ('29', '这是标题29');
INSERT INTO `v_char` VALUES ('30', '这是标题30');
INSERT INTO `v_char` VALUES ('31', '这是标题31');
INSERT INTO `v_char` VALUES ('32', '这是标题32');
INSERT INTO `v_char` VALUES ('33', '这是标题33');
INSERT INTO `v_char` VALUES ('34', '这是标题34');
INSERT INTO `v_char` VALUES ('35', '这是标题35');
INSERT INTO `v_char` VALUES ('36', '这是标题36');
INSERT INTO `v_char` VALUES ('37', '这是标题37');
INSERT INTO `v_char` VALUES ('38', '这是标题38');
INSERT INTO `v_char` VALUES ('39', '这是标题39');
INSERT INTO `v_char` VALUES ('40', '这是标题40');
INSERT INTO `v_char` VALUES ('41', '这是标题41');
INSERT INTO `v_char` VALUES ('42', '这是标题42');
INSERT INTO `v_char` VALUES ('43', '这是标题43');
INSERT INTO `v_char` VALUES ('44', '这是标题44');
INSERT INTO `v_char` VALUES ('45', '这是标题45');
INSERT INTO `v_char` VALUES ('46', '这是标题46');
INSERT INTO `v_char` VALUES ('47', '这是标题47');
INSERT INTO `v_char` VALUES ('48', '这是标题48');
INSERT INTO `v_char` VALUES ('49', '这是标题49');
INSERT INTO `v_char` VALUES ('50', '这是标题50');
INSERT INTO `v_char` VALUES ('51', '这是标题51');
INSERT INTO `v_char` VALUES ('52', '这是标题52');
INSERT INTO `v_char` VALUES ('53', '这是标题53');
INSERT INTO `v_char` VALUES ('54', '这是标题54');
INSERT INTO `v_char` VALUES ('55', '这是标题55');
INSERT INTO `v_char` VALUES ('56', '这是标题56');
INSERT INTO `v_char` VALUES ('57', '这是标题57');
INSERT INTO `v_char` VALUES ('58', '这是标题58');
INSERT INTO `v_char` VALUES ('59', '这是标题59');
INSERT INTO `v_char` VALUES ('60', '这是标题60');
INSERT INTO `v_char` VALUES ('61', '这是标题61');
INSERT INTO `v_char` VALUES ('62', '这是标题62');
INSERT INTO `v_char` VALUES ('63', '这是标题63');
INSERT INTO `v_char` VALUES ('64', '这是标题64');
INSERT INTO `v_char` VALUES ('65', '这是标题65');
INSERT INTO `v_char` VALUES ('66', '这是标题66');
INSERT INTO `v_char` VALUES ('67', '这是标题67');
INSERT INTO `v_char` VALUES ('68', '这是标题68');
INSERT INTO `v_char` VALUES ('69', '这是标题69');
INSERT INTO `v_char` VALUES ('70', '这是标题70');
INSERT INTO `v_char` VALUES ('71', '这是标题71');
INSERT INTO `v_char` VALUES ('72', '这是标题72');
INSERT INTO `v_char` VALUES ('73', '这是标题73');
INSERT INTO `v_char` VALUES ('74', '这是标题74');
INSERT INTO `v_char` VALUES ('75', '这是标题75');
INSERT INTO `v_char` VALUES ('76', '这是标题76');
INSERT INTO `v_char` VALUES ('77', '这是标题77');
INSERT INTO `v_char` VALUES ('78', '这是标题78');
INSERT INTO `v_char` VALUES ('79', '这是标题79');
INSERT INTO `v_char` VALUES ('80', '这是标题80');
INSERT INTO `v_char` VALUES ('81', '这是标题81');
INSERT INTO `v_char` VALUES ('82', '这是标题82');
INSERT INTO `v_char` VALUES ('83', '这是标题83');
INSERT INTO `v_char` VALUES ('84', '这是标题84');
INSERT INTO `v_char` VALUES ('85', '这是标题85');
INSERT INTO `v_char` VALUES ('86', '这是标题86');
INSERT INTO `v_char` VALUES ('87', '这是标题87');
INSERT INTO `v_char` VALUES ('88', '这是标题88');
INSERT INTO `v_char` VALUES ('89', '这是标题89');
INSERT INTO `v_char` VALUES ('90', '这是标题90');
INSERT INTO `v_char` VALUES ('91', '这是标题91');
INSERT INTO `v_char` VALUES ('92', '这是标题92');
INSERT INTO `v_char` VALUES ('93', '这是标题93');
INSERT INTO `v_char` VALUES ('94', '这是标题94');
INSERT INTO `v_char` VALUES ('95', '这是标题95');
INSERT INTO `v_char` VALUES ('96', '这是标题96');
INSERT INTO `v_char` VALUES ('97', '这是标题97');
INSERT INTO `v_char` VALUES ('98', '这是标题98');
INSERT INTO `v_char` VALUES ('99', '这是标题99');
INSERT INTO `v_char` VALUES ('100', '这是标题100');
INSERT INTO `v_char` VALUES ('101', '这是标题101');
INSERT INTO `v_char` VALUES ('102', '这是标题102');
INSERT INTO `v_char` VALUES ('103', '这是标题103');
INSERT INTO `v_char` VALUES ('104', '这是标题104');
INSERT INTO `v_char` VALUES ('105', '这是标题105');
INSERT INTO `v_char` VALUES ('106', '这是标题106');
INSERT INTO `v_char` VALUES ('107', '这是标题107');
INSERT INTO `v_char` VALUES ('108', '这是标题108');
INSERT INTO `v_char` VALUES ('109', '这是标题109');
INSERT INTO `v_char` VALUES ('110', '这是标题110');
INSERT INTO `v_char` VALUES ('111', '这是标题111');
INSERT INTO `v_char` VALUES ('112', '这是标题112');
INSERT INTO `v_char` VALUES ('113', '这是标题113');
INSERT INTO `v_char` VALUES ('114', '这是标题114');
INSERT INTO `v_char` VALUES ('115', '这是标题115');
INSERT INTO `v_char` VALUES ('116', '这是标题116');
INSERT INTO `v_char` VALUES ('117', '这是标题117');
INSERT INTO `v_char` VALUES ('118', '这是标题118');
INSERT INTO `v_char` VALUES ('119', '这是标题119');
INSERT INTO `v_char` VALUES ('120', '这是标题120');
INSERT INTO `v_char` VALUES ('121', '这是标题121');
INSERT INTO `v_char` VALUES ('122', '这是标题122');
INSERT INTO `v_char` VALUES ('123', '这是标题123');
INSERT INTO `v_char` VALUES ('124', '这是标题124');
INSERT INTO `v_char` VALUES ('125', '这是标题125');
INSERT INTO `v_char` VALUES ('126', '这是标题126');
INSERT INTO `v_char` VALUES ('127', '这是标题127');
INSERT INTO `v_char` VALUES ('128', '这是标题128');
INSERT INTO `v_char` VALUES ('129', '这是标题129');
INSERT INTO `v_char` VALUES ('130', '这是标题130');
INSERT INTO `v_char` VALUES ('131', '这是标题131');
INSERT INTO `v_char` VALUES ('132', '这是标题132');
INSERT INTO `v_char` VALUES ('133', '这是标题133');
INSERT INTO `v_char` VALUES ('134', '这是标题134');
INSERT INTO `v_char` VALUES ('135', '这是标题135');
INSERT INTO `v_char` VALUES ('136', '这是标题136');
INSERT INTO `v_char` VALUES ('137', '这是标题137');
INSERT INTO `v_char` VALUES ('138', '这是标题138');
INSERT INTO `v_char` VALUES ('139', '这是标题139');
INSERT INTO `v_char` VALUES ('140', '这是标题140');
INSERT INTO `v_char` VALUES ('141', '这是标题141');
INSERT INTO `v_char` VALUES ('142', '这是标题142');
INSERT INTO `v_char` VALUES ('143', '这是标题143');
INSERT INTO `v_char` VALUES ('144', '这是标题144');
INSERT INTO `v_char` VALUES ('145', '这是标题145');
INSERT INTO `v_char` VALUES ('146', '这是标题146');
INSERT INTO `v_char` VALUES ('147', '这是标题147');
INSERT INTO `v_char` VALUES ('148', '这是标题148');
INSERT INTO `v_char` VALUES ('149', '这是标题149');
INSERT INTO `v_char` VALUES ('150', '这是标题150');
INSERT INTO `v_char` VALUES ('151', '这是标题151');
INSERT INTO `v_char` VALUES ('152', '这是标题152');
INSERT INTO `v_char` VALUES ('153', '这是标题153');
INSERT INTO `v_char` VALUES ('154', '这是标题154');
INSERT INTO `v_char` VALUES ('155', '这是标题155');
INSERT INTO `v_char` VALUES ('156', '这是标题156');
INSERT INTO `v_char` VALUES ('157', '这是标题157');
INSERT INTO `v_char` VALUES ('158', '这是标题158');
INSERT INTO `v_char` VALUES ('159', '这是标题159');
INSERT INTO `v_char` VALUES ('160', '这是标题160');
INSERT INTO `v_char` VALUES ('161', '这是标题161');
INSERT INTO `v_char` VALUES ('162', '这是标题162');
INSERT INTO `v_char` VALUES ('163', '这是标题163');
INSERT INTO `v_char` VALUES ('164', '这是标题164');
INSERT INTO `v_char` VALUES ('165', '这是标题165');
INSERT INTO `v_char` VALUES ('166', '这是标题166');
INSERT INTO `v_char` VALUES ('167', '这是标题167');
INSERT INTO `v_char` VALUES ('168', '这是标题168');
INSERT INTO `v_char` VALUES ('169', '这是标题169');
INSERT INTO `v_char` VALUES ('170', '这是标题170');
INSERT INTO `v_char` VALUES ('171', '这是标题171');
INSERT INTO `v_char` VALUES ('172', '这是标题172');
INSERT INTO `v_char` VALUES ('173', '这是标题173');
INSERT INTO `v_char` VALUES ('174', '这是标题174');
INSERT INTO `v_char` VALUES ('175', '这是标题175');
INSERT INTO `v_char` VALUES ('176', '这是标题176');
INSERT INTO `v_char` VALUES ('177', '这是标题177');
INSERT INTO `v_char` VALUES ('178', '这是标题178');
INSERT INTO `v_char` VALUES ('179', '这是标题179');
INSERT INTO `v_char` VALUES ('180', '这是标题180');
INSERT INTO `v_char` VALUES ('181', '这是标题181');
INSERT INTO `v_char` VALUES ('182', '这是标题182');
INSERT INTO `v_char` VALUES ('183', '这是标题183');
INSERT INTO `v_char` VALUES ('184', '这是标题184');
INSERT INTO `v_char` VALUES ('185', '这是标题185');
INSERT INTO `v_char` VALUES ('186', '这是标题186');
INSERT INTO `v_char` VALUES ('187', '这是标题187');
INSERT INTO `v_char` VALUES ('188', '这是标题188');
INSERT INTO `v_char` VALUES ('189', '这是标题189');
INSERT INTO `v_char` VALUES ('190', '这是标题190');
INSERT INTO `v_char` VALUES ('191', '这是标题191');
INSERT INTO `v_char` VALUES ('192', '这是标题192');
INSERT INTO `v_char` VALUES ('193', '这是标题193');
INSERT INTO `v_char` VALUES ('194', '这是标题194');
INSERT INTO `v_char` VALUES ('195', '这是标题195');
INSERT INTO `v_char` VALUES ('196', '这是标题196');
INSERT INTO `v_char` VALUES ('197', '这是标题197');
INSERT INTO `v_char` VALUES ('198', '这是标题198');
INSERT INTO `v_char` VALUES ('199', '这是标题199');
INSERT INTO `v_char` VALUES ('200', '这是标题200');
INSERT INTO `v_char` VALUES ('201', '这是标题201');
INSERT INTO `v_char` VALUES ('202', '这是标题202');
INSERT INTO `v_char` VALUES ('203', '这是标题203');
INSERT INTO `v_char` VALUES ('204', '这是标题204');
INSERT INTO `v_char` VALUES ('205', '这是标题205');
INSERT INTO `v_char` VALUES ('206', '这是标题206');
INSERT INTO `v_char` VALUES ('207', '这是标题207');
INSERT INTO `v_char` VALUES ('208', '这是标题208');
INSERT INTO `v_char` VALUES ('209', '这是标题209');
INSERT INTO `v_char` VALUES ('210', '这是标题210');
INSERT INTO `v_char` VALUES ('211', '这是标题211');
INSERT INTO `v_char` VALUES ('212', '这是标题212');
INSERT INTO `v_char` VALUES ('213', '这是标题213');
INSERT INTO `v_char` VALUES ('214', '这是标题214');
INSERT INTO `v_char` VALUES ('215', '这是标题215');
INSERT INTO `v_char` VALUES ('216', '这是标题216');
INSERT INTO `v_char` VALUES ('217', '这是标题217');
INSERT INTO `v_char` VALUES ('218', '这是标题218');
INSERT INTO `v_char` VALUES ('219', '这是标题219');
INSERT INTO `v_char` VALUES ('220', '这是标题220');
INSERT INTO `v_char` VALUES ('221', '这是标题221');
INSERT INTO `v_char` VALUES ('222', '这是标题222');
INSERT INTO `v_char` VALUES ('223', '这是标题223');
INSERT INTO `v_char` VALUES ('224', '这是标题224');
INSERT INTO `v_char` VALUES ('225', '这是标题225');
INSERT INTO `v_char` VALUES ('226', '这是标题226');
INSERT INTO `v_char` VALUES ('227', '这是标题227');
INSERT INTO `v_char` VALUES ('228', '这是标题228');
INSERT INTO `v_char` VALUES ('229', '这是标题229');
INSERT INTO `v_char` VALUES ('230', '这是标题230');
INSERT INTO `v_char` VALUES ('231', '这是标题231');
INSERT INTO `v_char` VALUES ('232', '这是标题232');
INSERT INTO `v_char` VALUES ('233', '这是标题233');
INSERT INTO `v_char` VALUES ('234', '这是标题234');
INSERT INTO `v_char` VALUES ('235', '这是标题235');
INSERT INTO `v_char` VALUES ('236', '这是标题236');
INSERT INTO `v_char` VALUES ('237', '这是标题237');
INSERT INTO `v_char` VALUES ('238', '这是标题238');
INSERT INTO `v_char` VALUES ('239', '这是标题239');
INSERT INTO `v_char` VALUES ('240', '这是标题240');
INSERT INTO `v_char` VALUES ('241', '这是标题241');
INSERT INTO `v_char` VALUES ('242', '这是标题242');
INSERT INTO `v_char` VALUES ('243', '这是标题243');
INSERT INTO `v_char` VALUES ('244', '这是标题244');
INSERT INTO `v_char` VALUES ('245', '这是标题245');
INSERT INTO `v_char` VALUES ('246', '这是标题246');
INSERT INTO `v_char` VALUES ('247', '这是标题247');
INSERT INTO `v_char` VALUES ('248', '这是标题248');
INSERT INTO `v_char` VALUES ('249', '这是标题249');
INSERT INTO `v_char` VALUES ('250', '这是标题250');
INSERT INTO `v_char` VALUES ('251', '这是标题251');
INSERT INTO `v_char` VALUES ('252', '这是标题252');
INSERT INTO `v_char` VALUES ('253', '这是标题253');
INSERT INTO `v_char` VALUES ('254', '这是标题254');
INSERT INTO `v_char` VALUES ('255', '这是标题255');
INSERT INTO `v_char` VALUES ('256', '这是标题256');
INSERT INTO `v_char` VALUES ('257', '这是标题257');
INSERT INTO `v_char` VALUES ('258', '这是标题258');
INSERT INTO `v_char` VALUES ('259', '这是标题259');
INSERT INTO `v_char` VALUES ('260', '这是标题260');
INSERT INTO `v_char` VALUES ('261', '这是标题261');
INSERT INTO `v_char` VALUES ('262', '这是标题262');
INSERT INTO `v_char` VALUES ('263', '这是标题263');
INSERT INTO `v_char` VALUES ('264', '这是标题264');
INSERT INTO `v_char` VALUES ('265', '这是标题265');
INSERT INTO `v_char` VALUES ('266', '这是标题266');
INSERT INTO `v_char` VALUES ('267', '这是标题267');
INSERT INTO `v_char` VALUES ('268', '这是标题268');
INSERT INTO `v_char` VALUES ('269', '这是标题269');
INSERT INTO `v_char` VALUES ('270', '这是标题270');
INSERT INTO `v_char` VALUES ('271', '这是标题271');
INSERT INTO `v_char` VALUES ('272', '这是标题272');
INSERT INTO `v_char` VALUES ('273', '这是标题273');
INSERT INTO `v_char` VALUES ('274', '这是标题274');
INSERT INTO `v_char` VALUES ('275', '这是标题275');
INSERT INTO `v_char` VALUES ('276', '这是标题276');
INSERT INTO `v_char` VALUES ('277', '这是标题277');
INSERT INTO `v_char` VALUES ('278', '这是标题278');
INSERT INTO `v_char` VALUES ('279', '这是标题279');
INSERT INTO `v_char` VALUES ('280', '这是标题280');
INSERT INTO `v_char` VALUES ('281', '这是标题281');
INSERT INTO `v_char` VALUES ('282', '这是标题282');
INSERT INTO `v_char` VALUES ('283', '这是标题283');
INSERT INTO `v_char` VALUES ('284', '这是标题284');
INSERT INTO `v_char` VALUES ('285', '这是标题285');
INSERT INTO `v_char` VALUES ('286', '这是标题286');
INSERT INTO `v_char` VALUES ('287', '这是标题287');
INSERT INTO `v_char` VALUES ('288', '这是标题288');
INSERT INTO `v_char` VALUES ('289', '这是标题289');
INSERT INTO `v_char` VALUES ('290', '这是标题290');
INSERT INTO `v_char` VALUES ('291', '这是标题291');
INSERT INTO `v_char` VALUES ('292', '这是标题292');
INSERT INTO `v_char` VALUES ('293', '这是标题293');
INSERT INTO `v_char` VALUES ('294', '这是标题294');
INSERT INTO `v_char` VALUES ('295', '这是标题295');
INSERT INTO `v_char` VALUES ('296', '这是标题296');
INSERT INTO `v_char` VALUES ('297', '这是标题297');
INSERT INTO `v_char` VALUES ('298', '这是标题298');
INSERT INTO `v_char` VALUES ('299', '这是标题299');
INSERT INTO `v_char` VALUES ('300', '这是标题300');
INSERT INTO `v_char` VALUES ('301', '这是标题301');
INSERT INTO `v_char` VALUES ('302', '这是标题302');
INSERT INTO `v_char` VALUES ('303', '这是标题303');
INSERT INTO `v_char` VALUES ('304', '这是标题304');
INSERT INTO `v_char` VALUES ('305', '这是标题305');
INSERT INTO `v_char` VALUES ('306', '这是标题306');
INSERT INTO `v_char` VALUES ('307', '这是标题307');
INSERT INTO `v_char` VALUES ('308', '这是标题308');
INSERT INTO `v_char` VALUES ('309', '这是标题309');
INSERT INTO `v_char` VALUES ('310', '这是标题310');
INSERT INTO `v_char` VALUES ('311', '这是标题311');
INSERT INTO `v_char` VALUES ('312', '这是标题312');
INSERT INTO `v_char` VALUES ('313', '这是标题313');
INSERT INTO `v_char` VALUES ('314', '这是标题314');
INSERT INTO `v_char` VALUES ('315', '这是标题315');
INSERT INTO `v_char` VALUES ('316', '这是标题316');
INSERT INTO `v_char` VALUES ('317', '这是标题317');
INSERT INTO `v_char` VALUES ('318', '这是标题318');
INSERT INTO `v_char` VALUES ('319', '这是标题319');
INSERT INTO `v_char` VALUES ('320', '这是标题320');
INSERT INTO `v_char` VALUES ('321', '这是标题321');
INSERT INTO `v_char` VALUES ('322', '这是标题322');
INSERT INTO `v_char` VALUES ('323', '这是标题323');
INSERT INTO `v_char` VALUES ('324', '这是标题324');
INSERT INTO `v_char` VALUES ('325', '这是标题325');
INSERT INTO `v_char` VALUES ('326', '这是标题326');
INSERT INTO `v_char` VALUES ('327', '这是标题327');
INSERT INTO `v_char` VALUES ('328', '这是标题328');
INSERT INTO `v_char` VALUES ('329', '这是标题329');
INSERT INTO `v_char` VALUES ('330', '这是标题330');
INSERT INTO `v_char` VALUES ('331', '这是标题331');
INSERT INTO `v_char` VALUES ('332', '这是标题332');
INSERT INTO `v_char` VALUES ('333', '这是标题333');
INSERT INTO `v_char` VALUES ('334', '这是标题334');
INSERT INTO `v_char` VALUES ('335', '这是标题335');
INSERT INTO `v_char` VALUES ('336', '这是标题336');
INSERT INTO `v_char` VALUES ('337', '这是标题337');
INSERT INTO `v_char` VALUES ('338', '这是标题338');
INSERT INTO `v_char` VALUES ('339', '这是标题339');
INSERT INTO `v_char` VALUES ('340', '这是标题340');
INSERT INTO `v_char` VALUES ('341', '这是标题341');
INSERT INTO `v_char` VALUES ('342', '这是标题342');
INSERT INTO `v_char` VALUES ('343', '这是标题343');
INSERT INTO `v_char` VALUES ('344', '这是标题344');
INSERT INTO `v_char` VALUES ('345', '这是标题345');
INSERT INTO `v_char` VALUES ('346', '这是标题346');
INSERT INTO `v_char` VALUES ('347', '这是标题347');
INSERT INTO `v_char` VALUES ('348', '这是标题348');
INSERT INTO `v_char` VALUES ('349', '这是标题349');
INSERT INTO `v_char` VALUES ('350', '这是标题350');
INSERT INTO `v_char` VALUES ('351', '这是标题351');
INSERT INTO `v_char` VALUES ('352', '这是标题352');
INSERT INTO `v_char` VALUES ('353', '这是标题353');
INSERT INTO `v_char` VALUES ('354', '这是标题354');
INSERT INTO `v_char` VALUES ('355', '这是标题355');
INSERT INTO `v_char` VALUES ('356', '这是标题356');
INSERT INTO `v_char` VALUES ('357', '这是标题357');
INSERT INTO `v_char` VALUES ('358', '这是标题358');
INSERT INTO `v_char` VALUES ('359', '这是标题359');
INSERT INTO `v_char` VALUES ('360', '这是标题360');
INSERT INTO `v_char` VALUES ('361', '这是标题361');
INSERT INTO `v_char` VALUES ('362', '这是标题362');
INSERT INTO `v_char` VALUES ('363', '这是标题363');
INSERT INTO `v_char` VALUES ('364', '这是标题364');
INSERT INTO `v_char` VALUES ('365', '这是标题365');
INSERT INTO `v_char` VALUES ('366', '这是标题366');
INSERT INTO `v_char` VALUES ('367', '这是标题367');
INSERT INTO `v_char` VALUES ('368', '这是标题368');
INSERT INTO `v_char` VALUES ('369', '这是标题369');
INSERT INTO `v_char` VALUES ('370', '这是标题370');
INSERT INTO `v_char` VALUES ('371', '这是标题371');
INSERT INTO `v_char` VALUES ('372', '这是标题372');
INSERT INTO `v_char` VALUES ('373', '这是标题373');
INSERT INTO `v_char` VALUES ('374', '这是标题374');
INSERT INTO `v_char` VALUES ('375', '这是标题375');
INSERT INTO `v_char` VALUES ('376', '这是标题376');
INSERT INTO `v_char` VALUES ('377', '这是标题377');
INSERT INTO `v_char` VALUES ('378', '这是标题378');
INSERT INTO `v_char` VALUES ('379', '这是标题379');
INSERT INTO `v_char` VALUES ('380', '这是标题380');
INSERT INTO `v_char` VALUES ('381', '这是标题381');
INSERT INTO `v_char` VALUES ('382', '这是标题382');
INSERT INTO `v_char` VALUES ('383', '这是标题383');
INSERT INTO `v_char` VALUES ('384', '这是标题384');
INSERT INTO `v_char` VALUES ('385', '这是标题385');
INSERT INTO `v_char` VALUES ('386', '这是标题386');
INSERT INTO `v_char` VALUES ('387', '这是标题387');
INSERT INTO `v_char` VALUES ('388', '这是标题388');
INSERT INTO `v_char` VALUES ('389', '这是标题389');
INSERT INTO `v_char` VALUES ('390', '这是标题390');
INSERT INTO `v_char` VALUES ('391', '这是标题391');
INSERT INTO `v_char` VALUES ('392', '这是标题392');
INSERT INTO `v_char` VALUES ('393', '这是标题393');
INSERT INTO `v_char` VALUES ('394', '这是标题394');
INSERT INTO `v_char` VALUES ('395', '这是标题395');
INSERT INTO `v_char` VALUES ('396', '这是标题396');
INSERT INTO `v_char` VALUES ('397', '这是标题397');
INSERT INTO `v_char` VALUES ('398', '这是标题398');
INSERT INTO `v_char` VALUES ('399', '这是标题399');
INSERT INTO `v_char` VALUES ('400', '这是标题400');