level 1
a7586177
楼主
总共2张表
leibie 和 neirong



类别表结构:
-- ----------------------------
-- Table structure for leibie
-- ----------------------------
DROP TABLE IF EXISTS `leibie`;
CREATE TABLE `leibie` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leibie
-- ----------------------------
INSERT INTO `leibie` VALUES ('1', '帮助中心');
INSERT INTO `leibie` VALUES ('2', '服务支持');
INSERT INTO `leibie` VALUES ('3', '小米之家');
INSERT INTO `leibie` VALUES ('4', '关于小米');
INSERT INTO `leibie` VALUES ('5', '关注我们');
内容表的结构:
DROP TABLE IF EXISTS `neirong`;
CREATE TABLE `neirong` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`leibieid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of neirong
-- ----------------------------
INSERT INTO `neirong` VALUES ('1', '购物指南', '1');
INSERT INTO `neirong` VALUES ('2', '支付方式', '1');
INSERT INTO `neirong` VALUES ('3', '配送方式', '1');
INSERT INTO `neirong` VALUES ('4', '售后政策', '2');
INSERT INTO `neirong` VALUES ('5', '自助服务', '2');
INSERT INTO `neirong` VALUES ('6', '相关下载', '2');
INSERT INTO `neirong` VALUES ('7', '小米之家', '3');
INSERT INTO `neirong` VALUES ('8', '服务网点', '3');
INSERT INTO `neirong` VALUES ('9', '预约亲临到店服务', '3');
INSERT INTO `neirong` VALUES ('10', '了解小米', '4');
INSERT INTO `neirong` VALUES ('11', '加入小米', '4');
INSERT INTO `neirong` VALUES ('12', '联系我们', '4');
INSERT INTO `neirong` VALUES ('13', '新浪微博', '5');
INSERT INTO `neirong` VALUES ('14', '小米部落', '5');
INSERT INTO `neirong` VALUES ('15', '官方微信', '5');
如何循环读取到下面的html的结构呢 每一个类别对于属于该列表的内容,
<div class="footer-links clearfix">
<dl class="col-links col-links-first">
<dt>帮助中心</dt>
<dd>
<a target="_blank" href="" rel="nofollow">购物指南</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">支付方式</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">配送方式</a>
</dd>
</dl>
<dl class="col-links">
<dt>服务支持</dt>
<dd>
<a target="_blank" href="" rel="nofollow">售后政策</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">自助服务</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">相关下载</a>
</dd>
</dl>
<dl class="col-links">
<dt>小米之家</dt>
<dd>
<a target="_blank" href="" rel="nofollow">小米之家</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">服务网点</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">预约亲临到店服务</a>
</dd>
</dl>
<dl class="col-links">
<dt>关于小米</dt>
<dd>
<a target="_blank" href="" rel="nofollow">了解小米</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">加入小米</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">联系我们</a>
</dd>
</dl>
<dl class="col-links">
<dt>关注我们</dt>
<dd>
<a target="_blank" href="" rel="nofollow">新浪微博</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">小米部落</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">官方微信</a>
</dd>
</dl>
</div>
最终效果图如下:

大神帮忙写一段代码 谢谢啦!新手上路,麻烦写的详细点!
2017年06月16日 09点06分
1
leibie 和 neirong



类别表结构:-- ----------------------------
-- Table structure for leibie
-- ----------------------------
DROP TABLE IF EXISTS `leibie`;
CREATE TABLE `leibie` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leibie
-- ----------------------------
INSERT INTO `leibie` VALUES ('1', '帮助中心');
INSERT INTO `leibie` VALUES ('2', '服务支持');
INSERT INTO `leibie` VALUES ('3', '小米之家');
INSERT INTO `leibie` VALUES ('4', '关于小米');
INSERT INTO `leibie` VALUES ('5', '关注我们');
内容表的结构:
DROP TABLE IF EXISTS `neirong`;
CREATE TABLE `neirong` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`leibieid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of neirong
-- ----------------------------
INSERT INTO `neirong` VALUES ('1', '购物指南', '1');
INSERT INTO `neirong` VALUES ('2', '支付方式', '1');
INSERT INTO `neirong` VALUES ('3', '配送方式', '1');
INSERT INTO `neirong` VALUES ('4', '售后政策', '2');
INSERT INTO `neirong` VALUES ('5', '自助服务', '2');
INSERT INTO `neirong` VALUES ('6', '相关下载', '2');
INSERT INTO `neirong` VALUES ('7', '小米之家', '3');
INSERT INTO `neirong` VALUES ('8', '服务网点', '3');
INSERT INTO `neirong` VALUES ('9', '预约亲临到店服务', '3');
INSERT INTO `neirong` VALUES ('10', '了解小米', '4');
INSERT INTO `neirong` VALUES ('11', '加入小米', '4');
INSERT INTO `neirong` VALUES ('12', '联系我们', '4');
INSERT INTO `neirong` VALUES ('13', '新浪微博', '5');
INSERT INTO `neirong` VALUES ('14', '小米部落', '5');
INSERT INTO `neirong` VALUES ('15', '官方微信', '5');
如何循环读取到下面的html的结构呢 每一个类别对于属于该列表的内容,
<div class="footer-links clearfix">
<dl class="col-links col-links-first">
<dt>帮助中心</dt>
<dd>
<a target="_blank" href="" rel="nofollow">购物指南</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">支付方式</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">配送方式</a>
</dd>
</dl>
<dl class="col-links">
<dt>服务支持</dt>
<dd>
<a target="_blank" href="" rel="nofollow">售后政策</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">自助服务</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">相关下载</a>
</dd>
</dl>
<dl class="col-links">
<dt>小米之家</dt>
<dd>
<a target="_blank" href="" rel="nofollow">小米之家</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">服务网点</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">预约亲临到店服务</a>
</dd>
</dl>
<dl class="col-links">
<dt>关于小米</dt>
<dd>
<a target="_blank" href="" rel="nofollow">了解小米</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">加入小米</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">联系我们</a>
</dd>
</dl>
<dl class="col-links">
<dt>关注我们</dt>
<dd>
<a target="_blank" href="" rel="nofollow">新浪微博</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">小米部落</a>
</dd>
<dd>
<a target="_blank" href="" rel="nofollow">官方微信</a>
</dd>
</dl>
</div>
最终效果图如下:

大神帮忙写一段代码 谢谢啦!新手上路,麻烦写的详细点!