获取数据库中城市,并排序

//城市列表
public function get_city()
{
    $data = Yii::$app->db->createCommand("SELECT DISTINCT (city) FROM 表名 ")
        ->queryAll();
    // 将每个城市加上首字母
    foreach ($data as $k => $v) {
        $data[$k]['wordName'] = $this->get_First($v['city']);
    }
    //根据首字母进行分类
    foreach ($data as $k => $v) {
        if ($v['wordName'] == 'A') {
            $new_arrar['A']['w'] = 'A';
            $new_arrar['A']['c'][] = $v;
        }
        if ($v['wordName'] == 'B') {
            $new_arrar['B']['w'] = 'B';
            $new_arrar['B']['c'][] = $v;
        }
        if ($v['wordName'] == 'C') {
            $new_arrar['C']['w'] = 'C';
            $new_arrar['C']['c'][]= $v;
        }
        if ($v['wordName'] == 'D') {
            $new_arrar['D']['w'] = 'D';
            $new_arrar['D']['c'][] = $v;
        }
        if ($v['wordName'] == 'E') {
            $new_arrar['E']['w'] = 'E';
            $new_arrar['E']['c'][] = $v;
        }
        if ($v['wordName'] == 'F') {
            $new_arrar['F']['w'] = 'F';
            $new_arrar['F']['c'][] = $v;
        }
        if ($v['wordName'] == 'G') {
            $new_arrar['G']['w'] = 'G';
            $new_arrar['G']['c'][] = $v;
        }
        if ($v['wordName'] == 'H') {
            $new_arrar['H']['w'] = 'H';
            $new_arrar['H']['c'][] = $v;
        }
        if ($v['wordName'] == 'J') {
            $new_arrar['J']['w'] = 'J';
            $new_arrar['J']['c'][] = $v;
        }
        if ($v['wordName'] == 'K') {
            $new_arrar['K']['w'] = 'K';
            $new_arrar['K']['c'][] = $v;
        }
        if ($v['wordName'] == 'L') {
            $new_arrar['L']['w'] = 'L';
            $new_arrar['L']['c'][] = $v;
        }
        if ($v['wordName'] == 'M') {
            $new_arrar['M']['w'] = 'M';
            $new_arrar['M']['c'][] = $v;
        }
        if ($v['wordName'] == 'N') {
            $new_arrar['N']['w'] = 'N';
            $new_arrar['N']['c'][] = $v;
        }
        if ($v['wordName'] == 'O') {
            $new_arrar['O']['w'] = 'O';
            $new_arrar['O']['c'][] = $v;
        }
        if ($v['wordName'] == 'P') {
            $new_arrar['P']['w'] = 'P';
            $new_arrar['P']['c'][] = $v;
        }
        if ($v['wordName'] == 'Q') {
            $new_arrar['Q']['w'] = 'Q';
            $new_arrar['Q']['c'][] = $v;
        }
        if ($v['wordName'] == 'R') {
            $new_arrar['R']['w'] = 'R';
            $new_arrar['R']['c'][] = $v;
        }
        if ($v['wordName'] == 'S') {
            $new_arrar['S']['w'] = 'S';
            $new_arrar['S']['c'][] = $v;
        }
        if ($v['wordName'] == 'T') {
            $new_arrar['T']['w'] = 'T';
            $new_arrar['T']['c'][] = $v;
        }
        if ($v['wordName'] == 'W') {
            $new_arrar['W']['w'] = 'W';
            $new_arrar['W']['c'][] = $v;
        }
        if ($v['wordName'] == 'X') {
            $new_arrar['X']['w'] = 'X';
            $new_arrar['X']['c'][] = $v;
        }
        if ($v['wordName'] == 'Y') {
            $new_arrar['Y']['w'] = 'Y';
            $new_arrar['Y']['c'][] = $v;
        }
        if ($v['wordName'] == 'Z') {
            $new_arrar['Z']['w'] = 'Z';
            $new_arrar['Z']['c'][] = $v;
        }
    }
    ksort($new_arrar); //对数据进行ksort排序,以key的值升序排序
    //将key去除
    foreach ($new_arrar as $k=>$v){
        $del_key[]=$new_arrar[$k];
    }
    $httpres = array();
    $httpres['status'] = 1;
    $httpres['cityList']= $del_key;
    return $httpres;
}

//获取首字母
public function get_First($str)
{
    if (empty($str)) {
        return '';
    }
    $fchar = ord($str{0});
    if ($fchar >= ord('A') && $fchar <= ord('z')) return strtoupper($str{0});
    $s1 = iconv('UTF-8', 'gb2312', $str);
    $s2 = iconv('gb2312', 'UTF-8', $s1);
    $s = $s2 == $str ? $s1 : $str;
    $asc = ord($s{0}) * 256 + ord($s{1}) - 65536;
    if ($asc >= -20319 && $asc <= -20284) return 'A';
    if ($asc >= -20283 && $asc <= -19776) return 'B';
    if ($asc >= -19775 && $asc <= -19219) return 'C';
    if ($asc >= -19218 && $asc <= -18711) return 'D';
    if ($asc >= -18710 && $asc <= -18527) return 'E';
    if ($asc >= -18526 && $asc <= -18240) return 'F';
    if ($asc >= -18239 && $asc <= -17923) return 'G';
    if ($asc >= -17922 && $asc <= -17418) return 'H';
    if ($asc >= -17417 && $asc <= -16475) return 'J';
    if ($asc >= -16474 && $asc <= -16213) return 'K';
    if ($asc >= -16212 && $asc <= -15641) return 'L';
    if ($asc >= -15640 && $asc <= -15166) return 'M';
    if ($asc >= -15165 && $asc <= -14923) return 'N';
    if ($asc >= -14922 && $asc <= -14915) return 'O';
    if ($asc >= -14914 && $asc <= -14631) return 'P';
    if ($asc >= -14630 && $asc <= -14150) return 'Q';
    if ($asc >= -14149 && $asc <= -14091) return 'R';
    if ($asc >= -14090 && $asc <= -13319) return 'S';
    if ($asc >= -13318 && $asc <= -12839) return 'T';
    if ($asc >= -12838 && $asc <= -12557) return 'W';
    if ($asc >= -12556 && $asc <= -11848) return 'X';
    if ($asc >= -11847 && $asc <= -11056) return 'Y';
    if ($asc >= -11055 && $asc <= -10247) return 'Z';
    return null;
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值