首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >ul il列表结构javaScript

问ul il列表结构javaScript
EN

Stack Overflow用户
提问于 2012-10-17 20:33:12
回答 2查看 184关注 0票数 0

我有以下结构:国家、省、市和郊区。我如何在列表中添加下面这样的结构。我将从数据库中拉出的数据在json格式,按照下面的表格。我想存储它,并将其保存到一个类似于bellow的列表中。

代码语言:javascript
复制
<li>South Africa</li>
<ul>
<li><h3>Gauteng</h3><p>Gauteng Province.</p>
<ul>
    <li>Ekhurhuleni                         
  <ul>                          
    <li class="liid"><a href="#">Actionville</a></li>   
    <li class="liid"><a href="#">Alberton</a></li>
    <li class="liid"><a href="#">Bakerton</a></li>
    <li class="liid"><a href="#">Bedfordview</a></li>
</ul>                   
</li>
</ul>

我将不得不将结构添加回数据库,因此我还需要保留密钥。

下面是我的DB表:

代码语言:javascript
复制
Table Country
CountryID   Country
1           South Africa
2           Egypt


Table Province
ProvinceID    Provincename  CountryID
1             Gauteng       1
2             Eastern Cape  1
3             Free State    1

Table City
CityID        CityName       ProvinceID
1             Ekurhuleni     1


Table Suburb
SuburbID      SuburbName     CityID
1             Actonville     1
2             Germiston      1
EN

回答 2

Stack Overflow用户

发布于 2012-10-17 20:44:05

PHP:

代码语言:javascript
复制
$countries = array();
$q = "SELECT * FROM Country";
$res = mysql_query($q);
while($row=mysql_fetch_assoc($res)){
    $countryId = $row['CountryID'];
    $countries[$countryId] = array("data"=>$row,"provinces"=>array());
    $provinces = &$countries[$countryId]["provinces"];
    $qP = "SELECT * FROM Province P WHERE P.CountryID = $countryId";
    $resP = mysql_query($qP);
    while($rowP = mysql_fetch_assoc($resP)){
        $provinceId = $rowP['ProvinceID'];
        $provinces[$provinceId] = array("data"=>$rowP,'cities'=>array());
        $cities = &$provinces[$provinceId];
        $qC = "SELECT * FROM City C WHERE C.ProvinceID = $provinceId";
        $resC = mysql_query($qC);
        while($rowC = mysql_fetch_assoc($resC)){
            $cityId = $rowC['CityID'];
            $cities[$cityId] = array("data"=>$rowC,'suburbs'=>array());
            // AND SO ON FOR SUBURBS
        }
    }
}

$output="<ul>";
foreach($countries as $countryId=>$countryArray){
    $output.="<li id='$countryId'>";
    $output.="<h1>".$countryArray['data']['countryName']."</h1>";
        $output.="<ul>";
        foreach($countryArray['provinces'] as $provinceId=>$provinceArray){
            $output.="<li id='$provinceId'>";
            $output.="<h2>".$provinceArray['data']['provinceName']."</h2>";
            $output.="</li>";
        }
        $output.="</ul>";
    $output.="</li>";
}
票数 0
EN

Stack Overflow用户

发布于 2012-10-17 21:34:53

代码语言:javascript
复制
var Countries = [{...}, {...}, ...];
var Provinces = [{...}, {...}, ...];
var Cities    = [{...}, {...}, ...];
var Suburbies = [{...}, {...}, ...];

var countriesUl = document.createElement('ul');
for (var i in Countries) {
    var countryLi = document.createElement('li').appendTo(countriesUl);
    document.createTextNode(Countries[i].Country).appendTo(countryLi);
    var provincesUl = document.createElement('ul').appendTo(countryLi);
    for (var j in Provinces) {
        if (Provinces[j].CountryID != Countries[i].CountryID) continue;
        var provinceLi = document.createElement('li').appendTo(provincesUl);
        document.createTextNode('<h3>' + Provinces[j].Provincename + '</h3>').appendTo(provinceLi);
        document.createTextNode('<p>' + Provinces[j].Provincename + ' province</p>').appendTo(provinceLi);
        var citiesUl = document.createElement('ul').appendTo(provinceLi);
        for (var k in Cities) {
            if (Cities[k].ProvinceID != Provinces[j].ProvinceID) continue;
            var cityLi = document.createElement('li').appendTo(citiesUl);
            document.createTextNode(Cities[k].CityName).appendTo(cityLi);
            var suburbiesUl = document.createElement('ul').appendTo(cityLi);
            for (var l in Suburbies) {
                if (Suburbies[l].CityID != Cities[k].CityID) continue;
                var suburbLi = document.createElement('li').appendTo(suburbiesUl);
                document.createTextNode(Suburbies[l].SuburbName).appendTo(suburbLi);
            }
        }
    }
}

// do whatever you want with countriesUl
countriesUl.appendTo(document.body);
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/12934430

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档