求地域选择问题！！！

Question

如何才能实现http://searchjob.chinahr.com/   中的地域实现，多级，只能选5个

Answer 1

1. 弄省市县地区表(约3500+数据)
2. 弄区域表(这个比较小),更新地区表,使得每个地区归属于一个区域
3. 做前台效果,选择地区,列出下面区域
4. 提交查询就是 select * from xxx where area_id in (选择的地区及其下面地区)

Answer 2

不需要用后台,只需要前台即可
最近我做了几个类似的,可以和你说一说思路
首先数据源是json数据
用jquery读取标准的json数据源,显示即可,至于层的部分那需要使用id关联就好了.
你可以参照我的json结构,这种结构用array的思路来操作,比较容易管理.var Class=[
{"_p":[1,13,"餐廳"],"_l":["1|中餐廳","2|西餐廳","3|日式餐廳","4|港式餐廳","5|韓式餐廳","6|義大利餐廳","7|景觀餐廳","8|觀海餐廳","9|音樂餐廳","10|現場演奏餐廳","11|B.B.Q燒烤餐廳","12|戶外餐廳","13|咖啡廳","14|酒吧","15|烤肉區","16|露營野炊區","17|廚房",]},
{"_p":[1,21,"餐廳設施"],"_l":["25|兒童椅供應","26|兒童餐具供應","27|卡拉ok伴唱機","28|投幣式卡拉ok伴唱機","24|20人座大圓桌","23|18人座大圓桌","22|16人座大圓桌","21|12人大圓桌","20|超大圓桌(11人以上)","19|提供包廂","18|表演舞台",]},
{"_p":[2,17,"新的分類1"],"_l":[""]},
{"_p":[2,18,"新的分類2"],"_l":[""]},
{"_p":[11,0,""],"_l":[""]},
];

Answer 3

地方名怎么多应该要用数据库来读吧。。全班放在html页面中程序会卡死吧

Answer 4

有3000多条数据的,会有点卡我的法子是弄个php查询数据库后,输出需要的静态html,然后html静态的作为一个文件包含.这个行政区划通常是不会变的html,所以不必每次从数据库查

Answer 5

这个一时很难说明白了,我大致说个路线弄个选择区域的,再弄个容器用来装地区
然后给选择区域的绑事件, onchange即去json里读出下面的地区,显示出来找点jquery级联菜单来看明白,你就明白了

Answer 6

Array
(
    [1] => Array
        (
            [areaid] => 1
            [name] => 北京
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 1,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,531
        )
 
    [2] => Array
        (
            [areaid] => 2
            [name] => 上海
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 2,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,532
        )
 
    [26] => Array
        (
            [areaid] => 26
            [name] => 天津
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 26,516,517,518,519,520,521,522,523,524,525,526,527,528,529,534,571,572
        )
 
    [4] => Array
        (
            [areaid] => 4
            [name] => 重庆
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 4,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,97,99,101,103,105,107,109,111,113,114,115,533,536,537,538,539
        )
 
    [7] => Array
        (
            [areaid] => 7
            [name] => 广东
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 7,116,117,119,121,123,126,129,131,136,139,143,148,153,157,162,166,170,186,192,198,202
        )
 
    [8] => Array
        (
            [areaid] => 8
            [name] => 广西
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 8,135,140,144,147,152,158,164,168,174,182,189,195,569,570
        )
 
    [17] => Array
        (
            [areaid] => 17
            [name] => 江苏
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 17,447,448,449,450,451,452,453,454,455,456,457,458,459,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568
        )
 
    [30] => Array
        (
            [areaid] => 30
            [name] => 浙江
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 30,373,374,375,376,377,378,379,380,381,382,383
        )
 
    [11] => Array
        (
            [areaid] => 11
            [name] => 河北
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 11,181,188,193,200,204,215,222,230,235,241,248
        )
 
    [13] => Array
        (
            [areaid] => 13
            [name] => 河南
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 13,205,212,219,226,232,240,246,252,256,259,263,267,271,276,277,278,280,547
        )
 
    [14] => Array
        (
            [areaid] => 14
            [name] => 湖北
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 14,214,221,227,233,238,245,251,257,261,266,270,273,540,544,545,546
        )
 
    [15] => Array
        (
            [areaid] => 15
            [name] => 湖南
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 15,424,425,426,427,428,429,430,431,432,433,434,435,436,543
        )
 
    [24] => Array
        (
            [areaid] => 24
            [name] => 山东
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 24,344,346,348,349,350,351,353,355,357,358,359,361,363,365,367,369,371
        )
 
    [23] => Array
        (
            [areaid] => 23
            [name] => 山西
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 23,506,507,508,509,510,511,512,513,514,515,535
        )
 
    [5] => Array
        (
            [areaid] => 5
            [name] => 福建
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 5,96,98,100,102,104,106,108,110,112
        )
 
    [31] => Array
        (
            [areaid] => 31
            [name] => 陕西
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 31,281,284,287,290,291,293,294,297,300,302
        )
 
    [19] => Array
        (
            [areaid] => 19
            [name] => 吉林
            [style] => 
            [parentid] => 0
            [arrparentid] => 0
            [child] => 1
            [arrchildid] => 19,471,472,473,474,475,476,477,478,542
        )
 
    
 
    ...
 
)